Hi All,
I have a report which uses two tables. One table stores the main data of the report while the other stores just the parameters values (say department numbers and names). I have used the second table in my report to show cascading parameters. Both tables are in the same schema. I have scheduled this report in Business Objects.
When I run my report, I can see the records and even can drill down. But when I try to change the parameter values I am prompted to enter the schema name and password. It should not ask username and password rather it should use the same credentials as used to schedule the report.
Any help in this regard will be highly appreciated.
Thanks,
Zahid