INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

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

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.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!