Reporting services access problem !!!!!!!

Hi ..

I am facing a peculiar problem ... We have Sql Server 2005 reporting services installed on our server ...unfortunately our sysadmin by mistake has reinstalled the IIS on the server due to which the report server is not accessible .. The sql server is working fine no problem ..

normally we used to give .. http://domainname/reports and all the reports will be shown.

Now how do i reinstate the settings of the IIS ... for the Reporting services.

Could anybody suggest some ideas ...

Rgds

Chandru

Should be able to run the Reporting Services configuration, and just re-set the Virtual Directories and the Web Service Identity.|||

Ya .. thats ok .. But what is the virtual directory mappings i should give in IIS for the Team Foundation Server ....

Kindly enlighten me on this ....

|||

In your Configuration settings stop the report server. Then restart IIS, then restart the report server. This may or may not work but is worth a try

sql

Reporting Services - Export to PDF problem

We are facing some problem while exporting the SSRS (SQL Server 2005 SP2 installed on win2K3) Report to PDF format, problem is when we export report to PDF format all the data after 80 columns gets wrapped to next page which not only increases no. of pages in the reports but also disturbs the report format for example if a report contains only one page and 320 columns of data and if we export it to PDF format then the PDF file will have 4 pages each having 80 columns of date. Has anybody faced the similar issues? would appreciate if you can give solution for this problem or forward any link which discusses the same.

That is a common problem, you are exceeding the width of a sheet of A4. With 80 columns your column width would have to be tiny to fit them all on one page. You can get yourself a little extra width on the page by having it render in landscape mode, just swap over the width/height values under the PageSize parameter for the report. You can also reduce the margin sizes. These techniques will not get you a lot of extra space, if you still need more then the only way to get it is to redesign the report (more tables) or select less data (narrow the parameters or filter the returned data).

sql

Reporting Server Subscription Issue

Dear All,
We are facing some issue in reporting service subscriptions. In one of the
server when We create subscription to save or send report, Its giving below
error.
But reports works fine directly from the report manager.
ERROR:
Failure sending mail: An error has occurred during report processing.
Its not logging anything on the report server log file. We have configured
reports server's .config files to point to application's dll file.
Everything works fine from the report manager.
We created a report with some data from the database which is working fine
with the subscription. But when I added code to access application dll, its
not working through subscription
(though it works from report manager).
Anyone faced similar issue and able to solve, please let me know.
Thanks,
RamWhy would you change the config in such a way?

Reporting Server replacing IP address with ComputerName

Hello,
I am facing a strange situation with my reports server.
The machine i am testing the server on has no domain name, only IP.
But, of course, it has a computer name.
When i access the report server manager, i get everything as it should
be, and it shows me the links to the reports, but when i want to see
the report, the report manager replaces IP in the report address, with
the computer name - which makes no sense since i am accessing the
server using the internet.
Hence, i am getting an 404 in the report sub-page.
If i copy the url from there, and go to the page after changing the
computer name to the IP, it works, naturally.
Does anybody know how to change this behavior?
Thanks in advance! :-)
ShlomoYes you need to see this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
Scroll down to the section that says "Deploying a Report Server for Internet
Access"
=-Chris
<shlomoid@.gmail.com> wrote in message
news:1108301192.984825.325330@.o13g2000cwo.googlegroups.com...
> Hello,
> I am facing a strange situation with my reports server.
> The machine i am testing the server on has no domain name, only IP.
> But, of course, it has a computer name.
> When i access the report server manager, i get everything as it should
> be, and it shows me the links to the reports, but when i want to see
> the report, the report manager replaces IP in the report address, with
> the computer name - which makes no sense since i am accessing the
> server using the internet.
> Hence, i am getting an 404 in the report sub-page.
> If i copy the url from there, and go to the page after changing the
> computer name to the IP, it works, naturally.
> Does anybody know how to change this behavior?
>
> Thanks in advance! :-)
> Shlomo
>|||Thanks!
Worked perfectly.