Hi,
I used JetReports a long time ago (V3.5) and come back with the express version.
I was used to do my reports using nested (NL, "Rows",..) for nested tables, example :
- I need to extract all invoice sales lines for a customer between 2 dates :
Formerly, i used a NL,'Rows' on the header filtred on the date and the customer that i need, and a field was also an NL, 'Rows' on the lines link to the header bay the doc N°.
The total time to extract the data was the time to find the headers among the 800K headers, then extract the line for each header.
With Jet Express, i can do it with a NL,'Table' but the i have to select the Invoice Sales Lines to extract and as we have 4M Sales lines, it takes a very long time to execute.
Do you have a way to "nested" NL,'Table' as it was possible with NL,'rows' ?
Regards,
Date
Votes
1 comment
-
Jet Reports Historic Posts When using NL(Table) to get data from a "header" table and a "detail" table (and you want to display data from the detail table) it is necessary to use the detail table as the primary table.
As a result, Express needs to look through that entire table. In your case… a very large table.
Unfortunately, in a Table environment, there is currently no way around that with Express. Filtering may help (only a specific date range, or account number range, etc.) as could making sure the fields you are retrieving exactly match a Key that exists on that table.
Ultimately, you might want to consider Jet Essentials [which provides additional features such as the NL(Rows) function] or even Jet Enterprise where data is transferred to Cubes (over extremely fast queries).
-HP
Please sign in to leave a comment.