Parameters to Subreports within a matrix

We have a recurring project status report that uses a matrix (each matrix group is for an individual project). The name of the project renders fine and displays in the group, but when we try to pass this same value as a parameter to a subreport (a graph) which we also want to display in the matrix the subreport is only renderd for the last instance of the matrix group (i.e. 4 of 4 has it but 1-3 show a blank field in the matrix).

I assume this has something to do with using parameters within the matrix control, but didn't find any posts about that.

I should add another way we've tried to do this is with a list instead of a matrix and it also fails in the same way (doesn't render all of the subreports).

Thanks for the help,

-p

This may be caued by an interaction between SQL and the Dundas control I'm using. I'm not 100% sure, but thought I'd post this if anyone out there is having a similar problem.

http://support.dundas.com/forum/m.aspx?m=1978&mpage=1&key=subreport

I'll post an answer if I figure out one.

|||As mentioned in the link SP2 fixed this.

Parameters in a matrix table

I have a matrix report with a start date & end date parameter. when i run the
query in the data payne eveything works fine. when i run the report in the
preview pane, the matrix table returns the entire data in the database. same
occurs when i add a table. what am i missing' thanks in advanceDo you have default values for your parameters? Open Report\Report
Parameters from the main menu, setup available values and default
values for your parameters.
Good luck.
Henry
Tango wrote:
> I have a matrix report with a start date & end date parameter. when i
run the
> query in the data payne eveything works fine. when i run the report
in the
> preview pane, the matrix table returns the entire data in the
database. same
> occurs when i add a table. what am i missing' thanks in advance|||thanks for your help but ive done that. default is today
"fanh@.tycoelectronics.com" wrote:
> Do you have default values for your parameters? Open Report\Report
> Parameters from the main menu, setup available values and default
> values for your parameters.
> Good luck.
> Henry
>
> Tango wrote:
> > I have a matrix report with a start date & end date parameter. when i
> run the
> > query in the data payne eveything works fine. when i run the report
> in the
> > preview pane, the matrix table returns the entire data in the
> database. same
> > occurs when i add a table. what am i missing' thanks in advance
>|||it was the filters in the matrix properties
thanks to me for working this out
"Tango" wrote:
> thanks for your help but ive done that. default is today
> "fanh@.tycoelectronics.com" wrote:
> > Do you have default values for your parameters? Open Report\Report
> > Parameters from the main menu, setup available values and default
> > values for your parameters.
> > Good luck.
> >
> > Henry
> >
> >
> > Tango wrote:
> > > I have a matrix report with a start date & end date parameter. when i
> > run the
> > > query in the data payne eveything works fine. when i run the report
> > in the
> > > preview pane, the matrix table returns the entire data in the
> > database. same
> > > occurs when i add a table. what am i missing' thanks in advance
> >
> >