Looping Getdatavalue limit to 100 rows

[Kaiaualad]

I have a macro that uses Getdatavalue from an Impromptu report and applies it as a parameter to another Impromptu report.
Unfortunately there are 276 values in the filter IMR ,and an Impromptu report only retrieves the first 100 at a time.The macro cannot "scroll" to retrieve the next 100 values.Is there a way of increasing the default 100 to a higher figure?
Or will I need to use a text file instead ,or simply use 3 IMR filter reports and run the code 3 times in the one macro?

Thanks in advance

 

[bustell]

I know that pick lists are limited (by default) to 100 items. Maybe this is related to that.

To increase the defaul picklist from 100 to 500 you need to edit the Impromptu.ini. Under the [Startup Options] change: picklist limit=100 to picklist limit=500.

See if that fixes your problem.

Good luck.


Pat B

 

[Kaiaualad]

I have solved it - ImpRep.RetrieveAll inserted in the macro retrieves all rows in the filtering report.