reporting only showing first 5 rows
I have a query that I'm doing a {select top 10 * from table1}, when I run my query in query designer I'm gettting all 10 rows back, however, when I bind the query to my chart, I'm only seeing the first 5 rows, however, I'm seeing 10 bars in my bar graph.
so its something like this
title 1 - bar for total
bar for total
title 2 - bar for total
bar for total
title 3 - bar for total
bar for total
and so one, is there in the report itself preventing me to see all 10 items and the total for each item?
(i didn't create the report, just binding data to it)
July 23rd, 2012 2:14pm
Hi CSharp !
Please make sure you don't have any data filters added in your report.
Thanks, Hasham Niaz
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2012 4:16pm
theres no filters
July 24th, 2012 8:26am
Hello CSharpCoder1,
Thank you to post your question on TechNet forum.
I consider that we need more information to analyze this issue. Can you provide the following things?
Please provide us the screenshot of the design on the report. Therefore, we can see how you configure the control.Please provide us the result dataset.Please post out the screenshot of the current status, so that we see whether it is a layout issue or control issue.
If you have any concerns, please tell us freely.
Regards,
Edward
TechNet Subscriber Support
If you are
TechNet Subscription user and have any feedback on our support quality, please send your feedback
here.Edward Zhu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2012 4:43am
Hi CsharpCoder1,
Things looks quite messy, if possible can u send me ur rdl file with sample data at amit.260183@hotmail.com
Amit
Please mark as answer if helpful
http://fascinatingsql.wordpress.com/
July 30th, 2012 4:55am
Hello CSharpCoder1,
I found that there is no update on this issue for a long time. I want to follow up to see whether the issue is solved on your side. If yes, would you like to share us the answer, which may be helpful to the other people?
Thanks,
EdwardEdward Zhu
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 18th, 2012 4:22am
You need to set the Interval of the y-axis to 1 (instead of the default Auto).
I figured this out my showing minor ticks (and noticed that the data was actually showing, but not the people's names - in my case).
August 25th, 2012 2:17pm