• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

Table with a Table?

Is it possible to nest a table within a table?
0
Trancedified
Asked:
Trancedified
  • 3
  • 2
1 Solution
 
TrancedifiedAuthor Commented:
I'm using Reporting Services 2005.
0
 
Hendrik WieseInformation Security ManagerCommented:
I dont know why one would want to do this. Please explain why you would want to nest a table within a table?
0
 
TrancedifiedAuthor Commented:
After some research I think the grouping in tables will work, but I'm having a hard time finding information on that.

Do you have any guides? Thanks for replying, HendrikWiese
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Mark WillsTopic AdvisorCommented:
Yes you can, there are a couple of ways to achieve this.  Also depends on what you are really asking / experience.

but it is not neccessarily a table grid within another table grid as such. Which incidentally can be done.

The "easiest" is to get a control break type thing happening or Master Detail report where the main table is the master and the nested table is the detail

Have a look at : http://www.codeproject.com/KB/reporting-services/1tomanyreports_vsnet2005.aspx

And more sample reports on : http://msftrsprodsamples.codeplex.com/Wiki/View.aspx?title=SS2005%21AdventureWorks%20Sample%20Reports

The next way is to use a sub-report : http://www.simple-talk.com/content/print.aspx?article=278

And if new, then found this to be a good general manual : http://www.scribd.com/doc/5405002/MS-SQL-REPORTING-SERVICES-final2

Now, there is still special grids where you can do tables within table (grids) as the final option - and maybe you have already seen / considered the above and really want it, but there are some gotcha's so please consider the rest first...
0
 
TrancedifiedAuthor Commented:
Thanks Mark,

I think this would work for other situations, but I was able to find a solution here:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/642566e2-c935-4754-8e0a-f2dceac55e5f
0
 
Mark WillsTopic AdvisorCommented:
Yep, that will do it. Even easier in having a detail report with "hide dupes". That is the great thing about report writes - they normally have several methods of being able to present data, and the number one rule of data design is "what do you want to get out of it".

Thanks for the points, and very happy to help.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now