cjohnson300
asked on
Put a table inside a table SQL Server Reporting Services
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
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
ASKER
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
If its not possible I will try grouping the data somehow first and then going down the subreport road
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
In my example i'd have a field that would say M or L
ASKER
check that, i do have one, that gives me anew avenue to pursue, thanks!
Good luck, :D
ASKER
couldn't get that to work, i think I'll just have one dataset for each table in the future
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.