| Groups | Blog | Home |
sql server reporting services : nested data regions
different dataset but using the same data source. I am trying to nest these and I've put the second data table in the group footer of the first. How can I have the second data table work properly and filter by the current group field value of the first data table. The reporting services documentation is not clear. Just testing it I am getting errors such as: c:\inetpub\wwwroot\wcr\wcrreports\rptWCR_.rdl The value expression for the textbox 'Comment' refers to the field 'Comment'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. The reason I moved it into a seperate data region from a sub report is because I could not find a way for the subreport to NOT "keep together". Thanks for helping...
Also,
Even though I have set the dataset of the second data table to a different data set than the first table, the only fields that show up in the value property for text boxes in the second data table are fields from the first data table. I am getting frustrated... [quoted text, click to view] "D Witherspoon" <dwitherspoon@noway.org> wrote in message news:Oc76I6eGFHA.3072@tk2msftngp13.phx.gbl... >I am trying to nest 2 data regions. I have two data tables using a >different dataset but using the same data source. > > I am trying to nest these and I've put the second data table in the group > footer of the first. How can I have the second data table work properly > and filter by the current group field value of the first data table. The > reporting services documentation is not clear. > > Just testing it I am getting errors such as: > > c:\inetpub\wwwroot\wcr\wcrreports\rptWCR_.rdl The value expression for the > textbox 'Comment' refers to the field 'Comment'. Report item expressions > can only refer to fields within the current data set scope or, if inside > an aggregate, the specified data set scope. > > > The reason I moved it into a seperate data region from a sub report is > because I could not find a way for the subreport to NOT "keep together". > > Thanks for helping... > > >
Nested data regions have to share the same data set. The closest you can get
is to use subreports - they are independent reports and will retrieve the data on their own (you can pass parameters to subreports). -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "D Witherspoon" <dwitherspoon@noway.org> wrote in message news:Oz%23MDAfGFHA.3876@TK2MSFTNGP14.phx.gbl... > Also, > > Even though I have set the dataset of the second data table to a different > data set than the first table, the only fields that show up in the value > property for text boxes in the second data table are fields from the first > data table. > > I am getting frustrated... > > "D Witherspoon" <dwitherspoon@noway.org> wrote in message > news:Oc76I6eGFHA.3072@tk2msftngp13.phx.gbl... >>I am trying to nest 2 data regions. I have two data tables using a >>different dataset but using the same data source. >> >> I am trying to nest these and I've put the second data table in the group >> footer of the first. How can I have the second data table work properly >> and filter by the current group field value of the first data table. The >> reporting services documentation is not clear. >> >> Just testing it I am getting errors such as: >> >> c:\inetpub\wwwroot\wcr\wcrreports\rptWCR_.rdl The value expression for >> the textbox 'Comment' refers to the field 'Comment'. Report item >> expressions can only refer to fields within the current data set scope >> or, if inside an aggregate, the specified data set scope. >> >> >> The reason I moved it into a seperate data region from a sub report is >> because I could not find a way for the subreport to NOT "keep together". >> >> Thanks for helping... >> >> >> > >
Will this (nested reports with different datasets) be possible in the next
version of the MS Reporting Services? [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Nested data regions have to share the same data set. The closest you can get > is to use subreports - they are independent reports and will retrieve the > data on their own (you can pass parameters to subreports). > > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "D Witherspoon" <dwitherspoon@noway.org> wrote in message > news:Oz%23MDAfGFHA.3876@TK2MSFTNGP14.phx.gbl... > > Also, > > > > Even though I have set the dataset of the second data table to a different > > data set than the first table, the only fields that show up in the value > > property for text boxes in the second data table are fields from the first > > data table. > > > > I am getting frustrated... > > > > "D Witherspoon" <dwitherspoon@noway.org> wrote in message > > news:Oc76I6eGFHA.3072@tk2msftngp13.phx.gbl... > >>I am trying to nest 2 data regions. I have two data tables using a > >>different dataset but using the same data source. > >> > >> I am trying to nest these and I've put the second data table in the group > >> footer of the first. How can I have the second data table work properly > >> and filter by the current group field value of the first data table. The > >> reporting services documentation is not clear. > >> > >> Just testing it I am getting errors such as: > >> > >> c:\inetpub\wwwroot\wcr\wcrreports\rptWCR_.rdl The value expression for > >> the textbox 'Comment' refers to the field 'Comment'. Report item > >> expressions can only refer to fields within the current data set scope > >> or, if inside an aggregate, the specified data set scope. > >> > >> > >> The reason I moved it into a seperate data region from a sub report is > >> because I could not find a way for the subreport to NOT "keep together". > >> > >> Thanks for helping... > >> > >> > >> > > > > > >
Are you really asking for "nested reports with different datasets" rather
than nested data regions with different datasets? This would be subreports and it is available in RS 2000. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Hawkeye" <Hawkeye@discussions.microsoft.com> wrote in message news:FF18A969-9F6E-41A1-A001-05AD5EC475D7@microsoft.com... > Will this (nested reports with different datasets) be possible in the next > version of the MS Reporting Services? > > "Robert Bruckner [MSFT]" wrote: > >> Nested data regions have to share the same data set. The closest you can >> get >> is to use subreports - they are independent reports and will retrieve the >> data on their own (you can pass parameters to subreports). >> >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "D Witherspoon" <dwitherspoon@noway.org> wrote in message >> news:Oz%23MDAfGFHA.3876@TK2MSFTNGP14.phx.gbl... >> > Also, >> > >> > Even though I have set the dataset of the second data table to a >> > different >> > data set than the first table, the only fields that show up in the >> > value >> > property for text boxes in the second data table are fields from the >> > first >> > data table. >> > >> > I am getting frustrated... >> > >> > "D Witherspoon" <dwitherspoon@noway.org> wrote in message >> > news:Oc76I6eGFHA.3072@tk2msftngp13.phx.gbl... >> >>I am trying to nest 2 data regions. I have two data tables using a >> >>different dataset but using the same data source. >> >> >> >> I am trying to nest these and I've put the second data table in the >> >> group >> >> footer of the first. How can I have the second data table work >> >> properly >> >> and filter by the current group field value of the first data table. >> >> The >> >> reporting services documentation is not clear. >> >> >> >> Just testing it I am getting errors such as: >> >> >> >> c:\inetpub\wwwroot\wcr\wcrreports\rptWCR_.rdl The value expression for >> >> the textbox 'Comment' refers to the field 'Comment'. Report item >> >> expressions can only refer to fields within the current data set scope >> >> or, if inside an aggregate, the specified data set scope. >> >> >> >> >> >> The reason I moved it into a seperate data region from a sub report is >> >> because I could not find a way for the subreport to NOT "keep >> >> together". >> >> >> >> Thanks for helping... >> >> >> >> >> >> >> > >> > >> >> >>
What I ment is to use a table in a table - both use different datasets. Ok, a
solution is to use subreports in a table, but with the disadvantages (do they really exist?) - the user can run a subreport for itself - how to share report parameters (without copying them)? [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Are you really asking for "nested reports with different datasets" rather > than nested data regions with different datasets? This would be subreports > and it is available in RS 2000. > > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Hawkeye" <Hawkeye@discussions.microsoft.com> wrote in message > news:FF18A969-9F6E-41A1-A001-05AD5EC475D7@microsoft.com... > > Will this (nested reports with different datasets) be possible in the next > > version of the MS Reporting Services? > > > > "Robert Bruckner [MSFT]" wrote: > > > >> Nested data regions have to share the same data set. The closest you can > >> get > >> is to use subreports - they are independent reports and will retrieve the > >> data on their own (you can pass parameters to subreports). > >> > >> > >> -- Robert > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> "D Witherspoon" <dwitherspoon@noway.org> wrote in message > >> news:Oz%23MDAfGFHA.3876@TK2MSFTNGP14.phx.gbl... > >> > Also, > >> > > >> > Even though I have set the dataset of the second data table to a > >> > different > >> > data set than the first table, the only fields that show up in the > >> > value > >> > property for text boxes in the second data table are fields from the > >> > first > >> > data table. > >> > > >> > I am getting frustrated... > >> > > >> > "D Witherspoon" <dwitherspoon@noway.org> wrote in message > >> > news:Oc76I6eGFHA.3072@tk2msftngp13.phx.gbl... > >> >>I am trying to nest 2 data regions. I have two data tables using a > >> >>different dataset but using the same data source. > >> >> > >> >> I am trying to nest these and I've put the second data table in the > >> >> group > >> >> footer of the first. How can I have the second data table work > >> >> properly > >> >> and filter by the current group field value of the first data table. > >> >> The > >> >> reporting services documentation is not clear. > >> >> > >> >> Just testing it I am getting errors such as: > >> >> > >> >> c:\inetpub\wwwroot\wcr\wcrreports\rptWCR_.rdl The value expression for > >> >> the textbox 'Comment' refers to the field 'Comment'. Report item > >> >> expressions can only refer to fields within the current data set scope > >> >> or, if inside an aggregate, the specified data set scope. > >> >> > >> >> > >> >> The reason I moved it into a seperate data region from a sub report is > >> >> because I could not find a way for the subreport to NOT "keep > >> >> together". > >> >> > >> >> Thanks for helping... > >> >> > >> >> > >> >> > >> > > >> > > >> > >> > >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |