all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Subreports


Subreports Weston Weems
8/27/2005 7:28:27 AM
sql server reporting services: I understand the concept of subreports and their wiring... but if I have
a table thats bound to some data, and for each record in that table, I'd
like to spit out a basic subreport, should I not then be able to just
stick it in the table detail row?

I get table cell cannot contain subreport etc.

Thanks in advance
Weston Weems

BTW: I got a book on order, so this seemingly beginners questions will
Re: Subreports Bruce L-C [MVP]
8/27/2005 8:53:36 PM
Is this a matrix or a table that you are trying to embed a subreport into
the detail row. I do this with a table. Although I am trying to remember if
it is a single field in the subreport or multiple. The subreport can return
multiple rows and that is not a problem. Works great.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Subreports Wayne Snyder
8/28/2005 8:47:06 AM
Do some early testing for performance however... Each sub report is a new
report run , and can cause the performance to suffer.

We try to avoid subreports ( generally), even though they allow better
inter-operability.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Re: Subreports Weston Weems
8/28/2005 8:54:12 AM
Yep...

Also, not that it makes everything better, but these will be scheduled
reports, not reports that will be run at just any time... So if they are a
tad slwoer in initial generation, its reports that are safe to cache etc.

Thanks for the input, If it looks I can get away doing it in one, I will
definately do that.

Weston Weems

[quoted text, click to view]

AddThis Social Bookmark Button