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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics