Remove From My Forums

Adding a parameter to a iframe report from bids

Question
0

Sign in to vote

I have three entities. A premises entity, a jobs entity and a audit entity. I have written a bids report showing all jobs and audits in decending order that have been carried out on the premises. I used a union in this report and in Bids it works great.

I now want to pass this report to CRM using a iframe in the premises entity and need to add a parameter so that it only shows the records related to the specific premises.

I have done some research and found a few things that mention javascript which I have no experience of.

Is there a simple solution?

many thanks for reading

Julesoutthere

Wednesday, November 27, 2013 10:14 AM

All replies

1

Sign in to vote
Hi,

Please check following link its really easy way to pass parameter to the report
http://rajeevpentyala.wordpress.com/2012/04/10/pass-parameters-to-the-report-hosted-in-iframe-or-web-page/

I hope this helps. If my response answered your question, please mark the response as an answer and also vote as helpful.
Mubasher Sharif
Check out my about.me profile!
http://mubashersharif.blogspot.com
Linked-In Profile
Follow me on Twitter!
- Proposed as answer by HIMBAPModerator Wednesday, November 27, 2013 10:33 AM
Wednesday, November 27, 2013 10:24 AM
0

Sign in to vote

Hi,

Don't think you can avoid using JavaScript if you want to embed the Report in an IFRAME.

Perhaps you already know this but without code, you can show the Report in the entity form or the entity list view (ie not embedded on the form). [In the report form>Categorization section select the Related Record Types and Display In fields]

With JS and not sure if you have looked at this page as well but its the kind of thing you're are referring to http://andreaswijayablog.blogspot.com.au/2011/08/crm-2011-embed-report-in-iframe-and.html

Hope this helps.
Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

Wednesday, November 27, 2013 10:41 AM
0

Sign in to vote

Hi thanks I am aware of using the related record types and display in fields my problem is that my report contains a union as I am reporting on two entities that do not have the same fields.
Julesoutthere

Thursday, November 28, 2013 2:42 PM
0

Sign in to vote

I cannot get this to work.

my report is published in report manager and

My URL = http://kfbrstest/Reports/Pages/Report.aspx?ItemPath=%2fFS%2fReports%2fCRM_Reports%2fJob+History+Test+Report+parameters

My parameter = p.optevia_premisesid = @premisesid)

So I tried this

http://kfbrstest/Reports/Pages/Report.aspx?ItemPath=%2fFS%2fReports%2fCRM_Reports%2fJob+History+Test+Report+parameters"&p:CRM_premisesid="={optevia_premisesid}"

and get this error

The path of the item '/FS/Reports/CRM_Reports/Job History Test Report
parameters"' is not valid. The full path must be less than 260 characters long;
other restrictions apply. If the report server is in native mode, the path must
start with slash. (rsInvalidItemPath) Get Online Help

What am I doing wrong?
Julesoutthere

Thursday, November 28, 2013 2:42 PM

Asked by:

Adding a parameter to a iframe report from bids

Question

All replies