Jump to content

I have a report that uses Date Period filter. This Period ...


Recommended Posts

Posted
I have a report that uses Date Period filter. This Period is currently default to YTD. My problem is that I display this report on 2 pages: Quotes and Sales. All other reports on the Quotes page default to YTD, and my report works perfectly (displays YTD information). But on the Sales page, all other reports in this page default to Last 12 Months, so even when I select YTD, the reports keeps showing Last 12 Months, and refuses to display YTD!! I imagine if there is a way for the report to know which page is calling it, I might be able to define the default period based on the page calling it. Otherwise I would have to have 2 identical reports, one with YTD as default, and the other with Last 12 Months as default.
Posted

The reports default is

-DEFAULT &DATE_PERIOD=LAST_12_MONTHS;

On the Sales page:

 

image.png775269 14.6 KB

 

On the Quotes Page:

 

image.png789250 15 KB

 

but the problem is that the Sales page consistently shows LAST 12 MONTHS, it never shows Year To Date

Posted

I am a little confused.

In your first post you are stating the oposite of what your are showing in the second post

In post 1 : Sales default to Last12Mths and Quotes default to YTD

In post 2 : Sales default to YTD and Quotes default to Last12Mths

Does your parameters properly assigned and linked in both pages indepandently

Do you have a common filter (page) from where you select and from which both pages should update

  • 5 weeks later...
Posted

OK. So I learned something new with this issue:

 

If you have several reports on the same page, default filters with the same name MUST have the same DEFAULT values. If you use different DEFAULT values, there will be problems.

If you need a to set different value as a default, you can use the pages DEFAULT VALUE box, in design mode, select the filter, and on the left hand side, you can set the DEFAULT value.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...