Subreport always appears blank (even during basic testing with no parameters!)
in [Reports]
|
From: Zack G on 3 May 2010 12:35 If I run it manually, the same thing happens - the report does not appear and there are no errors. If I insert an incorrect parameter, I get an error which suggests that the report is running (when the parameters are properly entered) but simply not appearing. Zack On May 3, 9:57 am, "Bruce L-C [MVP]" <Bruce_LCNOS...(a)Hotmail.com> wrote: > I assume you have run the subreport by itself manually providing the > appropriate parameters. What happens when you do that? > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Zack G" <z.gallin...(a)gmail.com> wrote in message > > news:201ec593-60c3-445d-b1fd-9493937738c7(a)d39g2000yqa.googlegroups.com... > > > I wanted to add one more piece of information. If I hide the subreport > > (and place a text field on the main report), the text field prints > > about halfway down the page, as if the subreport is pushing it down > > the page (as expected). If the subreport is set to visible, the text > > field prints in the top left corner of the page as if the subreport is > > not even on the page. So strange... > > > On Apr 30, 1:21 pm, Zack G <z.gallin...(a)gmail.com> wrote: > >> The subreport is in the same project and folder and it is not working > >> in the preview tab or when deployed. It's pretty bizarre. I've been > >> working with SRS for awhile and I've never seen anything like this. > > >> On Apr 30, 1:02 pm, "Bruce L-C [MVP]" <Bruce_LCNOS...(a)Hotmail.com> > >> wrote: > > >> > Is it not working in preview tab or when deployed? Is the subreport > >> > from the > >> > same project/folder? > > >> > -- > >> > Bruce Loehle-Conger > >> > MVP SQL Server Reporting Services > > >> > "Zack G" <z.gallin...(a)gmail.com> wrote in message > > >> >news:0634f709-e0a5-4657-9bc0-08e030e38fc0(a)d39g2000yqa.googlegroups.com... > > >> > > I have a subreport in my report that takes a set of basic parameters. > >> > > It does not appear on my main report when the main report is run. > > >> > > As a test, I decided to create a simple subreport with no parameters > >> > > and only a text field. It also does not display on my report. > > >> > > As a further test, I decided to create an entirely new project with > >> > > only a main report and a subreport that displays the word "test". It > >> > > will still not display on my main report. > > >> > > There are no errors at any stage. Does anybody have any idea as to > >> > > what could be wrong? > > >> > > Zack
From: Bruce L-C [MVP] on 3 May 2010 12:58
This is important. This is not a subreport problem. It is a report problem. You need to get this working standalone. Something is wrong with your report. Focus on the report you want to use as a subreport. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "Zack G" <z.gallinger(a)gmail.com> wrote in message news:831df094-92f2-494a-babe-eb639d4a16bc(a)j33g2000yqn.googlegroups.com... > If I run it manually, the same thing happens - the report does not > appear and there are no errors. If I insert an incorrect parameter, I > get an error which suggests that the report is running (when the > parameters are properly entered) but simply not appearing. > > Zack > > > On May 3, 9:57 am, "Bruce L-C [MVP]" <Bruce_LCNOS...(a)Hotmail.com> > wrote: >> I assume you have run the subreport by itself manually providing the >> appropriate parameters. What happens when you do that? >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Zack G" <z.gallin...(a)gmail.com> wrote in message >> >> news:201ec593-60c3-445d-b1fd-9493937738c7(a)d39g2000yqa.googlegroups.com... >> >> > I wanted to add one more piece of information. If I hide the subreport >> > (and place a text field on the main report), the text field prints >> > about halfway down the page, as if the subreport is pushing it down >> > the page (as expected). If the subreport is set to visible, the text >> > field prints in the top left corner of the page as if the subreport is >> > not even on the page. So strange... >> >> > On Apr 30, 1:21 pm, Zack G <z.gallin...(a)gmail.com> wrote: >> >> The subreport is in the same project and folder and it is not working >> >> in the preview tab or when deployed. It's pretty bizarre. I've been >> >> working with SRS for awhile and I've never seen anything like this. >> >> >> On Apr 30, 1:02 pm, "Bruce L-C [MVP]" <Bruce_LCNOS...(a)Hotmail.com> >> >> wrote: >> >> >> > Is it not working in preview tab or when deployed? Is the subreport >> >> > from the >> >> > same project/folder? >> >> >> > -- >> >> > Bruce Loehle-Conger >> >> > MVP SQL Server Reporting Services >> >> >> > "Zack G" <z.gallin...(a)gmail.com> wrote in message >> >> >> >news:0634f709-e0a5-4657-9bc0-08e030e38fc0(a)d39g2000yqa.googlegroups.com... >> >> >> > > I have a subreport in my report that takes a set of basic >> >> > > parameters. >> >> > > It does not appear on my main report when the main report is run. >> >> >> > > As a test, I decided to create a simple subreport with no >> >> > > parameters >> >> > > and only a text field. It also does not display on my report. >> >> >> > > As a further test, I decided to create an entirely new project >> >> > > with >> >> > > only a main report and a subreport that displays the word "test". >> >> > > It >> >> > > will still not display on my main report. >> >> >> > > There are no errors at any stage. Does anybody have any idea as to >> >> > > what could be wrong? >> >> >> > > Zack > |