Extra page in print preview and .pdf

I have tried and tried to get my reports to quit printing an extra blank page but have been unsuccessful in my efforts.

I've set the margins in my report properties to (all in inches):

.75 - top

.5 - left, right, bottom

My page is landscape so the width is 11 and the height is 8.5

I've made sure my table is not wider than 9.5 - I've even made it as small as 8" wide to see if that was the problem . (I've done this for the header/footer as well.)

My report prints all on one page but I still get a 2nd page with header/footer information and a blank body.

I read a post that said to try making the right margin 0 - that didn't work either.

Additional information: I just saw a post suggesting borders around everything to see what might be bleeding onto a 2nd page.

One page 1, the full borders are there, so nothing should be bleeding onto page 2. However, when I go to page 2, there are no borders around the header, but the left edge shows on the right side of the page. Also, the footer is missing it's left edge, but the right shows. I've tried making both the header and footer smaller, as well as moving them further right - still get the exact issue.

I'm using the reporting services for Visual Studio .NET 2003.

Any help would be greatly appreciated! Thanks!

Well, turns out it was the layout. Although my report elements were the right size, the layout was too big, forcing the margins over.|||

It is COOL that your posted your results!

|||

Hello - just a general comment!

I have eliminated the capability to export to PDF within RS in that PDF NEVER renders any ledgeable characters in my part of the world which includes:

Thailand, Cambodia, Laos, Mayamar (Burma), Vietnam, Pakistan and Tibet and this also includes any dialect in Mandarin!

We just stick to a TIF and everything is always perfect -

|||

When you say your layout was too big, what did you set it too?

Just curious, since I was having an issue similar to yours although I might not have worded it as clearly

http://forums.asp.net/1139722/ShowPost.aspx

Thanks

sql

Extra Browser window when exporting?

Hello,
I'm using the HTML Viewer and URL access to render my reports. When I change the format (for example to excel) on the HTML Viewer, and click the "export" link beside the drop down. A new browser window pops up and a save box prompting me to specify the location of where to save. After I choose the save destination, download the new formated report, and close the save box, the newly opened browser window remains open.

Is there any way to automatically close that browser window? or maybe even not show that browser window at all?

Thanks in AdvanceUnfortunatly there is no way to get rid of this extra box.|||Oh Well... Thanks for the response

Extra Browser window when exporting?

Hello,
I'm using the HTML Viewer and URL access to render my reports. When I change the format (for example to excel) on the HTML Viewer, and click the "export" link beside the drop down. A new browser window pops up and a save box prompting me to specify the location of where to save. After I choose the save destination, download the new formated report, and close the save box, the newly opened browser window remains open.

Is there any way to automatically close that browser window? or maybe even not show that browser window at all?

Thanks in AdvanceUnfortunatly there is no way to get rid of this extra box.|||Oh Well... Thanks for the response

Externally Linked Reports

Let's say I have a report which displays employee details based on employee Id. The Employee Id is passed to the report as a parameter. Lets say you can select this from the dropdown list on the report. All of these reports are deployed on report server 2005. What I also have is another application where you manage the employee data.

What I want to do is put a link in the management application to the eomployee detail report and pass the employee id in the link, so that the user does not have to select the employee id on the report. I know that we can provide a link to the reports, but I don't know if we can also pass parameters to those reports in that link.

Any help is appreciated, thanks!!

This is pretty straight forward. We are doing the same thing like so:

http://domainname/reportserver/Pages/ReportViewer.aspx?%2fOurReports%2fReportName&rs:Command=Render&Parameter=InsertParamValueHere

Essentially you can just add &Parameter=Value to the URL to pass the parameter.

|||

All you need to use is a query string. For example:http://servername/appname/page.aspx?id=EMPLOYEE_ID

Cheers!

Externally Accessing localmachine to view reports

How is it possible for others to browse to my localmachine and view the reports?
They tried browsing to http://machinename/reports
and http://10.1.3.123/reports

But the message the users get is: You are not authorized to view this page.

Then In my localmachine, I changed the IIS setting for the Reports and ReportServer to allow anonymous access. Then the users were able to see the Home page of the reports but not the reports themselves to click on for viewing. Any thoughts please?
Thanks

Have you created role assignments for the remote users?

http://msdn2.microsoft.com/en-us/library/aa337491.aspx

When you enable Anonymous, everyone coming into the Report Server looks like the same user (the anonymous user), but you still need to give the anonymous user RS permissions, but then everyone has those permissions, and you probably don't want that.

External web service as datasource for Reporting Service report

Hello,
I would like to make some Reporting Services reports from a datasource
that is a web service. Is this possible? I am using SSRS 2005. Any
suggestions or directions would be greatly appreciated.
photogulliverIt is possible but I haven't done it. Read up in Books On Line on XML.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-a98f-234454d5d267.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ehausig@.yahoo.com> wrote in message
news:1141931933.379723.119120@.e56g2000cwe.googlegroups.com...
> Hello,
> I would like to make some Reporting Services reports from a datasource
> that is a web service. Is this possible? I am using SSRS 2005. Any
> suggestions or directions would be greatly appreciated.
> photogulliver
>|||Yes. it is possible.
however, there are serious limitations on this approach. see other
postings in this group by me and Teo's responses to my postings.
1. the XML returned by the web service may not be readily consumable by
SSRS.
2. the query syntax to consume the XML is xpath like, but it is neither
xpath not xquery
3. security is a big concern. webservices consumption is non-secure
however, you can write your own custom data processing extension which
can overcome the above limitations.
thanks
- jasthi|||Ok, thanks for the feedback!
Eric

External scheduler for reports

Hi, here is my problem:
Because of some usability terms, I need to use SSRS scheduler to determine reports creation frequency (minimum frequency is once a day)I need to use an external scheduler to SSRS in order to launch reports creation daily, after some other batch tasks execution that must be completed before launching report creation.
And I have no idea on how to do that properly. Can somebody help me?

Thanks!

Hi,

Reporting Services has scheduling functionality included by default. You can use both report based schedules as global schedules to update your reports.

To use schedules, you must make sure that your reports are using fixed credentials to connect to the database (so no integrated security).

You can set up the schedules via the report manager.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Thanks for the answer.

I think I expressed myself in a bad way.
Creating my reports needs some batch tasks to be completed. These batch tasks are planed by a company scheduler.
So, my problem is that I want to be able to change report creation time (e.g. from 2am to 3 or 4am) with this company scheduler to ensure that all batch tasks had been totally completed before report creation starts.|||

Hi,

You can also create a .NET executable that creates the snapshot and then call the executable after the batch has been finished. This way you are sure that the batches are finished.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

External Images (URL Based) don't display on deployed reports

Hello,
I have a RS 2005 report which uses a report parameter as the source for an
image external image. When in report designer, everything works fine. When
deployed, the image shows as red x.
I am not using unattended credentials since the image is accessible without
credentials. I even tried images from microsoft.com and cnn.com
Any help would be appreciated.
-PedroHi Pedro,
Probabily the image directory is not proper. Just right click on the Red x
or view source to see where the image points to and check the directory for
your image. Better to include it in your project so that the link is not lost.
Amarnath
"Pedro" wrote:
> Hello,
> I have a RS 2005 report which uses a report parameter as the source for an
> image external image. When in report designer, everything works fine. When
> deployed, the image shows as red x.
> I am not using unattended credentials since the image is accessible without
> credentials. I even tried images from microsoft.com and cnn.com
> Any help would be appreciated.
> -Pedro
>
>

External Image Problems

I've placed a logo I'd like on my reports at the path
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
Any suggestions on what to try next appreciated?It now appears to have corrected itself, may have been a caching issue as I
deleted the report and then re-deployed it.
"Mark Parter" wrote:
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> Any suggestions on what to try next appreciated?|||The machine name where the reports manager is installed doesn't have an
underscore in it's name does it?
"Mark Parter" wrote:
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> Any suggestions on what to try next appreciated?|||Nope.
"Dan Fell" wrote:
> The machine name where the reports manager is installed doesn't have an
> underscore in it's name does it?
> "Mark Parter" wrote:
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > Any suggestions on what to try next appreciated?|||did you find the problem?
"Mark Parter" wrote:
> Nope.
> "Dan Fell" wrote:
> >
> > The machine name where the reports manager is installed doesn't have an
> > underscore in it's name does it?
> >
> > "Mark Parter" wrote:
> >
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring an
> > > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > > IIS, several times yet I still cannot get the logo to show when I view the
> > > report via the Report Manager.
> > >
> > > Any suggestions on what to try next appreciated?

External Image Problem, Please Help me out!

Hi,
I put a logo image as external source and it works fine on reports server.
The image is in the same folder as report file. However, when I use reporting
service web service to get report as HTML format, I keep getting logon window
and red cross for the image even after I logon. I already follow the
instruction to set up unattended account and reboot server several times. But
it's still no working. The web server is a dormain controller and it's win2k
server with sp4.
Can anyone help me out? I really really appreciate it.
AnthonyCan someone help me this? I asked several questions before, and never got
answered.
"Anthony Wang" wrote:
> Hi,
> I put a logo image as external source and it works fine on reports server.
> The image is in the same folder as report file. However, when I use reporting
> service web service to get report as HTML format, I keep getting logon window
> and red cross for the image even after I logon. I already follow the
> instruction to set up unattended account and reboot server several times. But
> it's still no working. The web server is a dormain controller and it's win2k
> server with sp4.
> Can anyone help me out? I really really appreciate it.
> Anthony|||Images are not rendered by default with SOAP addressability. See
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/ce78cc30cf781cc/5bbfe2e79a693f2c?lnk=st&q=renderstream+group%3A*.reportingsvcs+author%3Alachev&rnum=2&hl=en#5bbfe2e79a693f2c
Long story short, I highly recommend to switch to RS 2005 and use the report
viewer controls. They will handle the images for you.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Anthony Wang" <AnthonyWang@.discussions.microsoft.com> wrote in message
news:BB6C8F0C-56A4-44F1-9003-BAEC30EF3A11@.microsoft.com...
> Hi,
> I put a logo image as external source and it works fine on reports server.
> The image is in the same folder as report file. However, when I use
> reporting
> service web service to get report as HTML format, I keep getting logon
> window
> and red cross for the image even after I logon. I already follow the
> instruction to set up unattended account and reboot server several times.
> But
> it's still no working. The web server is a dormain controller and it's
> win2k
> server with sp4.
> Can anyone help me out? I really really appreciate it.
> Anthony|||thank you Teo, the link you give to me helps me a lot. Now I got it worked.
Really appreciate your help.
"Teo Lachev [MVP]" wrote:
> Images are not rendered by default with SOAP addressability. See
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/ce78cc30cf781cc/5bbfe2e79a693f2c?lnk=st&q=renderstream+group%3A*.reportingsvcs+author%3Alachev&rnum=2&hl=en#5bbfe2e79a693f2c
> Long story short, I highly recommend to switch to RS 2005 and use the report
> viewer controls. They will handle the images for you.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Anthony Wang" <AnthonyWang@.discussions.microsoft.com> wrote in message
> news:BB6C8F0C-56A4-44F1-9003-BAEC30EF3A11@.microsoft.com...
> > Hi,
> >
> > I put a logo image as external source and it works fine on reports server.
> > The image is in the same folder as report file. However, when I use
> > reporting
> > service web service to get report as HTML format, I keep getting logon
> > window
> > and red cross for the image even after I logon. I already follow the
> > instruction to set up unattended account and reboot server several times.
> > But
> > it's still no working. The web server is a dormain controller and it's
> > win2k
> > server with sp4.
> >
> > Can anyone help me out? I really really appreciate it.
> >
> > Anthony
>
>

External image problem when sorting in table

Reporting Services I am using external image png as my header for reports When i am clicking on sort row of the report the header image is dissapeared.Though it is working well in Visual Studio 2005 the problem is occuring after deploying it in reportserver.

What the reason and how can i remove this error.It was working well when i had embeded the image..But i need to have external image only..

Did you install SP1 on the report server (http://www.microsoft.com/sql/sp1.mspx)?

-- Robert

External Image Problem

I've placed a logo I'd like on my reports at the path
http://<servername>/reports/images/logo.gif
I've also performed the instructions as per the article "Configuring an
Account for Unattended Report Process" in the RS BOL. I've also re-started
IIS, several times yet I still cannot get the logo to show when I view the
report via the Report Manager.
If I login to the machine using the account used in the article above, I can
access the URL no problem via IE.
Any suggestions on what to try next appreciated?If the image is on the same server as the report, try using folder path
instead of URL, e.g. "/images/logo.gif".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> I've placed a logo I'd like on my reports at the path
> http://<servername>/reports/images/logo.gif
> I've also performed the instructions as per the article "Configuring an
> Account for Unattended Report Process" in the RS BOL. I've also re-started
> IIS, several times yet I still cannot get the logo to show when I view the
> report via the Report Manager.
> If I login to the machine using the account used in the article above, I
> can
> access the URL no problem via IE.
> Any suggestions on what to try next appreciated?
>|||Thanks for replying.
Unfortunately, that didn't work either. Any other ideas?
"Fang Wang (MSFT)" wrote:
> If the image is on the same server as the report, try using folder path
> instead of URL, e.g. "/images/logo.gif".
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > I've placed a logo I'd like on my reports at the path
> > http://<servername>/reports/images/logo.gif
> >
> > I've also performed the instructions as per the article "Configuring an
> > Account for Unattended Report Process" in the RS BOL. I've also re-started
> > IIS, several times yet I still cannot get the logo to show when I view the
> > report via the Report Manager.
> >
> > If I login to the machine using the account used in the article above, I
> > can
> > access the URL no problem via IE.
> >
> > Any suggestions on what to try next appreciated?
> >
>
>|||Fang meant that you would upload the image as resource directly on the
report server (e.g. through uploading it in report manager) and then
reference the image via a relative path inside the report server. Did you do
this?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> Thanks for replying.
> Unfortunately, that didn't work either. Any other ideas?
> "Fang Wang (MSFT)" wrote:
> > If the image is on the same server as the report, try using folder path
> > instead of URL, e.g. "/images/logo.gif".
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > I've placed a logo I'd like on my reports at the path
> > > http://<servername>/reports/images/logo.gif
> > >
> > > I've also performed the instructions as per the article "Configuring
an
> > > Account for Unattended Report Process" in the RS BOL. I've also
re-started
> > > IIS, several times yet I still cannot get the logo to show when I view
the
> > > report via the Report Manager.
> > >
> > > If I login to the machine using the account used in the article above,
I
> > > can
> > > access the URL no problem via IE.
> > >
> > > Any suggestions on what to try next appreciated?
> > >
> >
> >
> >|||I'm a little confused as to what the relative path is for an image uploaded
via Report Manager. The image itself is in the database so it doesn't follow
the directory hierarchy define in the Report Manager - right? So, if I
upload test.gif to the /MyFolder directory in Report Manager, how would I
access it and what image type (Embedded, Project, Database or Web) would I
select in the Report Designer?
"Robert Bruckner [MSFT]" wrote:
> Fang meant that you would upload the image as resource directly on the
> report server (e.g. through uploading it in report manager) and then
> reference the image via a relative path inside the report server. Did you do
> this?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > Thanks for replying.
> >
> > Unfortunately, that didn't work either. Any other ideas?
> >
> > "Fang Wang (MSFT)" wrote:
> >
> > > If the image is on the same server as the report, try using folder path
> > > instead of URL, e.g. "/images/logo.gif".
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > I've placed a logo I'd like on my reports at the path
> > > > http://<servername>/reports/images/logo.gif
> > > >
> > > > I've also performed the instructions as per the article "Configuring
> an
> > > > Account for Unattended Report Process" in the RS BOL. I've also
> re-started
> > > > IIS, several times yet I still cannot get the logo to show when I view
> the
> > > > report via the Report Manager.
> > > >
> > > > If I login to the machine using the account used in the article above,
> I
> > > > can
> > > > access the URL no problem via IE.
> > > >
> > > > Any suggestions on what to try next appreciated?
> > > >
> > >
> > >
> > >
>
>|||/MyFolder/test.gif would be the correct image path.
If you upload the image through report manager on a report server, then you
won't see it when you just preview a report in report designer. Only after
the report is deployed on the server!
Instead of independently uploading the image resources through report
manager, you may consider looking into so-called "Project Images" which are
contained in the report project and get automatically deployed to a report
server when deploying the entire report project from report designer. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
You would add the images as project images in the report project and then
reference them as e.g. test.gif in the report without the need to specify a
path. This is because the project images will get deployed in the same
folder as the reports.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> I'm a little confused as to what the relative path is for an image
uploaded
> via Report Manager. The image itself is in the database so it doesn't
follow
> the directory hierarchy define in the Report Manager - right? So, if I
> upload test.gif to the /MyFolder directory in Report Manager, how would I
> access it and what image type (Embedded, Project, Database or Web) would I
> select in the Report Designer?
> "Robert Bruckner [MSFT]" wrote:
> > Fang meant that you would upload the image as resource directly on the
> > report server (e.g. through uploading it in report manager) and then
> > reference the image via a relative path inside the report server. Did
you do
> > this?
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > Thanks for replying.
> > >
> > > Unfortunately, that didn't work either. Any other ideas?
> > >
> > > "Fang Wang (MSFT)" wrote:
> > >
> > > > If the image is on the same server as the report, try using folder
path
> > > > instead of URL, e.g. "/images/logo.gif".
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
message
> > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > I've placed a logo I'd like on my reports at the path
> > > > > http://<servername>/reports/images/logo.gif
> > > > >
> > > > > I've also performed the instructions as per the article
"Configuring
> > an
> > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > re-started
> > > > > IIS, several times yet I still cannot get the logo to show when I
view
> > the
> > > > > report via the Report Manager.
> > > > >
> > > > > If I login to the machine using the account used in the article
above,
> > I
> > > > > can
> > > > > access the URL no problem via IE.
> > > > >
> > > > > Any suggestions on what to try next appreciated?
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Thanks. I see that you could also reference this image via a browser by
http://<server>/Reportserver?%2fMyFolder%2ftest.gif. But, is there a way to
get the IMG tag generated in the HTML to use this form rather than always
returning a stream ID?
I have existing images in a web environment that I just want to reference in
the image tags. I can't write to our web servers (for security reasons) and
I can't have report parameters visible via "View Source" in the browser (I am
using secure web services to avoid this). The default image tags generated
break our security and privacy policies (report parameters are visible that
have our internal IDs) and if I set streamroot, I still have to deal with
generating an image with the stream ID (which I can't anywhere). Any help
would be much appreciated.
"Robert Bruckner [MSFT]" wrote:
> /MyFolder/test.gif would be the correct image path.
> If you upload the image through report manager on a report server, then you
> won't see it when you just preview a report in report designer. Only after
> the report is deployed on the server!
> Instead of independently uploading the image resources through report
> manager, you may consider looking into so-called "Project Images" which are
> contained in the report project and get automatically deployed to a report
> server when deploying the entire report project from report designer. See:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_layout_v1_0rz9.asp
> You would add the images as project images in the report project and then
> reference them as e.g. test.gif in the report without the need to specify a
> path. This is because the project images will get deployed in the same
> folder as the reports.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kraig Hiersche" <KraigHiersche@.discussions.microsoft.com> wrote in message
> news:C8B3451B-639C-4974-B088-1E061481583F@.microsoft.com...
> > I'm a little confused as to what the relative path is for an image
> uploaded
> > via Report Manager. The image itself is in the database so it doesn't
> follow
> > the directory hierarchy define in the Report Manager - right? So, if I
> > upload test.gif to the /MyFolder directory in Report Manager, how would I
> > access it and what image type (Embedded, Project, Database or Web) would I
> > select in the Report Designer?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Fang meant that you would upload the image as resource directly on the
> > > report server (e.g. through uploading it in report manager) and then
> > > reference the image via a relative path inside the report server. Did
> you do
> > > this?
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in message
> > > news:69199668-9820-46BA-BCEE-C83708A11C89@.microsoft.com...
> > > > Thanks for replying.
> > > >
> > > > Unfortunately, that didn't work either. Any other ideas?
> > > >
> > > > "Fang Wang (MSFT)" wrote:
> > > >
> > > > > If the image is on the same server as the report, try using folder
> path
> > > > > instead of URL, e.g. "/images/logo.gif".
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > > "Mark Parter" <MarkParter@.discussions.microsoft.com> wrote in
> message
> > > > > news:458593D1-7CEC-4B89-950F-5121CA1DFD95@.microsoft.com...
> > > > > > I've placed a logo I'd like on my reports at the path
> > > > > > http://<servername>/reports/images/logo.gif
> > > > > >
> > > > > > I've also performed the instructions as per the article
> "Configuring
> > > an
> > > > > > Account for Unattended Report Process" in the RS BOL. I've also
> > > re-started
> > > > > > IIS, several times yet I still cannot get the logo to show when I
> view
> > > the
> > > > > > report via the Report Manager.
> > > > > >
> > > > > > If I login to the machine using the account used in the article
> above,
> > > I
> > > > > > can
> > > > > > access the URL no problem via IE.
> > > > > >
> > > > > > Any suggestions on what to try next appreciated?
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>

external access

Hi evebody,

I′m making some reports on VS 2003, using RS 2000 and deploying it to a RS 2005 server

my problem is: is there any way to make a default user for accessing these reports, cause my reports can be seen by those who I grant permission (user from my domain)

I found the "execution account", but I couldn′t understand how I would use it, if this helps on my problem at all..and if I can use it with RS 2000 reports. (I know that some features of RS 2005 cannot be used on RS 2000 reports...)

Best Regards.

Pedro

Hi everybody!!

I′ve been reading some stuff, and I believe I can explain much better my problem.

I have a system that will be accessed on extranet. Users from extranet will be authenticated by an AD.

These users all have authorization to access my systems reports.

I′ve been reading the reporting services extension, and I discovered that I can use the IAuthorization Interface.

In this case I would implement the checkAccess method, checking if the users ID is in my AD and grant permission to requested report.

is my idea right?

Best regards,

Pedro

sql

Extending RS

I want to know if there is some place where I can find information on how to
extend RS, for example, create my custom controls for use in reports.
--
Eduardo FonsecaThis should help:
http://msdn2.microsoft.com/en-us/library/ms345231(SQL.90).aspx
--
Francisco Padron
www.chartfx.com

Extending ReportingServicesFileShareDeliveryProvider

Hello all,
I need to somehow extend the functionality of the
ReportingServicesFileShareDeliveryProvider so I can ship html formatted
reports along with their chart images to a file share. I've deployed some
reports using the mhtml file format, but alot of our users have problems
viewing reports in this format and our IT dept cannot figure out why...some
computers cannot view the reports unless windows system font is set to small.
Others cannot see the reports at all...and yet other have no problems.
The best thing will be to have the html format and the chart images
exported. The Printer Delivery example does not help 100% because of two
areas:
1) I'm wanting to extend an existing extension if possible...as opposed to
what the Printer Delivery example does...creating an extension from scratch
2) I want to stream the chart images out to the file share as well
Any assistence with this would be awesome. I'll hobble along in the
meantime...
-thanks, brian parkerHi Brian:
I don't see the extensions being too extensible themselves. The
parameters and delivery mechanisms are usually so disparate that it
wouldn't make any sense to inherit from an existing delivery class.
I have another sample that might be useful to you (although I haven't
taken care of delivering images, I plan to try this in the future).
The Blog Delivery Extension
http://odetocode.com/Blogs/scott/archive/2004/08/16/393.aspx
Deliver Reports To A Blog
http://odetocode.com/Blogs/scott/archive/2004/08/16/390.aspx
--
Scott
http://www.OdeToCode.com/
On Fri, 1 Oct 2004 20:03:02 -0700, Brian Parker
<BrianParker@.discussions.microsoft.com> wrote:
>Hello all,
> I need to somehow extend the functionality of the
>ReportingServicesFileShareDeliveryProvider so I can ship html formatted
>reports along with their chart images to a file share. I've deployed some
>reports using the mhtml file format, but alot of our users have problems
>viewing reports in this format and our IT dept cannot figure out why...some
>computers cannot view the reports unless windows system font is set to small.
> Others cannot see the reports at all...and yet other have no problems.
>The best thing will be to have the html format and the chart images
>exported. The Printer Delivery example does not help 100% because of two
>areas:
>1) I'm wanting to extend an existing extension if possible...as opposed to
>what the Printer Delivery example does...creating an extension from scratch
>2) I want to stream the chart images out to the file share as well
>Any assistence with this would be awesome. I'll hobble along in the
>meantime...
>-thanks, brian parker|||Scott, This worked beautifully for me. Thanks for your help...
"Scott Allen" wrote:
> Hi Brian:
> I don't see the extensions being too extensible themselves. The
> parameters and delivery mechanisms are usually so disparate that it
> wouldn't make any sense to inherit from an existing delivery class.
> I have another sample that might be useful to you (although I haven't
> taken care of delivering images, I plan to try this in the future).
> The Blog Delivery Extension
> http://odetocode.com/Blogs/scott/archive/2004/08/16/393.aspx
> Deliver Reports To A Blog
> http://odetocode.com/Blogs/scott/archive/2004/08/16/390.aspx
> --
> Scott
> http://www.OdeToCode.com/
> On Fri, 1 Oct 2004 20:03:02 -0700, Brian Parker
> <BrianParker@.discussions.microsoft.com> wrote:
> >Hello all,
> >
> > I need to somehow extend the functionality of the
> >ReportingServicesFileShareDeliveryProvider so I can ship html formatted
> >reports along with their chart images to a file share. I've deployed some
> >reports using the mhtml file format, but alot of our users have problems
> >viewing reports in this format and our IT dept cannot figure out why...some
> >computers cannot view the reports unless windows system font is set to small.
> > Others cannot see the reports at all...and yet other have no problems.
> >
> >The best thing will be to have the html format and the chart images
> >exported. The Printer Delivery example does not help 100% because of two
> >areas:
> >
> >1) I'm wanting to extend an existing extension if possible...as opposed to
> >what the Printer Delivery example does...creating an extension from scratch
> >2) I want to stream the chart images out to the file share as well
> >
> >Any assistence with this would be awesome. I'll hobble along in the
> >meantime...
> >
> >-thanks, brian parker
>sql

