i need to ask , if i have report read from two data sours and the only key between these two report is is ID how can i do LEVEL on the ID to get the data for both in the same ID.
what happens with me is when i put a LEVEL for the ID it will bring both in the LEVEL format but the first report will be in details like if i have 5 branches in the first report and in the second i have the complaints the first report will come in details for the five branches but the second part will come accumulative( Complaints ) and repeated in the five report with the same data.
the question is : 1.how can i do the LEVEL in this case.
2. how can i do partial load from two different report and merge it in one report in the output file.
It is possible to perform an incremental load with NPrinting Partial reload task. The NPrinting reload task will also reload your QVW as is. if your QVW code contains the incremental (partial) reload syntax.
In order to retrieve data from two or more separate QVWs, you can use linked fields ('complaints' field) and multi doc. Once you create the linked field between multiple documents, you can then used the linked field as LEVEL.
i do not have much add to what Frank has provided, but I have a question as to the reason of requiring a partial reload from the 2 qvws? If you need the most recent data in your nprinting report and want to do a reload of the 2 qvws you can perform NPrinting reload tasks to run prior to your report tasks