how to display conditional text in crosstab--urgent

[srinidhi]

hi all,

i  have to deliver the report. plz help me...

We have a cross tab report which takes

Rows-- Loc and code columns
Columns- Date received column

Measures - Batch Status character column (which takes values as applied, processed, validated, rejected, received etc..)

How to put Batch Status column in measure place as it is character column. when it is directly placed, it is not getting inserted. If we use data item and place it when we run the report, no data is displaying.

I used text source variable and applied but condition is not getting applied.
 
Once data comes, we need to apply conditional formatting to it like
applied-- green
processed---red
validated---- pink
etc...
 
Thanks in advance,

Waiting for your reply at the earliest,

Thanks for your time.

Regards,
srinidhi

[PRIT AMRIT]

Instead create a calculated DATA ITEM: E.g.

Case [Batch Status]
when 'Processed' then 1
when 'Applied' then 2
when  'Rejected' then 3
when 'Validated' then 4
------------------------------
--------------------------
--------------------- so on
END

Use this as your measure. Now should be able to see the report.

Create a String variable with the similar expression and apply for color shading.

Hope should work for u.

Thanks
Prit

[srinidhi]

I did the report repeating the procedure sent by you. I am again getting 'Applied' value only in all the columns.
Please help me what modifications do I need to do further to make the report work.
Please make time for me and help me. I took permission from client that I will dleiver in few hours...deadline is completed....

PLEASE HELP ME.

Waiting for your reply at the earliest,

Thanks for ur time.

Regards,
srinidhi

[kattaviz]

Hi,

After creating a data item apply the conditionla styles to the column.

Example

[query].[data item]=2 then background color is green
[query].[data item]=1 then background color is red

HTH

[melee]

I took permission from client that I will dleiver in few hours...deadline is completed....

PLEASE HELP ME.

Waiting for your reply at the earliest,

I suggest you let your client know that you won't be able to deliver what they are asking. It sounds like you are in a little (lot) over your head and asking us to do your job for you, and that's not fair to us or your client.

PRIT (as always) has provided you with part of the solution, as well as kattaviz. I suggest doing as much troubleshooting as you can in Report Studio and giving us a detailed explanation of what you tried, and we can try to assist you from there.

[PRIT AMRIT]

Srinidhi,

I am again getting 'Applied' value only in all the columns.
Please help me what modifications do I need to do further to make the report work.

Is the issue resolved? If not, let me ask a quick question, as per the Case statement you should be getting 1,2,3 or 4 instead Applied, Validated, Processed or Rejected?

You may send us the XML spec to have a look?

Take it easy...  Client is always somebody like u and me...If you explain them about ur technical issue, they would give you time to fix it  :D Without having the solution don't tend to promise anything.

Thanks
PRIT