cross tab with highlighting condition

jayanthi · Post by **jayanthi** » Sat Sep 12, 2009 12:25 am

Hello,

In cross tab, am displaying the days of month; sundays has to be displayed in red color.

Have seen a sample in demo but am not able to find the property.
Please guide me to do.

Regards,
Jay

Post by **Andrew** » Mon Sep 14, 2009 3:31 am

Hello,

Here is the step-by-step description what you need to do

A report in Demo "CrossTabWithHighlightCondition2"

1. Open Cross-Tab Designer
2. Select "Summary"
3. Select the Conditions () property
4. Add Condition
5. "Field Is" set to Expression
6. Write - tag == "Sunday" (or the required date depending on what you need to output)
And select the equired color appearance

Thank you.

jayanthi · Post by **jayanthi** » Mon Sep 14, 2009 4:50 am

Hai,

Thanx for your reply.

Actually i need one of my cross tab rows data to be highlighted and not the summary value.

Is it possible to do.

am displaying report like below:

--------------------------Trip Type------------------
Days----------One way Trip----------Two way Trip
1---------------- 3 ----------------------- 2
2---------------- 3 ----------------------- 2
3---------------- 1
4---------------- 2
5
6
7
...
30

Is it possible to print Days in red color (Sundays only)

Thank u
Jay

Post by **Andrew** » Thu Sep 17, 2009 4:44 am

Hello,

You may see the reports templates from the standard delivery. They are Cross-Tab with highlight condition and Cross-Tab with highlight condition2.

It is very hard to say what do you accurately need. For this, the report and data are required.

Thank you.

jayanthi · Post by **jayanthi** » Thu Sep 17, 2009 5:03 am

Hello,

I dont know where to upload my report here. So i will explain again.

am displaying report like below:

--------------------------Trip Type------------------
Days----------One way Trip----------Two way Trip
1---------------- 3 ----------------------- 2
2---------------- 3 ----------------------- 2
3---------------- 1
4---------------- 2

In above
1. Days (Cross Tab Rows) are Days in a Month
2. Trip Type are (Cross Tab Column) displays TripTypes with Count of Trip as Summary.

Now i need the Days (Cross Tab Rows) {ie, 1,2,3,4} has to be highlighted in Red Color if the day is SUNDAY.
Am able to highlight red color for Summary filed but i dont want that. I need the Days to be highlighted in RED color.

Regards
Jay

Brendan · Post by **Brendan** » Thu Sep 17, 2009 5:28 am

Can you provide some more info on how you are displaying your 'Days'.
Are you displaying them as numbers (1 to end of the month) like in the example or are you displaying something like 'Monday' - 'Sunday' or something else?
And are the days relative to a particular month or is it that day one is always 'Monday', etc?

jayanthi · Post by **jayanthi** » Thu Sep 17, 2009 5:39 am

Hello,

Thank you for your reply.

Actually Days are displaying like 1 to end of the month and not like Monday-Sunday.
Days are relative for a particular month selected in DateTimePicker.

Regards
Jay

Brendan · Post by **Brendan** » Thu Sep 17, 2009 7:34 am

I tried to make a crosstab like in your sample.

I am not using the latest build of StimulReports (only tested with version 2009.1.400) but I was not able to do what you want.
I could not get conditions to work on Crosstab Rows. They would only work on Crosstab Summary values.

I will try retesting with latest version.

jayanthi · Post by **jayanthi** » Thu Sep 17, 2009 10:52 pm

Thank you Mr. Brendan

Brendan · Post by **Brendan** » Sun Sep 20, 2009 7:25 am

I tried doing a highlight condition on the Cross Row but it doesn't seem to pick it up.
Maybe it's a limitation of the control or a bug. A member of the Stimulsoft Team may be able to answer this for you?