Databases
StackOverflow2013
Postsdbo
POSSRS Date Parameters - Setting Date B = Date A whenever Date A is changed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSSRS Date Parameters - Setting Date B = Date A whenever Date A is changed
    primarykey
    data
    text
    <p>I am looking into a query from one of our users regarding the behaviour of date pickers on their report.</p> <p>They have asked that when they enter a date in Date Paramater A that this is then duplicated in Date Parameter B.</p> <p>I can achieve this when the report is first run by given Date Parameter A no default value (so it has to be chosen by the user) and seet Date Parameter B's default value via an expression to "=Parameters!StartDate.Value".</p> <p>The question though is wether or not I can recreate this when Parameter A is updated. Therefore if they run the report once and then decide they need to choose another date. Can I set Date Parameter B to refresh each time Date Parameter A is changed?</p> <p><strong>E.G</strong></p> <p>Report is opened</p> <p>Date Parameter A is set to 02/12/2013. Date Parameter B now defaults to 02/12/2013. Search is performed</p> <p>A second search is required so, without closing the report the user changes the date in Date Parameter A</p> <p>Date Parameter A is now set to 05/12/2013 Date Paramater B still says 02/12/2013 - can I somehow make this auto refresh to match Date Parameter A if Date Parameter A changes?</p> <p><em><strong>EDIT:</em></strong> Thanks to Kalim for pointing this out but it must also be noted that although I would like Date Parameter B to default to the new value selected by Date Parameter A, dates greater than that selected for Date Parameter A must also be available in case they wish to widen the range of dates.</p> <p>Hopefully that is clear, but if any further information is required then please let me know.</p> <p>Thanks in advance for your time and help.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNeil Rutland
    1. USNeil Rutland
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSSRS Date Parameters - Setting Date B = Date A whenever Date A is changed
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIf you double-click on a report parameter in the designer view, and then go to the 'Advanced' options, there are options for when to 'Refresh data when this parameter changes'. Perhaps changing these setting for one or both parameters will help?
      singulars
      1. POSSRS Date Parameters - Setting Date B = Date A whenever Date A is changed
      1. USScott Newson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload