Problem with Parameterized reports - changing default values

Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
1. When I run CRM3 parameterized reports using the RS Report Manager
interface i get error messages like " The 'CRM_Locale' parameter is missing
a value " or "The 'CRM_Locale' parameter is missing a value", however when
these reports are run from the CRM application or ReportServer URL interface
the reports work fine.
2. I inadvertantly changed one of the report parameter default values in
one of the reports to blank, how can i change it back to its original setting
"Override Default". The report now prints with a blank Prepared By: User Name
value.
Any suggestions would be greatly appreciated
GsBring the report up in the web front end- report manager. Go to the
properties and you can change the default parameters.
Doing so from the Development IDE will NOT change the parameters once the
report has been deployed.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Graham Smith" wrote:
> Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
> 1. When I run CRM3 parameterized reports using the RS Report Manager
> interface i get error messages like " The 'CRM_Locale' parameter is missing
> a value " or "The 'CRM_Locale' parameter is missing a value", however when
> these reports are run from the CRM application or ReportServer URL interface
> the reports work fine.
> 2. I inadvertantly changed one of the report parameter default values in
> one of the reports to blank, how can i change it back to its original setting
> "Override Default". The report now prints with a blank Prepared By: User Name
> value.
> Any suggestions would be greatly appreciated
> Gs|||Hi Wayne
> Bring the report up in the web front end- report manager. Go to the
> properties and you can change the default parameters.
>
Tried that, No Joy!
> > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > these reports are run from the CRM application or ReportServer URL interface
> > the reports work fine.
The reports do not render at all. It appears that these parameter values are
not being populated are missing when reports are run using the Report Manager
Interface. Reports without parameters run OK.
> 2. I inadvertantly changed one of the report parameter default values in
> one of the reports to blank, how can i change it back to its original setting
> "Override Default". The report now prints with a blank Prepared By: User Name
> value.
>
I cannot change this back to its original state. The report is CRM 3.0
standard Report "User Summary" the parameter is "CRM_FullName" It originally
had a
"Override Default" command button in the default value for this parameter.
When the reports are run from the CRM 3.0 web interface ot the ReportServer
URL web interface the report renders ok but without the value for the User
Name.
regards
GS
"Wayne Snyder" wrote:
> Bring the report up in the web front end- report manager. Go to the
> properties and you can change the default parameters.
> Doing so from the Development IDE will NOT change the parameters once the
> report has been deployed.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Graham Smith" wrote:
> > Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
> >
> > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > these reports are run from the CRM application or ReportServer URL interface
> > the reports work fine.
> >
> > 2. I inadvertantly changed one of the report parameter default values in
> > one of the reports to blank, how can i change it back to its original setting
> > "Override Default". The report now prints with a blank Prepared By: User Name
> > value.
> >
> > Any suggestions would be greatly appreciated
> > Gs|||What means "No Joy" exact.
Any error message after clicking "Apply" in the properties page?
You need to go to properties after open the report and don't click on execute.
"Graham Smith" wrote:
> Hi Wayne
> > Bring the report up in the web front end- report manager. Go to the
> > properties and you can change the default parameters.
> >
> Tried that, No Joy!
> > > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > > these reports are run from the CRM application or ReportServer URL interface
> > > the reports work fine.
> The reports do not render at all. It appears that these parameter values are
> not being populated are missing when reports are run using the Report Manager
> Interface. Reports without parameters run OK.
> >
> > 2. I inadvertantly changed one of the report parameter default values in
> > one of the reports to blank, how can i change it back to its original setting
> > "Override Default". The report now prints with a blank Prepared By: User Name
> > value.
> >
> I cannot change this back to its original state. The report is CRM 3.0
> standard Report "User Summary" the parameter is "CRM_FullName" It originally
> had a
> "Override Default" command button in the default value for this parameter.
> When the reports are run from the CRM 3.0 web interface ot the ReportServer
> URL web interface the report renders ok but without the value for the User
> Name.
> regards
> GS
>
> "Wayne Snyder" wrote:
> > Bring the report up in the web front end- report manager. Go to the
> > properties and you can change the default parameters.
> >
> > Doing so from the Development IDE will NOT change the parameters once the
> > report has been deployed.
> > --
> > Wayne Snyder MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> >
> > I support the Professional Association for SQL Server ( PASS) and it''s
> > community of SQL Professionals.
> >
> >
> > "Graham Smith" wrote:
> >
> > > Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
> > >
> > > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > > these reports are run from the CRM application or ReportServer URL interface
> > > the reports work fine.
> > >
> > > 2. I inadvertantly changed one of the report parameter default values in
> > > one of the reports to blank, how can i change it back to its original setting
> > > "Override Default". The report now prints with a blank Prepared By: User Name
> > > value.
> > >
> > > Any suggestions would be greatly appreciated
> > > Gs|||Hi
No Joy means it did not work!
There were no error messages after hitting the "Apply" button in the
Properties.
I cant set the Default Value back to its original setting, so the reports
being rendered by the CRM 3.0 Reports function and Reports Web browser URL
Interface are incorrect.
I can send screen shots of the problem if you can send an email alias to
reply to.
Thanks
GS
"Dev Main" wrote:
> What means "No Joy" exact.
> Any error message after clicking "Apply" in the properties page?
> You need to go to properties after open the report and don't click on execute.
> "Graham Smith" wrote:
> > Hi Wayne
> >
> > > Bring the report up in the web front end- report manager. Go to the
> > > properties and you can change the default parameters.
> > >
> >
> > Tried that, No Joy!
> >
> > > > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > > > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > > > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > > > these reports are run from the CRM application or ReportServer URL interface
> > > > the reports work fine.
> >
> > The reports do not render at all. It appears that these parameter values are
> > not being populated are missing when reports are run using the Report Manager
> > Interface. Reports without parameters run OK.
> >
> > >
> > > 2. I inadvertantly changed one of the report parameter default values in
> > > one of the reports to blank, how can i change it back to its original setting
> > > "Override Default". The report now prints with a blank Prepared By: User Name
> > > value.
> > >
> >
> > I cannot change this back to its original state. The report is CRM 3.0
> > standard Report "User Summary" the parameter is "CRM_FullName" It originally
> > had a
> > "Override Default" command button in the default value for this parameter.
> >
> > When the reports are run from the CRM 3.0 web interface ot the ReportServer
> > URL web interface the report renders ok but without the value for the User
> > Name.
> >
> > regards
> > GS
> >
> >
> >
> > "Wayne Snyder" wrote:
> >
> > > Bring the report up in the web front end- report manager. Go to the
> > > properties and you can change the default parameters.
> > >
> > > Doing so from the Development IDE will NOT change the parameters once the
> > > report has been deployed.
> > > --
> > > Wayne Snyder MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > >
> > > I support the Professional Association for SQL Server ( PASS) and it''s
> > > community of SQL Professionals.
> > >
> > >
> > > "Graham Smith" wrote:
> > >
> > > > Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
> > > >
> > > > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > > > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > > > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > > > these reports are run from the CRM application or ReportServer URL interface
> > > > the reports work fine.
> > > >
> > > > 2. I inadvertantly changed one of the report parameter default values in
> > > > one of the reports to blank, how can i change it back to its original setting
> > > > "Override Default". The report now prints with a blank Prepared By: User Name
> > > > value.
> > > >
> > > > Any suggestions would be greatly appreciated
> > > > Gs|||Sorry, I don't have the CRM Application.
But I had similare experience with parameters. If I changed parameter
settings on deployed report, the changes where not deployed.
Since this I allways need to change the parameter in the Report Manager
manuell after redeploy those reports. After manuell change of the parameters
I can see the changes in the parameter section of the report. And the URL
Access works again.
Whats a bit difficult is the way "allow null" settings are displayed in the
report manager. If I like to allow null I need to activate "have dafault" and
the value field must be empty. In the designer it is required to set Default
values to non and activate "Allow Null" and "Allow blank".
I assume if you apply the correct settings in the report manager for the
parameter, the url access must work.
"Graham Smith" wrote:
> Hi
> No Joy means it did not work!
> There were no error messages after hitting the "Apply" button in the
> Properties.
> I cant set the Default Value back to its original setting, so the reports
> being rendered by the CRM 3.0 Reports function and Reports Web browser URL
> Interface are incorrect.
> I can send screen shots of the problem if you can send an email alias to
> reply to.
> Thanks
> GS
>
>
> "Dev Main" wrote:
> > What means "No Joy" exact.
> >
> > Any error message after clicking "Apply" in the properties page?
> >
> > You need to go to properties after open the report and don't click on execute.
> >
> > "Graham Smith" wrote:
> >
> > > Hi Wayne
> > >
> > > > Bring the report up in the web front end- report manager. Go to the
> > > > properties and you can change the default parameters.
> > > >
> > >
> > > Tried that, No Joy!
> > >
> > > > > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > > > > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > > > > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > > > > these reports are run from the CRM application or ReportServer URL interface
> > > > > the reports work fine.
> > >
> > > The reports do not render at all. It appears that these parameter values are
> > > not being populated are missing when reports are run using the Report Manager
> > > Interface. Reports without parameters run OK.
> > >
> > > >
> > > > 2. I inadvertantly changed one of the report parameter default values in
> > > > one of the reports to blank, how can i change it back to its original setting
> > > > "Override Default". The report now prints with a blank Prepared By: User Name
> > > > value.
> > > >
> > >
> > > I cannot change this back to its original state. The report is CRM 3.0
> > > standard Report "User Summary" the parameter is "CRM_FullName" It originally
> > > had a
> > > "Override Default" command button in the default value for this parameter.
> > >
> > > When the reports are run from the CRM 3.0 web interface ot the ReportServer
> > > URL web interface the report renders ok but without the value for the User
> > > Name.
> > >
> > > regards
> > > GS
> > >
> > >
> > >
> > > "Wayne Snyder" wrote:
> > >
> > > > Bring the report up in the web front end- report manager. Go to the
> > > > properties and you can change the default parameters.
> > > >
> > > > Doing so from the Development IDE will NOT change the parameters once the
> > > > report has been deployed.
> > > > --
> > > > Wayne Snyder MCDBA, SQL Server MVP
> > > > Mariner, Charlotte, NC
> > > >
> > > > I support the Professional Association for SQL Server ( PASS) and it''s
> > > > community of SQL Professionals.
> > > >
> > > >
> > > > "Graham Smith" wrote:
> > > >
> > > > > Hi I have two issues: I have recently migrated SSRS2000 to SSRS2005.
> > > > >
> > > > > 1. When I run CRM3 parameterized reports using the RS Report Manager
> > > > > interface i get error messages like " The 'CRM_Locale' parameter is missing
> > > > > a value " or "The 'CRM_Locale' parameter is missing a value", however when
> > > > > these reports are run from the CRM application or ReportServer URL interface
> > > > > the reports work fine.
> > > > >
> > > > > 2. I inadvertantly changed one of the report parameter default values in
> > > > > one of the reports to blank, how can i change it back to its original setting
> > > > > "Override Default". The report now prints with a blank Prepared By: User Name
> > > > > value.
> > > > >
> > > > > Any suggestions would be greatly appreciated
> > > > > Gs