troubleshooting Question

How do I create a CRYSTAL Report utilizing a command with parmlist

Avatar of paigea
paigea asked on
Crystal ReportsJava EE
4 Comments1 Solution383 ViewsLast Modified:
I need to create a Crystal Report -Error Report and use a command to select my data.  I need to use the command instead of select expert as I need this performed on the server because there are timeout issues.  I need to select errors within a parameter start date and end date and also only companys that are selected via the parm.  Below I have attached the sql that I am trying to get to work in the command.  When I enter parameters in the command screen, they do not stay?? Also I am not quite sure how to code using the parameters within the command.
Command code
SELECT  "TABLE"."IVR_CALL_HEADER"."START_DATE", 
        "TABLE"."IVR_META_ERROR"."ERROR_ID"
      ,COUNT("TABLE"."IVR_META_ERROR"."ERROR_ID") AS ERROR
 
  FROM "TABLE"."IVR_ERROR_EVENT"
      ,"TABLE"."IVR_META_ERROR" 
      ,"TABLE"."IVR_EVENT"      
      ,"TABLE"."IVR_STATE"      
      ,"TABLE"."IVR_CALL_HEADER"
 
 WHERE "TABLE"."IVR_ERROR_EVENT"."META_ERROR_ID" = "TABLE"."IVR_META_ERROR"."META_ERROR_ID"
   AND "TABLE"."IVR_ERROR_EVENT"."EVENT_ID" = "TABLE"."IVR_EVENT"."EVENT_ID"
   AND "TABLE"."IVR_STATE"."STATE_ID" = "TABLE"."IVR_EVENT"."STATE_ID"
   AND "TABLE"."IVR_STATE"."CALL_ID" = "TABLE"."IVR_CALL_HEADER"."CALL_ID"
AND "TABLE"."IVR_CALL_HEADER"."START_DATE" IN (?STARTDATE) TO( ?ENDDATE)
(I am not sure how to accomplish the following)
AND iif({?Company}='All',TRUE,{?Company}={IVR_CALL_HEADER.APPLICATION_NAME})
    
GROUP BY   "TABLE"."IVR_CALL_HEADER"."START_DATE",
              "TABLE"."IVR_META_ERROR"."ERROR_ID"
Open in New Window Select All 
Tags:
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros