Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NickC
Yak Posting Veteran
68 Posts |
 Posted - 2011-11-01 : 10:19:00
|
| HelloBefore I start, I genuinely don't believe this can be done but other people assure me it can so if you look at this and think it cant be done, Id appreciate that being confirmed.I have a report which is split into four classes, lets say class 1 , class 2 , class 3 , class 4. It has a report header, let say it says reports by class.That report cannot be touched, now I've been asked to place it with several other reports as a subreport. I've created a report page, and placed all my sub reports in there - now for these reports (including one above - I cant see the report name because its in the header), I've been told to create a title for these - by either putting in rectangle or table with header, however when I do this, it either appears on first class then not at all, or all sorts of strange stuff like showing at bottom of each part of the class subreport.Hopefully this makes sense, spent a day doing this and going nuts! |
|
|
NickC
Yak Posting Veteran
68 Posts |
Posted - 2011-11-01 : 10:21:39
|
| So what Id want it to look like is<MAIN RERPORT> <SUB REPORT TITLE 1> <SUB REPORT 1 - CLASS 1> <SUB REPORT 1 - CLASS 2> <SUB REPORT 1 - CLASS 3> <SUB REPORT 1 - CLASS 4> <SUB REPORT 2 TITLE> <SUB REPORT 2>I should have mentioned when these arent needing to be grouped by class its fine. otherwise I cant do it, and dont think it can be done without moving header in the sub report to the body.ALso i hven't had a problem labelling the tabs for export to excel as title but thats not enough! :(Thanks to anyone who can help |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-01 : 11:54:41
|
| did you try adding a dummy group for subreports and try including the header in it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Adding a title to each instance of a subreport grp