slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: does anyone knows how to pass several slx accountIDs as parameters to crystal reports ?

drey
Posts: 16

does anyone knows how to pass several slx accountIDs as parameters to crystal reports ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 May 08 2:24 PM

does anyone knows how to pass several slx accountIDs as parameters to crystal reports ?
for one accountid I was using the: .ParameterFields(1).AddCurrentValue .
it works fine, but now my requirement changed and I need to pass several accountIDs.

thank you for your help
drey

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: does anyone knows how to pass several slx accountIDs as parameters to crystal reports ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 May 08 2:33 PM

Take a look at this article on the subject: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=100

You can use the method described in the article to pass multiple AccountIDs to a report.

[Reply][Quote]

Snow Monkey
Posts: 214

Re: does anyone knows how to pass several slx accountIDs as parameters to crystal reports ? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 May 08 12:30 PM

Yeah , Go and change the param in your cr to accept multi values and then keep on using this with any vb script loop struct

Dim objReport, objReportMV

Set objReport = Application.BasicFunctions.GetCrystalReport("Contact:New Rpt")
objReport.DiscardSavedData
objReport.EnableParameterPrompting = False
.ParameterFields.Item(1).ClearCurrentValueandRange

loop start
objReport .ParameterFields.Item(1).AddCurrentValue myaccountid
Loop end

And this has to work!

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 8:47:59 AM