cancel
Showing results for 
Search instead for 
Did you mean: 

display multiple columns in if else condition in crystal report

Former Member
0 Kudos
511

i want to display two columns by using condition as follow

if {AppPageResponseMonitorDetails.PageCode}= 'Home Page'

then({AppPageResponseMonitorDetails.PageCode},{AppPageResponseMonitorDetails.PageResponseTime})

but it give error how can i display two columns by using if else condition in this when i use 'and' then it will also give error

how can i display two columns by using if else condition in crystal report

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Ganesh,

What I understand from your query is

if{AppPageResponseMonitorDetails.PageCode}='Home Page'

You want to display 2 Columns

PageCode and PageResponsetime

So You can write a Suppress Logic for these columns:

For these columns write Suppress Logic as

if {AppPageResponseMonitorDetails.PageCode}<>'Home'

Probably this is what you are looking for.

Cheers,

Kiran

former_member203168
Active Participant
0 Kudos

Hi Ganesh,

As per my understanding,
You want to display two fields values at a time by using IF condition.

if {AppPageResponseMonitorDetails.PageCode}= 'Home Page'

then({AppPageResponseMonitorDetails.PageCode}+" "+{AppPageResponseMonitorDetails.PageResponseTime})

if you place the above formula in any section then it will disply  PageCode and PageResponseTime as a single field.


--Praveen G

abhilash_kumar
Active Contributor
0 Kudos

Hi Ganesh,

Where are you using this formula? Are you trying to use this in the Record Selection Formula?

What is the exact requirement?

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

JasonLax
Product and Topic Expert
Product and Topic Expert
0 Kudos

(Getting Started with SCN is for general SAP Community Network related discussions only.

To get a quick (or any) response, create your new discussion in a space related to your query.  This way it will be visible to topic experts who will then see and reply to it.  The SCN Site Index contains a full listing of all SCN spaces.

I'm moving this now...