Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jaz237
  • Content: Threads
  • Order by date
  1. jaz237

    Crosstab IF/THEN Statement Not properly assigning NULL

    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...
  2. jaz237

    Crosstab Comparing Current Year and Prior Year

    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...
  3. jaz237

    Insert Shading in Crosstab with only one Row

    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 =...
  4. jaz237

    Subtracting Values in Crosstab

    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...
  5. jaz237

    Formula to List Customer Call Schedule

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

Part and Inventory Search

Back
Top