1).I got an error:
subscription cannot be created because the credentials used to run the
report are not stored, the report is using a user-defined parameter value...
However, can I solve this issue.
2). Is there any step by step guide to configure subscription.
ThanksThis is not complaining about Parameters, but about the data source... Open
the data source (on the report server) that this report uses, and select the
box , credentials stored securely on the server... then choose whichever
suboption suites you..
When a subscription is run, no user is running the report, instead the
server is running the report, so the login has to be stored. The server will
then use that login to run the subscription.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"qjlee" <qjlee@.discussions.microsoft.com> wrote in message
news:24A30193-13D9-41E9-8F48-AA572D4101D0@.microsoft.com...
> 1).I got an error:
> subscription cannot be created because the credentials used to run the
> report are not stored, the report is using a user-defined parameter
> value...
> However, can I solve this issue.
> 2). Is there any step by step guide to configure subscription.
> Thanks
>
Showing posts with label reprot. Show all posts
Showing posts with label reprot. Show all posts
Wednesday, March 7, 2012
reprot subscription error
Labels:
created,
credentials,
database,
error,
microsoft,
mysql,
oracle,
report,
reprot,
run,
server,
sql,
stored,
subscription,
user-defined
Reprot description not getting updated.
I publish an RDL to report server using web service, then later i have a
modified RDL which has the the report description changed. I republish with
"Overwrite" on my existing reprot using webservice. The description is not
getting updated in report manager.
If i edit the new report form report manager and look at the rdl it show the
new description but it will always dispalys the old description in the
description textbox.
Any idea how i could force it to update?Try manually deleting the description via the report manager interface and
then re-deploy.
Colin
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>I publish an RDL to report server using web service, then later i have a
> modified RDL which has the the report description changed. I republish
> with
> "Overwrite" on my existing reprot using webservice. The description is not
> getting updated in report manager.
> If i edit the new report form report manager and look at the rdl it show
> the
> new description but it will always dispalys the old description in the
> description textbox.
> Any idea how i could force it to update?|||Users cannot access report manager. They have to do this through our custom
interface that uses webservice to update reports.
"Microsoft" wrote:
> Try manually deleting the description via the report manager interface and
> then re-deploy.
> Colin
>
> "vRam" <vRam@.discussions.microsoft.com> wrote in message
> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
> >I publish an RDL to report server using web service, then later i have a
> > modified RDL which has the the report description changed. I republish
> > with
> > "Overwrite" on my existing reprot using webservice. The description is not
> > getting updated in report manager.
> >
> > If i edit the new report form report manager and look at the rdl it show
> > the
> > new description but it will always dispalys the old description in the
> > description textbox.
> >
> > Any idea how i could force it to update?
>
>|||Delete and redeploy is the only way. I assume through the web service you
can delete it as part of the deploy process.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:9E62EE10-0652-4E70-BFD5-54FB410AAE70@.microsoft.com...
> Users cannot access report manager. They have to do this through our
> custom
> interface that uses webservice to update reports.
>
> "Microsoft" wrote:
>> Try manually deleting the description via the report manager interface
>> and
>> then re-deploy.
>> Colin
>>
>> "vRam" <vRam@.discussions.microsoft.com> wrote in message
>> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>> >I publish an RDL to report server using web service, then later i have a
>> > modified RDL which has the the report description changed. I republish
>> > with
>> > "Overwrite" on my existing reprot using webservice. The description is
>> > not
>> > getting updated in report manager.
>> >
>> > If i edit the new report form report manager and look at the rdl it
>> > show
>> > the
>> > new description but it will always dispalys the old description in the
>> > description textbox.
>> >
>> > Any idea how i could force it to update?
>>
modified RDL which has the the report description changed. I republish with
"Overwrite" on my existing reprot using webservice. The description is not
getting updated in report manager.
If i edit the new report form report manager and look at the rdl it show the
new description but it will always dispalys the old description in the
description textbox.
Any idea how i could force it to update?Try manually deleting the description via the report manager interface and
then re-deploy.
Colin
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>I publish an RDL to report server using web service, then later i have a
> modified RDL which has the the report description changed. I republish
> with
> "Overwrite" on my existing reprot using webservice. The description is not
> getting updated in report manager.
> If i edit the new report form report manager and look at the rdl it show
> the
> new description but it will always dispalys the old description in the
> description textbox.
> Any idea how i could force it to update?|||Users cannot access report manager. They have to do this through our custom
interface that uses webservice to update reports.
"Microsoft" wrote:
> Try manually deleting the description via the report manager interface and
> then re-deploy.
> Colin
>
> "vRam" <vRam@.discussions.microsoft.com> wrote in message
> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
> >I publish an RDL to report server using web service, then later i have a
> > modified RDL which has the the report description changed. I republish
> > with
> > "Overwrite" on my existing reprot using webservice. The description is not
> > getting updated in report manager.
> >
> > If i edit the new report form report manager and look at the rdl it show
> > the
> > new description but it will always dispalys the old description in the
> > description textbox.
> >
> > Any idea how i could force it to update?
>
>|||Delete and redeploy is the only way. I assume through the web service you
can delete it as part of the deploy process.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:9E62EE10-0652-4E70-BFD5-54FB410AAE70@.microsoft.com...
> Users cannot access report manager. They have to do this through our
> custom
> interface that uses webservice to update reports.
>
> "Microsoft" wrote:
>> Try manually deleting the description via the report manager interface
>> and
>> then re-deploy.
>> Colin
>>
>> "vRam" <vRam@.discussions.microsoft.com> wrote in message
>> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>> >I publish an RDL to report server using web service, then later i have a
>> > modified RDL which has the the report description changed. I republish
>> > with
>> > "Overwrite" on my existing reprot using webservice. The description is
>> > not
>> > getting updated in report manager.
>> >
>> > If i edit the new report form report manager and look at the rdl it
>> > show
>> > the
>> > new description but it will always dispalys the old description in the
>> > description textbox.
>> >
>> > Any idea how i could force it to update?
>>
Subscribe to:
Posts (Atom)