Skip to main content
Question

Why does reporting sometimes show all fields and others not?


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 8 replies

Hi

 

This is on Astea Alliance, 15.10  

 

Within the export template wizard I have created a report.  This delivers me 35000 lines of data which is what I want.  I need a couple more columns in there so add these fields, now it only returns 8600 lines of data ?  I have checked and double checked my source and they are correct.  Any ideas?

This topic has been closed for comments

5 replies

Forum|alt.badge.img+5
  • Hero (Employee)
  • 32 replies
  • January 7, 2022

Yasas Kasthuriarachchi
Superhero (Employee)
Forum|alt.badge.img+30

Forum|alt.badge.img+2
  • Author
  • Do Gooder (Customer)
  • 8 replies
  • January 7, 2022

This is really odd. 

 

So it seems if you create a report from scratch it will allow the data but if I make a change at a later date, then it reports less data?  not a later time?


Reid Gilbert
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 339 replies
  • January 7, 2022

Take a quick look in the “Retrieve Limit” module...see if there are any entries in there that are set to a value of 8600 records (and if so increase the number and see if that resolves the issue).


Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+23
  • Ultimate Hero (Employee)
  • 1293 replies
  • January 10, 2022

Report limitations are stored in the global.xml and managed by the configuration editor.  I believe the default limit is 10000 rows.  Can you review if whether adapting the Report Record Limit setting in the Configuration Editor - Globals section will allow you to retrieve the 35000 rows.

As a side note, exporting a large number of records has a potentially serious impact due to large datasets and I presume you are running the report from your client thus even more sensitive.  I would not advise making this value too large.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings