Showing posts with label view. Show all posts
Showing posts with label view. Show all posts

Friday, March 30, 2012

Reporting Services Subscriptions - Help!

Hi, I have two questions regarding subscriptions in Report Services 2000.

1) Is there a way to view all the subscriptions in one centralised place. I know that you can view all your own subscriptions, but I did not create all of them. What I need is to be able to see all the subscriptions for all the reports without having to go into each report and see if it has subscriptions associated with it (we have about three hundred reports)

2) How can you disable a subscription, for example, my warehouse may be down one day and I dont want my daily reports to get sent to my clients so I just want to disable the subscription, not delete it. Anyway to get around this?

Thanks in advance

Look in Subscriptions in the ReportServer Db. I've created reports pulling data from the ReportServer database.

To disable a Subscription I'd set the end date before today.

|||Thanks very much for the help. Have decided to go that route now

Reporting Services Subscriptions - Help!

Hi, I have two questions regarding subscriptions in Report Services 2000.

1) Is there a way to view all the subscriptions in one centralised place. I know that you can view all your own subscriptions, but I did not create all of them. What I need is to be able to see all the subscriptions for all the reports without having to go into each report and see if it has subscriptions associated with it (we have about three hundred reports)

2) How can you disable a subscription, for example, my warehouse may be down one day and I dont want my daily reports to get sent to my clients so I just want to disable the subscription, not delete it. Anyway to get around this?

Thanks in advance

Look in Subscriptions in the ReportServer Db. I've created reports pulling data from the ReportServer database.

To disable a Subscription I'd set the end date before today.

|||Thanks very much for the help. Have decided to go that route now

Monday, March 26, 2012

Reporting Services Report Manager Authentication Issue

Hi,

I have installed Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report.

Is there any way to disable this windows authentication dialouge box?

Regards,

PS: in the viewer i give the path of the report as http://localhost/Rerport/ABC.rdlThis forum is on .Net Framework (CLR) integration in SQL Server 2005 that allows you to write routines in CLR languages like c#, VB.NET etc.
I suggest posting your question in SQL Server Reporting Services forum to get a faster response.

Thanks,
-Vineet.

Wednesday, March 21, 2012

Reporting Services On Firefox 1.0

Hello Forum from a Newsgroup newbie,
..Was wondering: Has anyone had successes or failures when accessing Report
Manager or Report View in a Frefox Browser.
Trying to sell IE in a University environment has been difficult lately!!
Any solutions also welcomed :-}
--
Application Engineer / DBA
UCLA SOMOn Thu, 9 Dec 2004 12:59:09 -0800, "Marcial" <no_spam@.antispammer.com>
wrote:
>Hello Forum from a Newsgroup newbie,
>..Was wondering: Has anyone had successes or failures when accessing Report
>Manager or Report View in a Frefox Browser.
>Trying to sell IE in a University environment has been difficult lately!!
>Any solutions also welcomed :-}
>--
>Application Engineer / DBA
>UCLA SOM
Marcial,
I did spend some time trying various options but didn't succeed in
getting Firefox to work with SQL Server 2000 RS.
Andrew Watt
MVP - InfoPath|||Andrew,
what specific issues did you have with Firefox?
Pls. advise.
--
TIM ELLISON
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:6g9jr0dcfc46t27g8q0c5mi3nib7utj8md@.4ax.com...
> On Thu, 9 Dec 2004 12:59:09 -0800, "Marcial" <no_spam@.antispammer.com>
> wrote:
> >Hello Forum from a Newsgroup newbie,
> >
> >..Was wondering: Has anyone had successes or failures when accessing
Report
> >Manager or Report View in a Frefox Browser.
> >
> >Trying to sell IE in a University environment has been difficult lately!!
> >
> >Any solutions also welcomed :-}
> >--
> >Application Engineer / DBA
> >UCLA SOM
> Marcial,
> I did spend some time trying various options but didn't succeed in
> getting Firefox to work with SQL Server 2000 RS.
> Andrew Watt
> MVP - InfoPath|||We are having the same problem. The problem appears to be with the
height=100% on the iframe tags, which renders differently on browsers other
than IE (specifically Firefox and Opera). The body of the report appears as a
narrow band, instead of extending to the bottom of the browser pane.
"Tim" wrote:
> Andrew,
> what specific issues did you have with Firefox?
> Pls. advise.
> --
> TIM ELLISON
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:6g9jr0dcfc46t27g8q0c5mi3nib7utj8md@.4ax.com...
> > On Thu, 9 Dec 2004 12:59:09 -0800, "Marcial" <no_spam@.antispammer.com>
> > wrote:
> >
> > >Hello Forum from a Newsgroup newbie,
> > >
> > >..Was wondering: Has anyone had successes or failures when accessing
> Report
> > >Manager or Report View in a Frefox Browser.
> > >
> > >Trying to sell IE in a University environment has been difficult lately!!
> > >
> > >Any solutions also welcomed :-}
> > >--
> > >Application Engineer / DBA
> > >UCLA SOM
> >
> > Marcial,
> >
> > I did spend some time trying various options but didn't succeed in
> > getting Firefox to work with SQL Server 2000 RS.
> >
> > Andrew Watt
> > MVP - InfoPath
>
>|||You can make it visible by doing this:
javascript:void(document.getElementsByTagName('IFRAME')[0].attributes.height.value
= "500")
But i'm not sure if you can do that automatically.
chatlineboy wrote:
> We are having the same problem. The problem appears to be with the
> height=100% on the iframe tags, which renders differently on browsers
other
> than IE (specifically Firefox and Opera). The body of the report
appears as a
> narrow band, instead of extending to the bottom of the browser pane.
> "Tim" wrote:
> > Andrew,
> >
> > what specific issues did you have with Firefox?
> >
> > Pls. advise.
> >
> > --
> > TIM ELLISON
> > "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in
message
> > news:6g9jr0dcfc46t27g8q0c5mi3nib7utj8md@.4ax.com...
> > > On Thu, 9 Dec 2004 12:59:09 -0800, "Marcial"
<no_spam@.antispammer.com>
> > > wrote:
> > >
> > > >Hello Forum from a Newsgroup newbie,
> > > >
> > > >..Was wondering: Has anyone had successes or failures when
accessing
> > Report
> > > >Manager or Report View in a Frefox Browser.
> > > >
> > > >Trying to sell IE in a University environment has been difficult
lately!!
> > > >
> > > >Any solutions also welcomed :-}
> > > >--
> > > >Application Engineer / DBA
> > > >UCLA SOM
> > >
> > > Marcial,
> > >
> > > I did spend some time trying various options but didn't succeed
in
> > > getting Firefox to work with SQL Server 2000 RS.
> > >
> > > Andrew Watt
> > > MVP - InfoPath
> >
> >
> >

Wednesday, March 7, 2012

Reporting Services Error - SQL Server does not exist or access denied

Hi, I am unable to view my reports once deploying them. The error I get in Report Manager is SQL "Server does not exist or access denied". What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003). When I try to use the same connection string in Report Manager I get the error. Please note that I deploy the reports from my computer onto a different server where I am trying to access them. This problem started after installing some critical windows updates onto my local computer and it is driving me crazy. If anyone could suggest a course of action it would be greatly appreciated - so far I have not been able to make sense of what the problem is.
Thanks.Problem Solved - the database was using port 2433 - so i just changed that in my connection string.