Hi
I have a qvd with more than 5 lakh records.
But when running the report user will be selecting one of the record.
I need to run a complex logic based on the user input or i have to run for all the records in the base qvd.
Running the logic for all the records in the base qvd takes many hours(which is not acceptable).
Can somebody tell us whether we can derive the complex logic for only the selected input from the user.
E.x Report
Input : Input 1
Output : same as the table above. Input 1 and Output 1 can be derived for all the 5lakh records. but for the Output 2 it needs the complex logic.
| Input 1 | Output 1 | Output 2 |
|---|
| 1 | 11 | |
| 2 | 12 | |
| 3 | 32 | |
Input 1 and Output 1 can be generated into single qvd and this can be added to the input filter. Once it is selected the Output 2 column needs to be derived based on the input from the user using the complex logic.
is it possible to generate partial output from qvd and partial output from dynamic script execution with user input?