extending report server to support printing

Hi all
I am following the 'Deploying the Printer Delivery Sample' in order to add
printing functionality to reports.
After compiled code was put in both the reports server's and manager's bin
directories( and thier config files were
set accordingly), I can see the new printing delivery extension listed by
the server side (using the report server web service method
.ListExtensions(ExtensionTypeEnum.Delivery);).
But.. no sign for that extension when i open reports in the html viewer nor
in the subscriptions deliveries options..
I am not sure exactly where should i expect to see it if at all.. should i
create a button which will call the printing extension on click event'
I know that in the reports manager it should be listed in the subscription
deliveries options.
Another thing is that i am not sure i have added the codegroup section in
the *policy.config files correctly.
In the reports manager config file i had to remove it because it generated a
'no object reference' error..
I guess this should interfier at some point.
Thanks alot for your attention
ReaHi Rea:
Check Bryan's blog for some clarification on the codegroup placement:
http://weblogs.asp.net/bryanke/archive/2004/05/14/132110.aspx
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 26 Oct 2004 16:05:50 +0200, "Rea Peleg" <rea_p@.afek.co.il>
wrote:
>Hi all
>I am following the 'Deploying the Printer Delivery Sample' in order to add
>printing functionality to reports.
>After compiled code was put in both the reports server's and manager's bin
>directories( and thier config files were
>set accordingly), I can see the new printing delivery extension listed by
>the server side (using the report server web service method
>.ListExtensions(ExtensionTypeEnum.Delivery);).
>But.. no sign for that extension when i open reports in the html viewer nor
>in the subscriptions deliveries options..
>I am not sure exactly where should i expect to see it if at all.. should i
>create a button which will call the printing extension on click event'
>I know that in the reports manager it should be listed in the subscription
>deliveries options.
>Another thing is that i am not sure i have added the codegroup section in
>the *policy.config files correctly.
>In the reports manager config file i had to remove it because it generated a
>'no object reference' error..
>I guess this should interfier at some point.
>Thanks alot for your attention
>Rea
>
>

extending function: view dependencies

So I have a number of separate databases on my SQL 2005 Server.

I also have a number of Reports in SSRS.

Many of the stored procedures in the various databases reference tables, functions, and stored procedures in other databases on the same server.

How can I accomplish the effect of right clicking on a stored procedure for instance, clicking view dependencies, and having everything show up in that list, not just the items in that DB?

It is all stored in the database in one form or another, but I must be missing some crucial piece to integrating it all together.

Note: I did not design this system, just maintaining and modifying existing items. There are no schemas to speak of. SSRS will most likely move to a dedicated server at one point with other data warehousing functions, so the ability to span servers would be useful.

Thanks!

Matt

Mhmm, I think this is not possible unless you parse the procedue on your own. There are no entries for dependencies in the system tables created for non-db-local objects. Additionally you can′t use schemabinding for maintainance as schemabinding applies only to two part names.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||Are there any third party tools that would combine all this information into an enterprise version of "view dependencies"?

thanks|||

Hi,

Jens is correct. There is a lot of confusion about "sysdepends", so we've added a new section explaining SQL dependencies in a web refresh section of the BOL. Please read:

SQL Server 2005 Books Online

Understanding SQL Dependencies

New: 5 December 2005
http://msdn2.microsoft.com/en-us/library/ms345449.aspx

Re: " any third party tools" - A quick MSN search turned up

http://www.red-gate.com/products/sql_dependency_tracker/index.htm

which I have never used.

Regards

Extending Delievery Extensions in SQL Reporting Services

Hi All

We have requirement in Reports. When ever report is sent to file share using Reporting Services File Share extension than details of that file should be saved in database.

How can we achieve this functionality? What is the best possible way of achieving this?

Please let me know the solution.

Thanks in advance

Rehan Mustafa Khan
HCL Technologies
Noida,IndiaYou can to implement a windows service application.
This application will use the FileSystemWatcher class
present in the .NET Framework.

The application can be written to keep watch over the
directory into which the Reports will be saved. As soon
as a notification is received by the application it will query
the file attributes and save these attributes into the database
by using ADO.NET

Subrahmanya Raju
ProgressiveXperts Infolabs I (Pvt) Ltd
Hyderabadsql

Expression-based Data Source + subscription = No-go?

Set up reports to use expression-based data sources and everything works fine as far as executing and viewing the reports. The ConnectionString expression includes the credentials, and the "No credentials required" option is selected.

Unfortunately, am getting this when trying to create a subscription for same report. WTF?

eportingServicesService!processing!3!12/20/2006-12:20:07:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'XXXData'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'XXXData'. > System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
End of inner exception stack trace

You probably use something like “User!UserID” in data source expression. It’s forbidden for subscriptions (http://msdn2.microsoft.com/en-gb/library/ms156307.aspx) as there is no user at subscription execution time. Also, you probably created subscription first and changed data source definition after – otherwise you would get error during subscription creation.

|||

No, I'm not doing anything like that. In fact, it kind of seems like a MSFT bug to me?

Here is the expression for it:

=Assembly.Namespace.ClassName.StaticMethod("ConnectionStrings", Parameters!VariableName.Value, "KeyGroupInConfigFile")

Basically, it uses an assembly to pull a full connection string out (including the credentials) of a config file based on a key (Parameters!VariableName.Value).

|||Moreover, the subscription is saving the proper value for Parameters!VariableName.Value.|||

Most likely the custom assembly does not have enough permissions to access the config file and fails with a FileIOException or a code access security exception.

Can you check if the account configured to run the RS Windows Service has permissions in the file system to read from your configuration file?

-- Robert

|||

Will check that and report back...

|||

So I double-checked and the Windows service is currently running under the Local System account. So, it would seem all the rights would be there for it? Also, the config file in question is actually the RS Server web.config.

Would there be some sort of extra .Net configuration to do (keeping in mind that I pretty much made the trust on the custom assembly wide-open)?

|||Shameless reply to get back to the top. Anyone at MSFT able to help?|||Anyone?|||It most likely not an issue with user permissions. Are you sure your assembly has full trust?|||

Yes, as mentioned in previous post, the assembly does have full trust. Mind you, it works fine when running it, just the subscriptions are failing.

It kind of seems like the sequence of events when getting a subscription report ready has getting the datasources ready as the 1st step. If the datasource is based on expression, and that expression uses a saved parameter value, it bombs. Can you confirm or refute that? Thanks

|||

OK, problem solved! And I almost feel ashamed to admit what it was.

Essentially, as I mentioned in one of my first posts, the custom assembly looks to some values stored in the web.config. That's fine on the UI, but a subscription uses the WINDOWS service, and as such, my specialized web.config code wasn't working. A slight tweak to the assembly got everything on the right track.

Thanks to those who offered advice.

|||

Hi Bingo,
What was the tweak?

Thanks

Expression-based Data Source + subscription = No-go?

Set up reports to use expression-based data sources and everything works fine as far as executing and viewing the reports. The ConnectionString expression includes the credentials, and the "No credentials required" option is selected.

Unfortunately, am getting this when trying to create a subscription for same report. WTF?

eportingServicesService!processing!3!12/20/2006-12:20:07:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'XXXData'., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'XXXData'. > System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource dataSourceObj, ReportProcessingContext pc)
End of inner exception stack trace

You probably use something like “User!UserID” in data source expression. It’s forbidden for subscriptions (http://msdn2.microsoft.com/en-gb/library/ms156307.aspx) as there is no user at subscription execution time. Also, you probably created subscription first and changed data source definition after – otherwise you would get error during subscription creation.

|||

No, I'm not doing anything like that. In fact, it kind of seems like a MSFT bug to me?

Here is the expression for it:

=Assembly.Namespace.ClassName.StaticMethod("ConnectionStrings", Parameters!VariableName.Value, "KeyGroupInConfigFile")

Basically, it uses an assembly to pull a full connection string out (including the credentials) of a config file based on a key (Parameters!VariableName.Value).

|||Moreover, the subscription is saving the proper value for Parameters!VariableName.Value.|||

Most likely the custom assembly does not have enough permissions to access the config file and fails with a FileIOException or a code access security exception.

Can you check if the account configured to run the RS Windows Service has permissions in the file system to read from your configuration file?

-- Robert

|||

Will check that and report back...

|||

So I double-checked and the Windows service is currently running under the Local System account. So, it would seem all the rights would be there for it? Also, the config file in question is actually the RS Server web.config.

Would there be some sort of extra .Net configuration to do (keeping in mind that I pretty much made the trust on the custom assembly wide-open)?

|||Shameless reply to get back to the top. Anyone at MSFT able to help?|||Anyone?|||It most likely not an issue with user permissions. Are you sure your assembly has full trust?|||

Yes, as mentioned in previous post, the assembly does have full trust. Mind you, it works fine when running it, just the subscriptions are failing.

It kind of seems like the sequence of events when getting a subscription report ready has getting the datasources ready as the 1st step. If the datasource is based on expression, and that expression uses a saved parameter value, it bombs. Can you confirm or refute that? Thanks

|||

OK, problem solved! And I almost feel ashamed to admit what it was.

Essentially, as I mentioned in one of my first posts, the custom assembly looks to some values stored in the web.config. That's fine on the UI, but a subscription uses the WINDOWS service, and as such, my specialized web.config code wasn't working. A slight tweak to the assembly got everything on the right track.

Thanks to those who offered advice.

|||

Hi Bingo,
What was the tweak?

Thanks