Asked by:
Adding a parameter to a iframe report from bids

Question
-
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
-
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 -
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 -
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 -
I cannot get this to work.
my report is published in report manager and
My parameter = p.optevia_premisesid = @premisesid)
So I tried this
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 HelpWhat am I doing wrong?
Julesoutthere
Thursday, November 28, 2013 2:42 PM