Recreate Crystal report in Intelligence reporting

Does anyone know of a way or what the best way would be to recreate a Crystal Report in Intelligence Reporting?  I have created a container with all of the data tables but when I run the Sample data nothing comes up.  I know it has to do with the sql expressions but I'm unsure how to "translate" them so they work.  I am pretty proficient in both programs but converting CR to IR is just not working for me. 

Parents Reply
  • in reply to Jay Converse Acumen

    Looking @ the views , linking them to together header (batch) to detail

    inner join [amadjh] on [amadjh].[adjhid] = [amadjud].[ADJID}

    One of the easiest ways, now that you know tables/views, is to export from the entries and look in the files with the common keys. 

No Data