JUAN ORTIZ Posted December 3, 2021 Posted December 3, 2021 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.
Martin Yergeau Posted December 3, 2021 Posted December 3, 2021 What is the default period assigned to Sales report Does the Sales report properly updates when you change the selected period Seems that Quotes has default period to YTD and Sales as Last 12 Mths
JUAN ORTIZ Posted December 3, 2021 Author Posted December 3, 2021 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
Martin Yergeau Posted December 6, 2021 Posted December 6, 2021 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
Sarah Buccellato Posted December 13, 2021 Posted December 13, 2021 Juan, have you had a chance to review Martins questions
JUAN ORTIZ Posted January 11, 2022 Author Posted January 11, 2022 I did. Thank you. I will post my final comment on this issue.
JUAN ORTIZ Posted January 11, 2022 Author Posted January 11, 2022 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now