Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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