For last couple of days i am working on the Master Detail Report. I heard Master Detail Reports involve outer joins in the Report which will affect the performance drastically. We have explained this scenario to our customers. We cant achieve the requirement of Customer without the Master Detail Query. Customer has accepted for this, since they compromised on the Prompts they are going to select are few. I have added a in the report. I tried to include a parameterized detail query, It shows a error when i am selecting the parameters for detail query since the filter condition for Master query is not valid. Later i modified the Master Query filter, then i am able to include the detail queries. Now only i know that the parameter filters of Master Query is validated before ReportNet it let us to include the detail query.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment