Hello Jetreports Community,
At first: I'm from Germany so my English is not very well, but I think you will be understand me.
I work in a MB Solution Centre and we (i.e. I) developed Reports with Jetreports since four Years. It is realy a powerfull Tool for a small amount of data. Actually I work with the newest Version of Jetreports and for example the NL("Link"…) Function is great and most of Reports with NL("Filter") Function is up to date and the runtime is OK.
But some of Reports with more then 2000 Rows is to slow. I always use NP("Eval") Functions and other performance Functions, but sometimes Reports has a runtime of more then a half hour and longer. The Client have maximum CPU usage and the Server do "nothing". Is there a solution to fill the sheet faster with a big data volume?
I thank you for help
Rene
Date
Votes
6 comments
-
Jet Reports Historic Posts Hi Rene,
With Jet Reports 2010 (and Excel 2007 or later), if you're getting a lot of data from a single table, you can use the NL(Table) function like this:=NL("Table","Field",{"Field1","Field2","Field3","Field4"})
This would return an Excel table with all the data from fields 1 through 4. You could also use a range of cells with the field names in them.
Regards,
Hughes -
Jet Reports Historic Posts Hello Hughes,
this is realy a nice feature. Thanks a lot for the Tipp. But a Question about this. Is it possible to Group Datas? For Example my Table is G/L Entry and I want sub-totals for every G/L Account No.
greetings
Rene
Edit: I solve my problem with a Pivot Table. Thats awesome and very fast. I have so much ideas now. Good Job! -
Jet Reports Historic Posts Rene,
I'm glad you figured out a solution that works for you! One other tip when using a pivot table from a table created by Jet. In your NL(Table) function, use a TableName= filter to specify a table name so that the pivot table doesn't lose it's reference to the table when re-running the report. Your function would look like this:=NL("Table","Field",{"Field1","Field2","Field3","Field4"},"TableName=","MyTableName")
Regards,
Hughes -
Jet Reports Historic Posts Hi,
thats the same way I did it, but thank you.
Greetings -
Jet Reports Historic Posts Hi,
It seems I am running behind time as my post is almost 1 year after.
I am using NL(‘Table’) function on table 32 Item ledger Entry (part of a Sales dashboard report given by jet reports), 1 month data consist approximate 88000 lines, To populate these lines (without any link) jet reports takes approximate 17 min.
Can anyone help me?
Regards,
Rakesh Raul -
Jet Reports Historic Posts Hi Rakesh,
You should post something like this as a new post, not as a reply on an old post like this. Given the amount of data in the report and that the report was created by Jet, I doubt you are going to be able to improve the speed very much without actually removing things from the report. If there are fields or data you don't really need to see, you may be able to improve the speed by removing those. You could post the report for people to look at, but it doesn't sound like it is likely we will be able to speed it up much.
Regards,
Hughes
Please sign in to leave a comment.