Search results for query: *

Madawc Thank you so much for your help. I attempted to rewrite the IF/THEN statement but I need to account for multiple cases of isNULL({command.pass_status}) so it still isn't appearing correctly in the crosstab. Here is my formula: if isNull({Command.pass_status}) or {command.poo} = 'STATE'...

Good Morning I am building a crosstab in Crystal Reports 11 with an ODBC connection to Teradata with the following command: sel i.poo, pcp.opt_in_out_cd, pcp.cmmnctn_proc_cd, i.pass_status, i.party_id, pcp.actv_dtm from edw_prd_vmdb.party_communication_priority pcp inner join...

Dave Thank you for the SQL suggestion. Unfortunately it did not speed up the report. I believe the multiple returns are caused by the inclusion of the snapshot table. This table tracks any changes based on the o.oppid so there can be several o.oppid for one vw.snapid. But I must have the...

Using Crystal Reports XI rel 2 with SQL Database through ODBC This report is a PACE report comparing where we are this year based on exactly where we were at this point last year. So the table structure is such that one set of tables pulls current information and a table named Snapshot tracks...

Using CR XI with SQL through ODBC I have four different crosstabs with various summaries but they all have the same row and there is no column. Is it possible to force shading on every other line even though the row is technically the same field? Row = Arrival Date grouped on year Summary =...

Thank you LB. I was able to make that work. Just for future reference...when you mention I should specify what version of CR are you referring to something other than CR XI referenced in my original post? Julie

Similar to thread767-1210546: I am using CR XI ver 2 with SQL Server through ODBC and I have a cross tab with the following information: FY2008 FY2007 Definite 111,111 222,222 Tentative 333,333 444,444 Row...

LB - Fantastic! That was just what I needed. Thank you so much for help with this! JAZ

LB - Thank you so much for your help with this. The 0 throws everything else off. Do you know how I can make the 0 equal 12? The group header won't work unless the numbers are exactly 1 through 12. JAZ

I just applied the group and since the formula is based off a number I get 0 to 17 rather than the actual months...December is 0 and then 12 + 5 = 17. And since I'm adding three and five to the anniversary month then the numbers over 12 could represent different months. Do you see any way...

Thanks lbass...I got that to work.

This seems so simple it's driving me crazy! I need a report to detail a call schedule around the customers join date. I have the actual join date and the anniversary month so either fields could be used. I need to call three times annally. Once the month before the anniversary and then three...