Intelligence Reporting Container

I am porting an existing Crystal Report to the Intelligence Report System.   This is a sales report for our salesmen.   One requirement we have is to show the Vendor ID of the items on the report.   I do not see Vendor information in the fields of the sample reports, is there any way of getting the information, or do I have to create our own container ?

How hard is it to create a custom container ?

  • 0
    Hi Rich, None of the standard containers that come with Sage Intelligence would have both Sales & Purchase fields, rather they are separated into separate containers. If the crystal code you are using to build your query in Sage Intelligence has all the necessary tables to drive your report, then the joins should be in order. All you would need to do is clean up the code; crystal comes over with 2 table names for each table. If on the other hand your crystal code does not have the Vendor table, that would need to be added and joined with RecordNumber to the LineItem table in the Sales Analysis container. To do this you would need to purchase the Connector module for $100 (I can get that for you). To address your question of "how hard is it?" I think it is easy, but it all depends upon your level of understanding with regard to the SI Connector module and PSQL programming language. If what I have told you so far is enough to get you going on this, great. If however you are not ready to step off that edge, I can train you or write the report for you.