Hello everyone,
i have one requirement to display date range at header level.
The report has three columns ...
1product id,
2.product date,
3.product description.
suppose,
product id product date prod descr
ALMPR2 1/27/2014 VISA PREMIER
ALMGLD2 1/17/2014 VISA GOLD....
then at report header level, date range should display as January 1st,2014 to January 31st 2014 based on product dates
Thanks in advance
Hi,
What's the calculation that you want to do? Are you going to prompt / filter to just get the items that have a product date in January (in your example)?
C
Thanks for quick response... there is no promptsin report.
Those dates should come based on product dates column.
if prouduct dates are 1/16/2014,1/18/2014,1/9/2014...etc...
Date range should display 1/1/2014 to 1/31/2014 i.e Janary 1st,2014 to January 31st,2014
That doesn't make sense. Then I would expect date range 1/9/2014 - 1/18/2014. The min and max of your product dates.
Or do you want the complete range for the month january?
Nanno
Business needs that mandatory date range...they think that proudcut dates are wihin January 1st,2014 to January 31st,2014 in above example data...
In your existing query (in Report Studio) you can add an new data item. The expression: max([product date]), name it max_date. Another data item. The expression min([product date], name it min_date.
Add singleton in your header. With properties choose above mentioned query. Drag in [min_date]
Add another singleton in your header. With properties choose above mentioned query. Drag in [max_date]
Does that work for you?
Nanno
it didnt worked... :(
Quote from: chinnucognos on 13 Feb 2014 03:21:28 AM
it didnt worked... :(
???
That doesn't really tell us anything. Did it return an error? Did it return nothing? Did it return the wrong dates? Did it return the right dates in the wrong format?
The only solution I can suggest to "it didn't work" is
"fix it"
:)
it throwing error.....seems max and min functions doesnot match
Quote from: chinnucognos on 13 Feb 2014 05:06:39 AM
it throwing error.....seems max and min functions doesnot match
Wow! You seem intent on not giving us even the hint of a detail that might help! Saying "it is throwing error" is like saying "it doesn't work". What is the error? What syntax did you use? What steps did you take?
Really - how can you expect us to be able to help you when you don't seem inclined to give us any details on your problem? If I said to you "My car doesn't work - can you help?" how would you know what the issue is? If you replied and asked for details of the issue and I responded with "it has an error" would you be any more able to help? No? The same applies here.
Did you use the inbuilt Cognos summaries maximum() and minimum()? What exactly is the syntax you used in each expression? What error message is returned?
MF.
Iam really sorry for not giving proper reason, since iam working on multiple defects i have not concentratd to elaborate error.
Here is the exact error...
after using maximum and minimum... dates are showing as Jan 13th,2014 to Jan 28th,2014(these values are as per database)
but exact requirement is Jan 1st,2014 to Jan 31st,2014
Hi,
You need to use functions to get the first and last days of the month.
_first_of_month( minimum( [product date item] ) )
and
_last_of_month( maximum( [product date item] ) )
Cheers!
MF.
Now it worked fine MFGF....Really thanks a mil
Cheers.................... :)
Thanks MFGF for the final solution. I'm used to the Oracle syntax (min & max).
Thanks chinnucognos for letting us know that it works.
Nanno