SSRS Line Chart Same Date on x-axis
up vote
0
down vote
favorite
I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.
=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))
However, when the start date and end date is the same for eg: 11-20-2018 then the x-axis shows 11-20-2018 multiple times and 11-21-2018(which is not an end date) where i need to show it only once. Please suggest how to achieve.
This is what is required
reporting-services ssrs-2008
edited Nov 20 at 18:34
James Z
11.1k71735
asked Nov 19 at 19:46
ashishsingh92
301111
|
show 2 more comments
up vote
0
down vote
favorite
I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.
=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))
However, when the start date and end date is the same for eg: 11-20-2018 then the x-axis shows 11-20-2018 multiple times and 11-21-2018(which is not an end date) where i need to show it only once. Please suggest how to achieve.
This is what is required
reporting-services ssrs-2008
edited Nov 20 at 18:34
James Z
11.1k71735
asked Nov 19 at 19:46
ashishsingh92
301111
1
I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 at 19:56
Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 at 7:49
@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 at 11:54
@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 at 12:00
Does it help when you go to yourHorizontal Axis Propertiesand set the intervall to1?
– Strawberryshrub
Nov 20 at 12:42
|
show 2 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.
=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))
However, when the start date and end date is the same for eg: 11-20-2018 then the x-axis shows 11-20-2018 multiple times and 11-21-2018(which is not an end date) where i need to show it only once. Please suggest how to achieve.
This is what is required
reporting-services ssrs-2008
edited Nov 20 at 18:34
James Z
11.1k71735
asked Nov 19 at 19:46
ashishsingh92
301111
I build a line chart wherein x-axis need to show only start date and end date while removing the middle dates. So I have achieved that by the scalar expression.
=datediff("d",first(Fields!Date.Value),last(Fields!Date.Value))
However, when the start date and end date is the same for eg: 11-20-2018 then the x-axis shows 11-20-2018 multiple times and 11-21-2018(which is not an end date) where i need to show it only once. Please suggest how to achieve.
This is what is required
reporting-services ssrs-2008
reporting-services ssrs-2008
edited Nov 20 at 18:34
James Z
11.1k71735
asked Nov 19 at 19:46
ashishsingh92
301111
edited Nov 20 at 18:34
James Z
11.1k71735
asked Nov 19 at 19:46
ashishsingh92
301111
edited Nov 20 at 18:34
James Z
11.1k71735
edited Nov 20 at 18:34
James Z
11.1k71735
edited Nov 20 at 18:34
James Z
11.1k71735
11.1k71735
asked Nov 19 at 19:46
ashishsingh92
301111
asked Nov 19 at 19:46
ashishsingh92
301111
asked Nov 19 at 19:46
ashishsingh92
301111
301111
1
I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 at 19:56
Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 at 7:49
@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 at 11:54
@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 at 12:00
Does it help when you go to yourHorizontal Axis Propertiesand set the intervall to1?
– Strawberryshrub
Nov 20 at 12:42
|
show 2 more comments
1
I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 at 19:56
Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 at 7:49
@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 at 11:54
@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 at 12:00
Does it help when you go to yourHorizontal Axis Propertiesand set the intervall to1?
– Strawberryshrub
Nov 20 at 12:42
1
1
I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 at 19:56
I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 at 19:56
Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 at 7:49
Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 at 7:49
@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 at 11:54
@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 at 11:54
@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 at 12:00
@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 at 12:00
Does it help when you go to your
Horizontal Axis Properties and set the intervall to 1?– Strawberryshrub
Nov 20 at 12:42
Does it help when you go to your
Horizontal Axis Properties and set the intervall to 1?– Strawberryshrub
Nov 20 at 12:42
|
show 2 more comments
1 Answer
1
active
oldest
votes
up vote
0
down vote
I think there are two ways what you can do.
First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.
Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:
'Expression
=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)
'Format
=Boolean
'Value
=True
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381628%2fssrs-line-chart-same-date-on-x-axis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I think there are two ways what you can do.
First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.
Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:
'Expression
=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)
'Format
=Boolean
'Value
=True
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
add a comment |
up vote
0
down vote
I think there are two ways what you can do.
First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.
Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:
'Expression
=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)
'Format
=Boolean
'Value
=True
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
add a comment |
up vote
0
down vote
up vote
0
down vote
I think there are two ways what you can do.
First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.
Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:
'Expression
=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)
'Format
=Boolean
'Value
=True
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
I think there are two ways what you can do.
First one would be to use just one parameter (with the option to allow multiple values). So just the dates you chose from the parameter would appear in the chart.
Second one would be to use a filter in your chart. Go to your Chart Properties > Filters and add the following filter:
'Expression
=IIF(CDate(Fields!YourDate.Value) = CDate(Parameters!YourFirstDate.Value) Or CDate(Fields!YourDate.Value) = CDate(Parameters!YourSecondDate.Value), True, False)
'Format
=Boolean
'Value
=True
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
answered Nov 21 at 5:41
Strawberryshrub
1,0961216
1,0961216
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
add a comment |
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
didn't work for both suggestion!
– ashishsingh92
Nov 27 at 14:07
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381628%2fssrs-line-chart-same-date-on-x-axis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
I don't see much difference in your pictures. Am I just blind?
– James Z
Nov 19 at 19:56
Possible duplicate of stackoverflow.com/questions/40591370/…
– Strawberryshrub
Nov 20 at 7:49
@JamesZ question edited. There was a duplicate image attached. Apologize for that.
– ashishsingh92
Nov 20 at 11:54
@Strawberryshrub this is not what im exactly looking for!
– ashishsingh92
Nov 20 at 12:00
Does it help when you go to your
Horizontal Axis Propertiesand set the intervall to1?– Strawberryshrub
Nov 20 at 12:42