Date range query

[cognosjon]

Afternoon all,

I'm stuck and could do with some assistance please.

I have a filter that takes the following form:

[Customershippeddate] in_range ?Date?

what I need to be able to do and appear to have a mental block over is I need two get the minimum date and the maximum date from the date prompt as two seperate data items within the report.

Any suggestions would be appreciated

[ej]

I could really use that information as well.  I've been baffled how to pull out information about a parameter built by creating a prompt.  I've seen in some pre-built Cognos reports that came with Cognos 8.3 that one can display the parameters in a cover page, but haven't worked through how it is done yet.  If I figure it out, I'll pass it on.

[cognosjon]

Hi ej,

I think we are both after different things.

I think this is what your after.
To get the value of a parameter to dfisplay on your page drag a layout calculation object onto your page. Then when the report expression page is displayed click the 'parameters' tab at the bottom of the available components window and then drag the parameter that you are interested in into the Expression Definition window. Click ok.

The parameter details now selected in the prompt will display on the page. Hope that helps

[Nuffsaid]

This works with Oracle....

Create 2 data items

From   minimum(cast(?Date?,date))

To      maximum(cast(?Date?,date))

Associate the page to the query that contains these data items.
Drop the new items on the page and format as desired.

[cognosjon]

cheers nuffsaid

wasn't exactly what I was after you have pushed me in the right direction so thanks for that. ;D

[Nuffsaid]

I need two get the minimum date and the maximum date from the date prompt as two seperate data items within the report

Dunno, maybe it's me, but what I suggested will return exactly what you asked for.

Anyway, glad I could be of some assitance.   ;)