INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to display data on the report based on specific parameters and sides

How to display data on the report based on specific parameters and sides

(OP)
The report has multiple parameters including 2 date ranges like left start date and left end date, right start date and right end date. i have date from the source but the report purpose is to compare the same data for 2 specific ranges like a dashboard.

how do i display data that is specific to left date range and likewise on right side. how to decide left side or right side?

Thanks
st

RE: How to display data on the report based on specific parameters and sides

The basic approach here is to bring back the data for both periods, with a Record Selection Formula along the following lines:

CODE

(
	{Table.Date_Field} >= {? left start date} and
	{Table.Date_Field} <= {? left end date} 
) 
or
(
	{Table.Date_Field} >= {? right start date} and
	{Table.Date_Field} <= {? right end date}
) 

(although you might want to consider only 1 date range by parameter and the second date range a calculation based on the first)

To identify whether the data is in the first date range or the second, you could do a formula something like this:

CODE

If	(
		{Table.Date_Field} >= {? left start date} and
		{Table.Date_Field} <= {? left end date} 
	)
Then 	'Period 1'
Else	'Period 2' 

Hope this gets you started.

Cheers
Pete.

RE: How to display data on the report based on specific parameters and sides

(OP)
Hi pete,

thank you for the quick reply. i have literally few fields separated by a black lane at center. except the date range same columns looking at 2 different time periods for the same products.

i do have 2 date ranges not one. so your idea is bring all the data for (left side and right side)all the columns. on the left side just show normally (assuming current period) on the right side show the data after subtracting dates from left side using the date value parameters supplied for right start and right end dates.

and i am not showing period 1 or period 2 in the report. it is showing data for 2 different periods side by side for comparison purpose.

please check the attachment

Regards,
ST

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close