Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: problem with parameter Post Reply Post New Topic
Author Message
jnnpvan
Newbie
Newbie


Joined: 03 Aug 2012
Location: Canada
Online Status: Offline
Posts: 19
Quote jnnpvan Replybullet Topic: problem with parameter
    Posted: 25 Oct 2012 at 6:20am
I set up the parameter to run the report with the name os system, assignee,
First in the SELECT EXPERT,  I set the formula as below:
 

Date({Command.CreatedDateTime}) in {?StartDate} to {?EndDate} and

(({?Category} = "ALL") or ({?Category} = {Command.Category})) and

(({?Service} = "ALL") or ({?Service} = {Command.Service})) and

(({?SubCategory1} = "ALL") or ({?SubCategory1} = {Command.SubCategory1}))

 
 
but after refesh, run the report, it jsut display  2 blank pages . IT doesn't active with the paramers. I don't know why?
 
Lasy time I thought the Crystal version has problem, I uninstall and reinstall , but still the same problem.
 
Or the problem because of the query?
 
My query is:
------------------------------------------------------------------------------
 
select     c.ParentPublicID, c.incidentgroup, c.resareaoffailure,  
              c.resAreaOfFailureDetail,   a.CreatedDatetime, a.ChooseContact,
              a.requestorDisplayName, a.TypeOfRecord as ServiceType,
              a.Impact, a.Urgency, a.Priority,
              a.Description as WorkOrderDescription, a.Status,
              b.assignedTo, b.acknowledgedDateTime, b.ResolvedDateTime,
              b.Notes, b.ResolutionNotes

from         serviceDesk a
FULL OUTER JOIN   task b
ON            a.ServiceDeskID = b.ParentPublicID
                and   a.requestorDisplayName = b.SDInitiatior 
                and   a.TypeOfRecord = b.ParentServiceDeskType
 
FULL OUTER JOIN timerecord c
ON           c.ParentPublicID  IN
                        (SELECT distinct ParentPublicID
                                    FROM timerecord 
                         ) 
                 and  a.ServiceDeskID = c.ParentPublicID  
 
WHERE    a.CreatedDateTime between '2011-01-01' and getdate()
                and c.incidentgroup  in ('AOS', 'Tele')
                and c.ParentPublicID is not null
----------------------------------------------------------------------
 
 
Anyone can help me, please ! Thanks in advance.
 
 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 Oct 2012 at 7:16am
you have no logic in the select.



Date({Command.CreatedDateTime}) in {?StartDate} to {?EndDate} and
(if({?Category} = "ALL") then {Command.Category}='*' else
Command.Category} ={?Category}) and
(if({?Service} = "ALL") then {Command.Service} = '*' else {Command.Service} = {?Service}) and
(if({?SubCategory1} = "ALL") then {Command.SubCategory1} = '*' else ({?SubCategory1} = {Command.SubCategory1})

think that will work
IP IP Logged
jnnpvan
Newbie
Newbie


Joined: 03 Aug 2012
Location: Canada
Online Status: Offline
Posts: 19
Quote jnnpvan Replybullet Posted: 26 Oct 2012 at 4:21am
yeah, I didn the oposite way. THanks a lot.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.