Hi all,

any ideas on this....

We have created a number of Quotation Reports that work fine for all users
except one !

When she runs the report she gets an error saying the sub report can be
found.

I have checked that she is in the same CRM groups as other users and checked
that she is in the Reporting group in Windows/SQL - all looks fine.

Any help would be appreciated

Thanks

Ian

Hi Ian,

Does she have problem with this report only or this happens to her
other reports as well?

Darren Liu, Microsoft CRM MVP
http://www.crowecrm.com



On Nov 7, 5:29 am, "Ian Kelsall" <ian.kels...@crmnews.com> wrote:

Ian,

I was pulling my hair out a few months ago when a single user was having
problems with Reports, despite being a member of the same groups as everyone
else. I ended up resolving the issue by explicitly adding her domain login
to the approved logins for the CRM database with just basic db_datareader
permissions. Once I did that, she was able to run reports fine. Here's the
kicker... out of curiosity, I removed her login afterwards and it still
worked for her. Go figure.

"Ian Kelsall" wrote:

Hi Darren,

on further testing, she cant run any reports at all. For example when she
tries to run the standard sales pipeline report she gets the following:
Reporting Services Error

--------------------------------------------------------------------------------

a.. The property 'nullable' of report parameter 'CRM_Locale' is set to
false. However, the corresponding parameter (default) value is null or
contains an empty string. (rsProcessingError) Get Online Help

--------------------------------------------------------------------------------

Microsoft Reporting Services

Any idea what this means ?

Ian


"Darren Liu" <darrenliu@gmail.com> wrote in message
news:1194450848.824309.34800@z9g2000hsf.googlegrou ps.com...

Chad,

thanks for that - unfortunately this didnt work for me. I added her in SQL
as db_datareader but she still cant run reports.

Ian
"Chad" <Chad@discussions.microsoft.com> wrote in message
news:50EC9A26-07B6-4057-99E9-648700CF67C3@microsoft.com...

Hi Ian,

Did she access report using the URL for the IP address? If she using
the IP address. Kerbero don't work with IP, she need to use the url to
access CRM. Also please check her IE setting with the other users,
make sure it's the same, IE might block the authentication pass to the
CRM server.

Darren Liu, Microsoft CRM MVP
http://www.crowecrm.com



On Nov 8, 4:29 am, "Ian Kelsall" <ian.kels...@crmnews.com> wrote:

Hi darren,

she is just using the report buttons inside CRM.

She always starts CRM with a shortcut which is http://crmservername (not IP)
so I am assuming the report will use the same URL.

Thanks

Ian

"Darren Liu" <darrenliu@gmail.com> wrote in message
news:1194533866.999238.182310@e34g2000pro.googlegr oups.com...

Still trying to solve this if anyone has an idea ?

"Ian Kelsall" <ian.kelsall@crmnews.com> wrote in message
news:eoWSXoiIIHA.4688@TK2MSFTNGP06.phx.gbl...

Hi Ian K.

Still trying to solve this?

Can this user run the report when accessing directly the ReportServer?

Is this users privilege (roles) has access (at least read) to the entity
being accessed in the Sub-report? This could eventually be the problem.

Try giving this user the same roles as of the users that can run the report.

Regards,
Ian S.

"Ian Kelsall" wrote:

Yep - still trying to solve it.

We are down to the fact that it must be something to do with her windows
profile - so we are about to try deleting that and giving her a clean
profile.

She does have complete access to all the data in the report - in fact she
created it all so it cant be a rights issue.

In fact she cant run any reports at all - even something simple like an
account summary for one of her accounts.

Any further suggestions would be gratefully received.

Thanks

Ian




"Ian Salgado" <IanSalgado@discussions.microsoft.com> wrote in message
news:665BF009-05F4-4CE1-BDC7-A2BC3EB4559D@microsoft.com...

Hi Ian K.

Wait! Before deleting (I suggest disabling) the User profile in AD, make
sure you remove the CRM Users license and assign it to another user first.

If this user can create records then it should not be an AD problem, right?
This could be RS settings after all She can't access the reports in CRM
and in the Report server also?

Try checking in the Report Server if this particular users has a Browser for
CRM

Have you tried trying to give this particular user the Administrator role
for testing purposes?

privilege.

Regards,
Ian S.

"Ian Kelsall" wrote:

Hi Ian S,

appreciate the feedback...

When she points the browser to http:\\servername\reports - all she sees is
the Home page - but nothing is listed. This is exactly the same for any
other user who can run reprts normally from inside CRM.

I dont believe this relates to a particular report or sub report. If she
runs a standard Account overview, she gets an error...

The property 'nullable' of report parameter 'CRM_Locale' is set to false.

If I add here to the Admin group, she still has the same problem - a
CRM-locale error comes up after hitting run..

Ian K.

"Ian Salgado" <IanSalgado@discussions.microsoft.com> wrote in message
news:64466FBD-7D4C-41A9-AE34-B810C609DB4B@microsoft.com...

Hi Ian K.

Try checking this KB link for your particular error.
http://support.microsoft.com/kb/927021 I suggest you do Resolution 2 first
before any other things.

Hope this would eventually fix your problem

HTH
Ian S.

"Ian Kelsall" wrote:

Hi ian S,

I looked at this KB a while ago - sure I tried that but will go check
anyway.

Thanks

Ian K
"Ian Salgado" <IanSalgado@discussions.microsoft.com> wrote in message
news:16912439-4D9A-4117-87B8-C90FD114B986@microsoft.com...

Just in case anyone else has this issue - we finally resolved it.

The user in question had an identical domain name to a pervious CRM user.

Some time ago a user who left the company had been deleted from AD - but the
user record was still in the CRM database.

A new user joined later and was given an identical domain name - so there
were 2 records in the CRM database with identical dn's.

Once we cleaned up the user could run reports OK.

Just odd that she could do everything else OK - just the reports failed for
her !

Thanks

Ian

"Ian Kelsall" <ian.kelsall@crmnews.com> wrote in message
news:eFjoJLGVIHA.4448@TK2MSFTNGP03.phx.gbl...