We help IT Professionals succeed at work.

Put a table inside a table SQL Server Reporting Services

cjohnson300
cjohnson300 asked
on
1,763 Views
Last Modified: 2012-05-08
I have been trying to put a table within a table row, but running into some problems.

I have tried to put it in a table footer row by merging all the cells into one and then adding the table, but when I go to preview i just get a message saying:
An error occurred during local report processing.  An internal error occurred on the report server.  See the error log for more details

Where is this error log?  Why will it let me add the table to a single cell BEFORE i merge all the row's cells together but not after?  Am I just better off using a subreport (although I do have potentially three other tables to add to my "master" table)?

Many thanks in advance
Comment
Watch Question

cjohnson,

Are you trying to put 3 dataset's into one table object in SSRS? If so that won't work.  SSRS Doesn't really have a concept of relational tables.  (They should, but they don't!)

If you could get your data into a normalized view, that is one query with all the information you need.  You could take advantage of group headers & footers to layout the information.

The other option as you suggested would be a subreport.

Author

Commented:
I have one dataset, but each table is a subset of it using Filters.  The reason I have used one report and not subreports already is to hopefully increase its efficiency, and the only reason I wanted to put a table into another table is for formatting reasons, not functional.

If its not possible I will try grouping the data somehow first and then going down the subreport road
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
the only thing i can use is the length of one of the fields
Maybe add another field onto your query to indicate what type of data it is?

In my example i'd have a field that would say M or L

Author

Commented:
check that, i do have one, that gives me anew avenue to pursue, thanks!
Good luck, :D

Author

Commented:
couldn't get that to work, i think I'll just have one dataset for each table in the future
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.