Groups | Blog | Home
all groups > sql server reporting services > january 2007 >

sql server reporting services : How Run report with Subreport as LocalReport


mtczx232 NO[at]SPAM yahoo.com
1/14/2007 9:07:35 AM
I have report with SubReport that his query get parameter from master
report. when I run it on the server the Report Service run the
Subreport query for each line on the Master report with proper value of
parameter. But when I run it on Local , the Data came from my DataSet,
So how it's can be work?
Bruce L-C [MVP]
1/14/2007 1:24:01 PM
There is an event that you respond to. Essentially you have to do what the
server did for you. Take the passed parameters, get the data yourself. One
of there reasons I moved away from local reports was having to do things
like this.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

mtczx232 NO[at]SPAM yahoo.com
1/15/2007 2:50:38 AM
you can address the name of event?

you are sure that LocalReport not have ability to Fill the DataSet by
itself!?
Bruce L-C [MVP]
1/15/2007 10:44:24 PM
The whole way local reports work it you give it the data and the report. The
same is true for subreports.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Dan Cooperstock
2/6/2007 11:42:32 AM
"Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in
news:e9LweCSOHHA.4720@TK2MSFTNGP03.phx.gbl:

[quoted text, click to view]

Bruce, what is the name of the event that requests data for the Subreport,
and on what object is that event fired? I have scanned the ReportViewer
Events and I can't see anything that looks like it would be it.

OK, wait ... Is it the SubReportProcessing event on the LocalReport
property of the ReportViewer?

---------------------------
Dan Cooperstock
DONATION web site: http://www.FreeDonationSoftware.org
DONATION Support forums: http://forums.FreeDonationSoftware.org
E-mail: mailto:info@FreeDonationSoftware.org
Bruce L-C [MVP]
2/6/2007 1:57:16 PM
Sorry, I can't help you here. At one point I found the event and it was then
that I realized I just did not want to be messing with it. I had a server
that I was not going to be getting rid of (it was only going to be a subset
of the reports for a winform app that I was looking at using local reports).
I decided to not use local reports due to all the extra work.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button