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
> >
> >
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment