If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

prompts

Started by jd, 25 Oct 2011 02:07:48 PM

Previous topic - Next topic

jd

Hi I have quesiton about prompts:

in my prompt page I have
Doc Number
Manifest Number
Start Date
End Date

when I select Doc number, Start date and End date for the date range selection should be enable  this part is working fine.
when I select Manifest number Start date and End date for the date range selection should be disable because I do not want to give any date range for manifest number.

by default start date and end date shows current date. so I can change the date range with Doc number it works fine.

but when I select Manifest number if I do not selct any date ranage by default it takes current date for start and date which I do not want

so how I can I disable date range for Manifest number selection.

cognostechie

Seems like your objective is not to disable the date prompts when you select Manifest No  but rather the report should not consider the Date range when it is run if a Manifest No is selected.

If that is the case, edit the filter for the Date Range and put a condition -

?Manifest No? is null
   
   AND

<   your existing filter expression >

If you have two filters one for the Start date and one for End Date, combine
both into one and put it in the expression above.

jd

Hi Cognostechie,  thanks for the reply.

sorry I did not get your idea, here is my filters:

Date filter: [RAVEDb].[MANIFEST_DETAIL].[CREATE_DT] between cast_date(?pStartScanDate?) and cast_date(?pStopScanDate?)

site: [RAVEDb].[MANIFEST_DETAIL].[SITE_UIC] = ?pSiteUIC?

Manifest numebr: [RAVEDb].[MANIFEST_DETAIL].[MANIFEST_NO] = ?pManifestNumber?

can you please explain me your idea using this filters.

thanks in advance..

cognostechie

Edit the Date filter and try this :

?pManifestNumber? is null

      AND

[RAVEDb].[MANIFEST_DETAIL].[CREATE_DT] between cast_date(?pStartScanDate?) and cast_date(?pStopScanDate?)

Also try this :

If   
(?pManifestNumber? is null)

then
( ([RAVEDb].[MANIFEST_DETAIL].[CREATE_DT] between cast_date(?pStartScanDate?) and cast_date(?pStopScanDate?) )

else
(1=1)

jd

Hi, I tried both filters but no expected results..

no data is returing with those filters.

again when I select SITE UIC I need start and end date either I can select them or not.

when I select Manifest date I do not need to select start and endates I want to see all of the documnets. but since start date and end date in the prompt page by default it is showing todays date so for the Manifest date if I don't select the dates evn though report is filtering based on current date..

how to possible when I select manifest number start date and end date do not get effect

cognostechie

You are correct. I tried it many ways and it works one way but not the other way so the best I could do is use conditional blocks and using a block variable, hide or show the block you want. Have different queries in different blocks . In one query, use the date filter. In the other query for other block, don't use date filter so depending on if the user selected something from the   manifest prompt, the appropriate report would show.

let me know if you need details, I will send you the report.