Reporting Services Subscriptions

Hi All,
I'm testing RS with the Samples Reports, and especially the Product
Catalog report, which has no parameters, and is not a linked report.
I'm trying to make a subscription on this report, and I always get the
classical message shown bellow :
"Subscriptions cannot be created because the
credentials used to run the report are not stored,the report is using
user-defined para values,or if a linked report,the link is no longer
work."
So, as the report as no parameters, and is not a linked report, the
problem is with credentials.
I've changed the AdventureWorks datasource to make the credential
stored. The report is generated well.
But when I want to make a subscription? same message again.
I've tried with the "sa" account !!! Same message.
Am I wrong in my settings ?
Thanks for help.
DAThis report uses the user property which makes it unusable for
subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Death Angel" <lionel.valero@.scam.fr> wrote in message
news:d114e6a.0407290555.3734e70e@.posting.google.com...
> Hi All,
>
> I'm testing RS with the Samples Reports, and especially the Product
> Catalog report, which has no parameters, and is not a linked report.
> I'm trying to make a subscription on this report, and I always get the
> classical message shown bellow :
> "Subscriptions cannot be created because the
> credentials used to run the report are not stored,the report is using
> user-defined para values,or if a linked report,the link is no longer
> work."
> So, as the report as no parameters, and is not a linked report, the
> problem is with credentials.
> I've changed the AdventureWorks datasource to make the credential
> stored. The report is generated well.
> But when I want to make a subscription. same message again.
> I've tried with the "sa" account !!! Same message.
> Am I wrong in my settings ?
>
> Thanks for help.
>
> DA|||I am running into the same problem with my own custom
report. What is this 'user property' that is being
referred to and what needs to change?
Thanks for any assistance!!!
>--Original Message--
>This report uses the user property which makes it
unusable for
>subscriptions.
>--
>-Daniel
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Death Angel" <lionel.valero@.scam.fr> wrote in message
>news:d114e6a.0407290555.3734e70e@.posting.google.com...
>> Hi All,
>>
>> I'm testing RS with the Samples Reports, and especially
the Product
>> Catalog report, which has no parameters, and is not a
linked report.
>> I'm trying to make a subscription on this report, and I
always get the
>> classical message shown bellow :
>> "Subscriptions cannot be created because the
>> credentials used to run the report are not stored,the
report is using
>> user-defined para values,or if a linked report,the link
is no longer
>> work."
>> So, as the report as no parameters, and is not a linked
report, the
>> problem is with credentials.
>> I've changed the AdventureWorks datasource to make the
credential
>> stored. The report is generated well.
>> But when I want to make a subscription. same message
again.
>> I've tried with the "sa" account !!! Same message.
>> Am I wrong in my settings ?
>>
>> Thanks for help.
>>
>> DA
>
>.
>|||The user property is a property made available by RS. It contains
information such as the current user name (user running the report), their
language, etc. It is used in expression.
This link should help you:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"jb" <Jill.Barrett@.accesspointinc.com> wrote in message
news:044d01c47eec$716543a0$7d02280a@.phx.gbl...
> I am running into the same problem with my own custom
> report. What is this 'user property' that is being
> referred to and what needs to change?
> Thanks for any assistance!!!
> >--Original Message--
> >This report uses the user property which makes it
> unusable for
> >subscriptions.
> >
> >--
> >-Daniel
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> >
> >"Death Angel" <lionel.valero@.scam.fr> wrote in message
> >news:d114e6a.0407290555.3734e70e@.posting.google.com...
> >> Hi All,
> >>
> >>
> >> I'm testing RS with the Samples Reports, and especially
> the Product
> >> Catalog report, which has no parameters, and is not a
> linked report.
> >>
> >> I'm trying to make a subscription on this report, and I
> always get the
> >> classical message shown bellow :
> >>
> >> "Subscriptions cannot be created because the
> >> credentials used to run the report are not stored,the
> report is using
> >> user-defined para values,or if a linked report,the link
> is no longer
> >> work."
> >>
> >> So, as the report as no parameters, and is not a linked
> report, the
> >> problem is with credentials.
> >>
> >> I've changed the AdventureWorks datasource to make the
> credential
> >> stored. The report is generated well.
> >>
> >> But when I want to make a subscription. same message
> again.
> >>
> >> I've tried with the "sa" account !!! Same message.
> >>
> >> Am I wrong in my settings ?
> >>
> >>
> >> Thanks for help.
> >>
> >>
> >> DA
> >
> >
> >.
> >|||Thanks for the reference I was able to figure out what's happening. Now, of
course, I have another question.
Is there any way to allow for subscriptions while using integrated security
on the data source?
jb
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OLfyslvfEHA.3932@.TK2MSFTNGP09.phx.gbl...
> The user property is a property made available by RS. It contains
> information such as the current user name (user running the report), their
> language, etc. It is used in expression.
> This link should help you:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "jb" <Jill.Barrett@.accesspointinc.com> wrote in message
> news:044d01c47eec$716543a0$7d02280a@.phx.gbl...
> > I am running into the same problem with my own custom
> > report. What is this 'user property' that is being
> > referred to and what needs to change?
> >
> > Thanks for any assistance!!!
> >
> > >--Original Message--
> > >This report uses the user property which makes it
> > unusable for
> > >subscriptions.
> > >
> > >--
> > >-Daniel
> > >This posting is provided "AS IS" with no warranties, and
> > confers no rights.
> > >
> > >
> > >"Death Angel" <lionel.valero@.scam.fr> wrote in message
> > >news:d114e6a.0407290555.3734e70e@.posting.google.com...
> > >> Hi All,
> > >>
> > >>
> > >> I'm testing RS with the Samples Reports, and especially
> > the Product
> > >> Catalog report, which has no parameters, and is not a
> > linked report.
> > >>
> > >> I'm trying to make a subscription on this report, and I
> > always get the
> > >> classical message shown bellow :
> > >>
> > >> "Subscriptions cannot be created because the
> > >> credentials used to run the report are not stored,the
> > report is using
> > >> user-defined para values,or if a linked report,the link
> > is no longer
> > >> work."
> > >>
> > >> So, as the report as no parameters, and is not a linked
> > report, the
> > >> problem is with credentials.
> > >>
> > >> I've changed the AdventureWorks datasource to make the
> > credential
> > >> stored. The report is generated well.
> > >>
> > >> But when I want to make a subscription. same message
> > again.
> > >>
> > >> I've tried with the "sa" account !!! Same message.
> > >>
> > >> Am I wrong in my settings ?
> > >>
> > >>
> > >> Thanks for help.
> > >>
> > >>
> > >> DA
> > >
> > >
> > >.
> > >
>

