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: Trying to display Date Range Filter on Report

Brad
Posts: 1

Trying to display Date Range Filter on Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Feb 07 11:26 AM

Hi Everyone,

I am tying to display the filtering criteria on the report when the user selects FIlter by Date. Crystal 8.5 SLX 6.1

Any help would be appreciated

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Trying to display Date Range Filter on Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Feb 07 1:01 PM

I assume we are talking about the SalesLogix filter pane that is on the reports mainview within SalesLogix. If so, then I do not believe you can do so without some heavy lifting, if at all. In 7.x the report mainview is customizable and this is all open to you, plus you can use Crystal XI.

One way to "hack" this is to put 2 formulas in the report: one stores the min(datevalue) and the other stores the max(datevalue). This may be good enough for your needs. Some customers want to see that the report was run for Jan 1st thru Feb 1st even if the first record found is Jan 10th. With this hack you would see Jan 10th thru Feb 1st.

Hope this helps!

Timmus

[Reply][Quote]

John Gundrum
Posts: 632

Re: Trying to display Date Range Filter on Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Feb 07 9:39 AM

I had contacted SLX support about this and basically it was said it could not be done.

I do like the idea of create two formulas to get the MIN and MAX date values. Sounds like a plausible solution.

John G.

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Trying to display Date Range Filter on Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Apr 07 2:37 PM

This is a frustrating 'feature'. It's great that you can run reports by date ranges in SalesLogix without having to use parameters in the report itself but the fact that it cannot publish that on the report some where greatly diminishes its value. We have a report that we will be running monthly, quarterly and annually. The format of the report doesn't have to change, just the date range. But I have to use parameters in CR instead of using the date filtering built into the SLX interface. Ugh!

[Reply][Quote]

John Gundrum
Posts: 632

Re: Trying to display Date Range Filter on Report Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Apr 07 5:57 AM

Marc,

Yes. This is a frustrating 'feature'. I do wonder now that SLX is using Crystal XI R2 if there is a possibility of it working now.

John G.

[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 7:48:44 AM