Sage 100

@Jeff Schwenk, Set List of values to Dynamic.  Choose Data source select New.  Click on the folder icon just below that and choose the field to select.

Or you can optionally 'import' the values into the static parameter periodically.  I have a few clients doing that for their huge customer list.  Basically do an ALE export of customer # and name from Customer Maint, save as .txt, then import.  

@Jeff Schwenk, Set List of values to Dynamic.  Choose Data source select New.  Click on the folder icon just below that and choose the field to select.

Thanks.

@Phil McIntosh - It appears there is a limit of 1,000 records with the dynamic linking.  @Brett Zimmerman - Is there a limit for importing records.  Client has over 6500.

Or you can optionally 'import' the values into the static parameter periodically.  I have a few clients doing that for their huge customer list.  Basically do an ALE export of customer # and name from Customer Maint, save as .txt, then import.  

@Jeff Schwenk, Set List of values to Dynamic.  Choose Data source select New.  Click on the folder icon just below that and choose the field to select.

That limit might be fixed by a registry hack:

http://crystalreportsbook.com/forum/forum_posts.asp?TID=8029

Thanks.

@Phil McIntosh - It appears there is a limit of 1,000 records with the dynamic linking.  @Brett Zimmerman - Is there a limit for importing records.  Client has over 6500.

Or you can optionally 'import' the values into the static parameter periodically.  I have a few clients doing that for their huge customer list.  Basically do an ALE export of customer # and name from Customer Maint, save as .txt, then import.  

@Jeff Schwenk, Set List of values to Dynamic.  Choose Data source select New.  Click on the folder icon just below that and choose the field to select.

For Standard or Advanced (likely similar for Premium), if their report could be converted to use "AR_CustomerListingWrk", or if that worktable could be linked to their existing report by division and customer, then their report could replace the report of a designated Report Setting of the A/R Customer Listing report. This would allow them to use all the customer criteria available to that report to restrict the worktable and thus their report. To enforce the restriction, when linking the worktable, you must set the "Enforce Join" setting to "Enforce From" if the worktable links in the direction of "AR_Customer" or "Enforced To" if the worktable is linked from "AR_Customer". No hack, no limit.

There's no requirement to include fields from the worktable if it can't be completely replaced (Database menu, Set Data Location command) by AR_Customer.

Again for Standard and Advanced, if you want to test and preview data in the full version of Crystal, use the "Set Data Location" command to point to SOTAMAS90 for the tables, put the report in preview and leave it, check for the session work file in the ARxxx folder and grab the session id (that part of the name after "AR_CustomerListingWrk" and before the ".M4T") and store that in the SOTAMAS90 DSN "Login" panel in the "Session ID:" field.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-829-1054
------------------------------

For Standard or Advanced (likely similar for Premium), if their report could be converted to use "AR_CustomerListingWrk", or if that worktable could be linked to their existing report by division and customer, then their report could replace the report of a designated Report Setting of the A/R Customer Listing report. This would allow them to use all the customer criteria available to that report to restrict the worktable and thus their report. To enforce the restriction, when linking the worktable, you must set the "Enforce Join" setting to "Enforce From" if the worktable links in the direction of "AR_Customer" or "Enforced To" if the worktable is linked from "AR_Customer". No hack, no limit.

There's no requirement to include fields from the worktable if it can't be completely replaced (Database menu, Set Data Location command) by AR_Customer.

Again for Standard and Advanced, if you want to test and preview data in the full version of Crystal, use the "Set Data Location" command to point to SOTAMAS90 for the tables, put the report in preview and leave it, check for the session work file in the ARxxx folder and grab the session id (that part of the name after "AR_CustomerListingWrk" and before the ".M4T") and store that in the SOTAMAS90 DSN "Login" panel in the "Session ID:" field.

------------------------------
Dan Burleson
Software Consultant
Connex Software
Corvallis OR
541-829-1054

This is such a wonderful post; and exactly why I'm a member of 90Minds!  Thanks all for the great ideas. I've used the registry hack before to expand the listing with great success (for a Dynamic Data Source Listing). I never knew about the Work File "hack", you can teach an old dog a New Trick!