locked
How to display the report in iframe for on-premise CRM 2013 RRS feed

  • Question

  • I have a report on contract entity. It should run for every individual record. So passing the below query as the parameter to run the report. It working fine when I am running the report for the individual entity from report area.

    But my requirement is display the report in a iframe for the each record of the body, so that time it is always

     displaying the first record data always. Instead of populate the correspondent record data.

    Any help will be appreciated.

    The below url which i have given to the Iframe as source url

    http://****/crmreports/viewer/viewer.aspx?action=run&helpID=PolicyDetails.rdl&id=%7bEBF24AF9-13EA-E311-9A08-ECA86BF59625%7d

    Regards,

    Priya


    • Edited by PriyaSwain Wednesday, June 4, 2014 9:29 AM
    Wednesday, June 4, 2014 9:28 AM

All replies

  • You need to do prefiltering in your query. CRM will automatecally pickup the id of the current record:-

    http://msdn.microsoft.com/en-gb/library/bb955092.aspx

     

    Regards Faisal

    Wednesday, June 4, 2014 9:33 AM
  • Hi Faisal,

    Thanks for your time.

    Below is the query i am using to get the open record id.

    SELECT contractid FROM FilteredContract as CRMAF_FilteredContract.

    After getting the value i am storing it a another text field as parameter value.

    Finally I am passing the record ID to  my another query to get the related record of the open record.

    The related records populating properly from each record report area, but not populating in a iframe.

    In Iframe i am giving the report run rul as source. Is that correct way? Do I need to to something else?

    Regards,

    Priya.

    Wednesday, June 4, 2014 9:58 AM