Forum Discussion
ArchiveUser
10 years agoQrew Captain
As above but create a formula numeric field and using something like the record id value to group your data into downloads
eg
if([record ID]<10000,1,
[record ID]<20000,2,
[record ID]<30000,3,
99999)
Then set this as your predefined filter in your report and create buttons to download these. You could possibly incorporate the call to download the reports into one button, but would still need to merge the csv files.
Multiple CSV files can be easily merged using the dos prompt in windows, takes me less than a minute to merge hundreds of CSV's. You could probably write some kind of script to do that and remove the columns from the other CSV's.
eg
if([record ID]<10000,1,
[record ID]<20000,2,
[record ID]<30000,3,
99999)
Then set this as your predefined filter in your report and create buttons to download these. You could possibly incorporate the call to download the reports into one button, but would still need to merge the csv files.
Multiple CSV files can be easily merged using the dos prompt in windows, takes me less than a minute to merge hundreds of CSV's. You could probably write some kind of script to do that and remove the columns from the other CSV's.