peterb58
IS-IT--Management
- Mar 20, 2005
- 110
Using CRX1 SP 4 on a SYbase 9.02 database under WInXP
I have a SP in my DB which requires 3 parameters. StartDate, EndDate and Authority. The Authority is an Integer which is used to determine the owner of the data by look up to another table.
If I leave the report at default and let the user enter an Integer for Authority, all woks OK. The report returns the appropriate data.
However if I try set the Authority as a Dynamic parameter by using data in the Authority table, I get another prompt box, relating to the dynamic parameter. This second prompt also has boxes for my dates, but not suing the information defined in their setup.
Anyone know what is going on?
Pete
I have a SP in my DB which requires 3 parameters. StartDate, EndDate and Authority. The Authority is an Integer which is used to determine the owner of the data by look up to another table.
If I leave the report at default and let the user enter an Integer for Authority, all woks OK. The report returns the appropriate data.
However if I try set the Authority as a Dynamic parameter by using data in the Authority table, I get another prompt box, relating to the dynamic parameter. This second prompt also has boxes for my dates, but not suing the information defined in their setup.
Anyone know what is going on?
Pete