Friday, March 30, 2012
Reporting Services Subscriptions
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
> > >
> > >
> > >.
> > >
>
Tuesday, March 20, 2012
Reporting Services linked report in a pop up window.
Hi All,
We have a j2ee application which uses Microsoft Reporting Services 2005 for reports.
In our JSP page we show and hide an IFRAME for which the src url is given as the Report URL with queryString for parameters.
Is there a standard way to POST data to report rather than passing it to URL in query String.
We also have a linked report.
We need to display this report in a Popup or provide a back button .
How to do this..
Kindly help me in this regard as we are new to reporting services
use the follwing java script to get the report in new windon
"javascript:void window.open('Reportviewer? + ReportName', '_blank', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"
|||HI this works when i give this in the Jump to URL and access through Report Manager.
When i click through my application. the url gets pasted in the address bar and page cannot be displayed screen is seen.
In my application when user clicks the run report button we show the Report in the same Page using IFRAME.
when the user clicks the Link for the linked report it is not opening in a popup.
"javascript:void window.open('Reportviewer? + ReportName', '_blank', 'location=0, menubar=0, toolbar=0, resizable=1, width=800')"
Please Tell me how to solve this.