Crystal Reports Passing Date Parameters into the report

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Passing Date Parameters into the report
	<< Prev Page of 2

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Mar 2011 at 7:53am
	is {@Extract} = '01' the month number?
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 03 Mar 2011 at 9:09am
	Yes '01' is the month that am looking.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Mar 2011 at 9:12am
	suppression formula to be applied to each sum as: tonumber({@Extract*}) > month(currentdate)*
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 03 Mar 2011 at 9:24am
	I had the above mentioned condition placed in the suppress formula for every month summary. Its not suppressing any of the months. Am thinking in this angle..... how would it know to place which month in the ({@Extract})?? Edited by Nav522 - 03 Mar 2011 at 9:27am
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Mar 2011 at 9:29am
	I am assuming that the @extract is the formula to use to get the month number as text and it is used in each of your summaries, is that correct? if so it the formula I gave you converts that from text to a number and compares it to the currentmonth number. If it is > then it should suppress. What exactly is the @extract formula? Also have you considered just using a crosstab to do this for you?
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 03 Mar 2011 at 9:49am
	I am assuming that the @extract is the formula to use to get the month number as text and it is used in each of your summaries, is that correct? Yes thats correct What exactly is the @extract formula? Right(left({Command.CPS_REQUEST_BATCH_ID},8),2) well i wud think the formula should suppress the fields. Am not sure why it didnt do that. Well anywayz thanks for the idea. I will try to look into the cross tab. Thanks a bunch
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Mar 2011 at 9:57am
	ahhh... that won't work because that formula is referenceing row level data and so in the footer only references the last row in the report. depending on what you are summing a more elegant solution might be to convert your data into a date field and use a crosstab that will only show what exists.
	IP Logged

Nav522 Senior Member Joined: 25 Aug 2009 Location: United States Online Status: Offline Posts: 166	Posted: 03 Mar 2011 at 10:00am
	Awesome Understood. Thanks for the input!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 03 Mar 2011 at 10:03am
	also the ct will dynamically grow over the year so make sure you leave enough room for all 12 months.
	IP Logged

<< Prev Page of 2

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.