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

    Help with a simple cross tab report

    Adam Wilden Expert



      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.