Tech Support > Microsoft Windows > Windows CRM > CRM 4.0 orgname as parapameter Question
CRM 4.0 orgname as parapameter Question
Posted by BLAW on April 4th, 2008


I have created a report that is accessed through an iFrame in 3.0, we
upgraded to 4.0 last night. Everything is working fine but I am
getting the following error message from my iFrame report.

I'm assuming because of the multiple organizations in 4.0 the report
needs this as a paramater. I created a paramater, no default called
orgname but it is not working. How can I fix this, and where do I find
the orgname in the CRM 4.0 database?

An attempt was made to set a report parameter 'orgname' that is not
defined in this report. (rsUnknownReportParameter) Get Online Help

Posted by Michael Cross on April 5th, 2008


I was looking for the friendly org name myself just yesterday. The only place
I found it was in the MSCRM_CONFIG database, in the table dbo.Organization.

You will need to create a new dataset with a new datasource to access this
data for the report.

Michael Cross
Microsoft CRM Consultant
Navint
http://www.navint.com


"BLAW" wrote:

Posted by BLAW on April 7th, 2008


I'll try that first thing tomorrow!

Posted by BLAW on April 7th, 2008


I have added this as a paramater with a default of the company
orgname. I am still getting the same error?

An attempt was made to set a report parameter 'orgname' that is not
defined in this report. (rsUnknownReportParameter) Get Online Help

Posted by BLAW on April 7th, 2008


Ok I got it working. In addition I had to add 'userlcid' and 'orglcid'
as empty parameters, not of which needed to be added as datasets for
my usage.

Posted by jc2222 on June 3rd, 2008


I also created a report to run on the iframe.
however it's not passing the security through to the report when run from a
workstation. From the reports server - i can access the report from within
CRM as a windows users that has admin rights and is a CRM admin.
As the same user from a workstation - i can't run the report.

Can you send me the specifications needed for the datasource, when SRS and
CRM are on different servers for a report that is running on an iframe?

I used filtered views so even if i pass through sa security to the report -
the report comes up wiht zero as sa is not a valid user for the filtered
views.

Thank yoiu so much

"BLAW" wrote: