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: Passing Parameters to Reports

David Joseph
Posts: 13

Passing Parameters to Reports Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Jun 07 5:45 PM

Saleslogix 7.0 SQL server 2005

I have a custom table(HISTORY_ACCESS) that has 2 fields UserID and AccessID.. it list all the user visibility
rule for a given user (i.e U6UJ9A000000 can only view U6UJ9A000000 's history; U6UJ9A000001 can view history for U6UJ9A000000,U6UJ9A000001,U6UJ9A000002,U6UJ9A000003
U6UJ9A000002 can view history records for U6UJ9A000000 and U6UJ9A000002)

I want to make sure that ALL my SLX reports (the out of the box ones) displays the history details based on this custom table.

How do I pass the current userID to all the report so that I can filter my custom hisory_access table for that user. if I do that, I can then join the AccessID field to the history table's userID and display only the required result

data in HISTORY_ACCESS table
U6UJ9A000001 U6UJ9A000000
U6UJ9A000001 U6UJ9A000001
U6UJ9A000001 U6UJ9A000002
U6UJ9A000001 U6UJ9A000003
U6UJ9A000002 U6UJ9A000000
U6UJ9A000002 U6UJ9A000002
U6UJ9A000000 U6UJ9A000000

[Reply][Quote]

Mike Douglas
Posts: 8

Re: Passing Parameters to Reports Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jun 07 10:09 AM

I would have thought you could have used the filter options available when running the report. USER + XXX, since this SLX 7
If not, then you can create a new table in slx with just one field userid.
Then create an activescript which captures the CurrentUserID and writes to table.

Then usethe SLX/CR functionaility of running this script as the report loads.
Your report should have the table in it and uses the value as part of its paramenters.

Also have another script that runs when report is closed to clear the table out again.
Done this many times for different rerasons.
Mike Douglas

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: Passing Parameters to Reports Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Jun 07 12:08 PM

The article in the link below covers filtering reports at runtime.

http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=100

[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 9:20:52 AM