Topic
  • 3 replies
  • Latest Post - ‏2012-08-17T13:52:36Z by KitKatNeko
KitKatNeko
KitKatNeko
8 Posts

Pinned topic Using SSRS for RM reports?

‏2012-08-15T17:41:01Z |
RM comes with a bunch of reports, I am mainly interesting in building a list of ready-to-be-disposed records.

I understand RM comes with Crystal Report (CR) reports that hence require a CR implementation - $$ on top of Filenet.

I am looking for anyone's experience who would have bypassed CR to use something else in order to create a list of ready-to-be disposed-of records.

So far I have been able to:
1 find the reports from the RM install package, it actually comes with quite a few
2 open the report with CR designer but still trying to understand it in order to extract the query it does against the Filenet DB.
3 seen that rpt to rdl converters exist but somehow are not legit as per CR license

Any experience or input towards this goal will be useful.

Thank you!
  • RuthHildebrand-Lund
    RuthHildebrand-Lund
    19 Posts

    Re: Using SSRS for RM reports?

    ‏2012-08-15T23:36:27Z  
    From an IBM perspective we do not support generating reports using any tool other than Crystal. That said, in the P8 InfoCenter we do provide information on the queries that are used for the reports and information on how to customize the templates.

    Refer to the following link for information on the SQL queries

    http://publib.boulder.ibm.com/infocenter/p8docs/v5r1m0/index.jsp?topic=%2Fcom.ibm.p8.ier.user.doc%2Frm_help%2Fadmin%2Freport_query_examples.htm

    And to the following link for general information on customization

    http://publib.boulder.ibm.com/infocenter/p8docs/v5r1m0/index.jsp?topic=%2Fcom.ibm.p8.ier.user.doc%2Frm_help%2Fadmin%2Fcustomize_report.htm

    If you want to generate reports using a different tool, then the only method I am aware of is to use the CE and RM APIs to extract the data you want to an external location and then use your report tool of choice with the extracted data.
  • KitKatNeko
    KitKatNeko
    8 Posts

    Re: Using SSRS for RM reports?

    ‏2012-08-16T18:14:07Z  
    From an IBM perspective we do not support generating reports using any tool other than Crystal. That said, in the P8 InfoCenter we do provide information on the queries that are used for the reports and information on how to customize the templates.

    Refer to the following link for information on the SQL queries

    http://publib.boulder.ibm.com/infocenter/p8docs/v5r1m0/index.jsp?topic=%2Fcom.ibm.p8.ier.user.doc%2Frm_help%2Fadmin%2Freport_query_examples.htm

    And to the following link for general information on customization

    http://publib.boulder.ibm.com/infocenter/p8docs/v5r1m0/index.jsp?topic=%2Fcom.ibm.p8.ier.user.doc%2Frm_help%2Fadmin%2Fcustomize_report.htm

    If you want to generate reports using a different tool, then the only method I am aware of is to use the CE and RM APIs to extract the data you want to an external location and then use your report tool of choice with the extracted data.
    thank you for this. this is more information I have been able to get from any PMR to IBM already.
  • KitKatNeko
    KitKatNeko
    8 Posts

    Re: Using SSRS for RM reports?

    ‏2012-08-17T13:52:36Z  
    poster submitted useful information