2 Replies Latest reply on Sep 5, 2011 7:34 AM by AdamWilden

    Help with a simple cross tab report

    Expert

      Hi,

       

      I've never really used Crystal before (or at least not for many many moons) but have now been asked to produce a grouped report (which landesk can easily display on screen  but can't print -  well it can, but it won't print only the group headers and tries to print or export 40,000 entries!)

       

      So I am finally going to have to start using Crystal and this is therefore a blatant and cheeky request for help!

       

      I need a crosstab of category against month logged, for between prompted time periods.

       

      I've installed Crytsal and set up a connection to our DB server and can successfully import tables to the CrossTab wizard.

       

      So any advice on what tables I need?  IM_ Incident_Category obviously, but I also looked at IM_Incident though it doesn't seem to include a date.

       

      If anyone has an similar existing report I can look at (i.e. steal from)  or any advice I'd be very grateful.

       

      Cheers - Adam.