selection screen question

[Former Member]

Hi Experts:

I have another question here

In the selection screen of a query I should be able to select a month for which the user will need the data .

The resulting report should include the above provided month data along with all the other data for which there is no entry in the month column

little example

3/2005 is entered in the selection screen

This should pull all the records of 3/2005 as well as those records which do not have the date populated in them.

[Former Member · Accepted solution]

Could you give me step by step solution.

I have anothe thread on the same subject I am going to close that one.

[former_member188975 · Accepted solution]

Hi again,

Put your month char in the query (like as free char, or in the rows or columns). Right click > Restrict > From the Fixed Values tab, select # or Not Assigned and pull it to the right hand pane. Then click on the Variables tab and select your variable and put that too in the right hand pane. Click okay. Check, Save and Execute the query.

Hope this helps...

[Former Member]

It's enough to add as filter (with the variable of your user) another restriction with '#'.

Hope it helps!

Bye,

Roberto

[former_member188975]

Hi,

You can try to restrict the 0CALMONTH char with your variable and also with # (for not assigned). I have not tried this out...just an idea.