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.
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.
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..
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)
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
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.