reporting services samples

Hi,
I'm trying to look at the samples supplied with reporting services.
Found a folder with a bunch of samples
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Reports
which has a SampleReports.sln
this opens fine in visual studio .net (help about says Microsoft
Development environment 2003, Microsoft .Net Framework 1.1)
but when I right-click on any of the sample reports, e.g., Product
Catalog.rdl
it pops an error message saying "exception from HRESULT 0x80131500"
any insights?"msdninfo" <msdninfo@.newsgroup.nospam> wrote in message
news:OzLUTNZ2FHA.4008@.tk2msftngp13.phx.gbl...
> Hi,
> I'm trying to look at the samples supplied with reporting services.
> Found a folder with a bunch of samples
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Reports
> which has a SampleReports.sln
> this opens fine in visual studio .net (help about says Microsoft
> Development environment 2003, Microsoft .Net Framework 1.1)
> but when I right-click on any of the sample reports, e.g., Product
> Catalog.rdl
> it pops an error message saying "exception from HRESULT 0x80131500"
> any insights?
Well you can relax now, it came right of it's own accord. Now it just works.
OTOH it may come back later to bite since its cause is still unknown. :-)|||Hi,
Thanks for the information and it's great to know it works smoothly now.
A strange behavior seems to be memroy or pointer related. You are welcome
to post back with the detail description when it comes back again. Such as
Any related error in Event Log? How to reproduce it?
Have a nice week!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Reporting Services Question

Dear all,
Can anyone point me to some samples on aging reporting in reporting
services? Thank you.
Regards,
Kueh.On Mar 12, 9:46 pm, "KA Kueh" <k...@.ksm.com.my> wrote:
> Dear all,
> Can anyone point me to some samples on aging reporting in reporting
> services? Thank you.
> Regards,
> Kueh.
If I understand you correctly, once you have some reports deployed to
the Report Manager, you should be able to select a report and select
the 'Properties' tab where you will be able to modify the snapshot
history settings. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Hi,
Sorry for the confusion. I am looking for some sample report that
illustrate an Account Receivable Aging Report example.
Regards,
Kueh.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1173785210.009147.205450@.8g2000cwh.googlegroups.com...
> On Mar 12, 9:46 pm, "KA Kueh" <k...@.ksm.com.my> wrote:
>> Dear all,
>> Can anyone point me to some samples on aging reporting in reporting
>> services? Thank you.
>> Regards,
>> Kueh.
>
> If I understand you correctly, once you have some reports deployed to
> the Report Manager, you should be able to select a report and select
> the 'Properties' tab where you will be able to modify the snapshot
> history settings. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 14, 6:13 am, "KA Kueh" <k...@.ksm.com.my> wrote:
> Hi,
> Sorry for the confusion. I am looking for some sample report that
> illustrate an Account Receivable Aging Report example.
> Regards,
> Kueh.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1173785210.009147.205450@.8g2000cwh.googlegroups.com...
> > On Mar 12, 9:46 pm, "KA Kueh" <k...@.ksm.com.my> wrote:
> >> Dear all,
> >> Can anyone point me to some samples on aging reporting in reporting
> >> services? Thank you.
> >> Regards,
> >> Kueh.
> > If I understand you correctly, once you have some reports deployed to
> > the Report Manager, you should be able to select a report and select
> > the 'Properties' tab where you will be able to modify the snapshot
> > history settings. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
This might help.
http://www.databasejournal.com/features/mssql/print.php/3525516
Regards,
Enrique Martinez
Sr. SQL Server Developersql