Grid & Chart - Not on same page?
-
Tuesday, January 01, 2013 2:22 PM
Hi All,
I have a Grid and a chart and after running the multi paged report the page breaks are correct, meaning the correct grid data is displaying based on the page break/groups. But the last page only puts the chart on the last page. I need the chart to be grouped like the other pages and included on the page.
I realize you can just put the chart into the tablix, but in my case not sure how I can do this and make it look good. Below is my structure.
(Column Group) <-Repeats
Row
Example Grid Output:
1am 2am 3am 4am 5am etc.
Count 45 23 4 76 12
Because the right column is grouped I cannot create a new row in design and merge the two columns to put the chart into it, it wont allow it. Plus, each page doesn't always have the same amount of columns to I don't want the chart to get squished.
There must be a way to have a chart without putting it in the tablix and still have it grouped and placed on the same page.
Desired Output:
1am 2am 3am 4am 5am etc.
Count 45 23 4 76 12
______________________________________
- -
- My Chart :) -
- -
______________________________________
Flexpadawan
All Replies
-
Tuesday, January 01, 2013 2:44 PM
Can you try putting the tablix and chart inside a list?
http://technet.microsoft.com/en-us/library/dd239330.aspx
Cheers,
Jason | www.SqlJason.com
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
- Marked As Answer by flexpadawan Tuesday, January 01, 2013 4:58 PM
-
Tuesday, January 01, 2013 2:54 PM
I have tried that but I get an error saying:
Error 5 [rsInvalidDetailDataGrouping] The chart ‘Chart2’ has a detail member with inner members. Detail members can only contain static inner members. C:\Users\Flex\Documents\Visual Studio 2010\Projects\My Reports\WIP2.rdl 0 0
All I did was drag a list control onto the body and cut and pasted the grid and chart into it. Is there something else I should do?
Thanks!
Flexpadawan
-
Tuesday, January 01, 2013 3:00 PM
Can you give more details like:-
1) Datasets used for Grid and Chart (Hopefully it is the same)
2) The fields in the datasets
3) Fields in the datasets that are used in Grid
4) Fields in the datasets that are used in Chart
5) Desired output in terms of fields (I can see that you have already pasted the output, but I just want to make sure what are the fields that you are placing in the grid. Also, what fields should be in the chart and what should be the pagebreak condition?)
Please ensure that all the points are there in your reply, would help to resolve this faster :)
Cheers,
Jason | www.SqlJason.com
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :) -
Tuesday, January 01, 2013 3:35 PM
Hi,
Rectangles are also used as containers to help control the way data regions render in a report.
http://technet.microsoft.com/en-us/library/dd255244.aspx
http://technet.microsoft.com/en-us/library/dd239352.aspx
Thanks & Regards, sathya
-
Tuesday, January 01, 2013 3:43 PM
I've tried this as well....no errors mind you not like using a list control as stated above. The output is still the same where the grid shows correctly on every page as it should, but the last page shows the chart.
Even if I do figure out how to put a chart and tablix into the same rectangle, I'm not sure how to get the chart to do the same grouping....perhaps this is where my problem is. I'll keep digging. :)
Flexpadawan
-
Tuesday, January 01, 2013 3:55 PM
Hopefully this answers your questions.
1) Datasets used for Grid and Chart (Hopefully it is the same) - Yes
2) The fields in the datasets - (Location, Count, QTY, Time)
3) Fields in the datasets that are used in Grid - As per #2
4) Fields in the datasets that are used in Chart - As per #2
5) Desired output in terms of fields (I can see that you have already pasted the output, but I just want to make sure what are the fields that you are placing in the grid. Also, what fields should be in the chart and what should be the pagebreak condition?)
Note: In the tablix I have a row grouping by Location and a column grouping by time. So by doing this each page will provide me a grid by location and a repeating column of times that are in the record set.
Desired Output:
New York 1am 2am 3am 4am 5am etc.
Count 45 23 4 76 12
______________________________________
- -
- My Chart :) -
- -
______________________________________
The chart is just a basic bar chart should use the exact same values as to what is in the tablix. In other related replies to this thread I've also tried putting the tablix and chart into a rectangle, but it does the same thing...chart ends up on the last page and it doesn't follow the same grouping criteria as the tablix does.
So far the only way I can get the chart to work is by putting it inside a cell, but this looks really bad as an output.
Thanks for your advice on this Jason.
Flexpadawan
-
Tuesday, January 01, 2013 4:36 PMI got the list control sort of working without error. After inserting the control I added a grouping of location, then i cut and pasted my grid and chart into it. The report runs but again the chart shows up on the last page.
Flexpadawan
- Edited by flexpadawan Tuesday, January 01, 2013 4:41 PM spelling
-
Tuesday, January 01, 2013 4:57 PM
What I ended up doing is build the report from scratch and it worked using the List Control. Cutting and Pasting existing work into the list for some reason had issues that caused my problems.
At the end of this the solution is to use the List Control to do this type of free form design.
Anybody new to List Control here is a good URL tip to get started. List Control
Flexpadawan
- Marked As Answer by flexpadawan Tuesday, January 01, 2013 4:58 PM
.png)
