Reporting services Setup

HI, this will prob be a stupid question but i have setup reporting services and am trying to use it, however, when creating a new project i only have Visual Studio Solution under other project Solutions and not any of the other types i.e. Visual Basic Solution etc. How do i get the other types? Do i need to install anything further?

Thanks David

If you installed client/development tools when you installed Reporting Services, you shouuld see "Business Intelligence Projects" when you select New, Project from the file menu.

If not, then the development tools were not installed correctly, re-run setup.

You will not see Visual Basic/C#, etc projects unless you install the full version of Visual Studio. The version of Visual Studio that comes with SQL Server does not include those.

BobP

|||

To add to what Bob said: you can install Visual Studio Express in the C# or VB versions if you want those and don't have access to full-blown Visual Studio...

>L<

Reporting Services Reports In Firefox and Safari Browsers

Hi,1. We are using SQL Server 2005 Reporting services for creating reports for a many of our web applications. However, we find that the reports render correclty only in IE. When trying to view the reports in browsers like Safari or Firefox, the alignment of the report is totally messed up. Any way to fix this problem ? 2. We use the Report viewer control in the ASPX page to view the reprot. However, in many cases it is seen that the last part of the report is not visible. A scroll bar comes up for scrolling the report page, but it does not help. We have a header and footer for the page and we use Master Pages.3. Is there any other way other than enabling the 'Anonymus Access' in IIS to provide access to users to the reports craetd using reporting services ? Thanks and regardsRajendran Menon

Hi Rajendra,

Regarding reports not working on firefox, this a very common problem and there is no great solution available.

Browser Support for ReportViewer Web Server Controls -http://msdn2.microsoft.com/en-us/library/ms251673(VS.80).aspx

The reason for this problem is how report viewer renders the reports. Report viewer uses iframes to render the reports which is not supported by firefox. Check this post to get around this problem-

http://weblogs.asp.net/jgalloway/archive/2006/09/01/SQL-Reporting-Services-_2D00_-CSS-fix-for-Firefox.aspxIn our case we added dummy textboxes in reports so that there is no empty space horizontally in report. you will need to place empty text boxes in your report which spans the width of the report(in each section Header, Body and Footer).One other solution which can work is to turn off the asynchronous rendering (as reports will be rendered as html and not iframes) -http://msdn2.microsoft.com/en-us/library/ms252090(VS.80).aspx|||

Hi Joshi,

Thank you for the suggestions. We will give it a try and see if it works.

Thanks once again

Rajendran Menon

|||

Aj,

I'm wondering if I have another piece of the puzzle here...

When my website is deployed to a production server (with latest reportviewer control installed) then the reports all display crushed over to the left when viewed with firefox.

However.. and this is the whacky thing... when I run the website in visual studio on my desktop machine.. and point firefox at THAT.. then the reports display just fine...

So is it just that IIS renders the pages differently to cassini maybe?

On the server I'm running Windows 2003 server (SP2) .. on my desktop its just windows professional...

but anyway, the point here.. is that the reports render fine in firefox from visual studio.. but their width is totally screwed when deployed on a server...

Any ideas anyone?

Vida

|||

Hi there

I downloaded Reportviewer SP1 from the MSDN website and that fixed the column sizes!
http://download.microsoft.com/download/6/e/d/6eda0f6a-4fb3-4880-bd96-fe71d7c12aa0/ReportViewer.exe

reporting services oracle connection

I have SQL Server 2005 Enterprise edition setup. I am creating reports with
oracle as the data source. I can make the connection in report designer and
preview the reports with no error. And also deploy them to the report server.
But when I try to view them through report manager I get an error
'A processing error has occurred. ORA-12154 TNS:could not resolve the
connect identifier specified '
Any suggestions?
Thanks!If you're developing reports on a workstation and they look good
locally, but error when you deploy, make sure the Oracle client on the
SSRS box is pointing to the correct Oracle Home directory. Best way to
do that is with the Oracle Network Config tool.
I've got mine setup to use the Oracle Supplied .Net 2.0 Connector and I
have to say that it is a much better connection than either OLE DB
Connector. Of course, you still need to setup TNS names correctly.
Garth H
webdev511@.spamcop.net
Microsoft Certified Professional
Macromedia Certified Developer

Reporting Services OLAP Report through Report Manager

I am creating a report in Reporting Services that hits an Analysis services
cube using MDX. The report has parameters so some of the MDX queries are
placed into strings. When running the report on my local machine it works
correctly, but when I deploy the report and run it through Report Manager it
locks up and will not display. It also brings down the Web server for a few
minutes.
The parameter lists in the report are created with a static MDX statement
and they will display, but the report keeps turning and never renders to the
screen.
I have looked at the site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
but I cannot find anything on why the report would work locally but not
through Report manager.
Any advice or directions would be greatly appreciated.I was able to solve this problem. The SQK server with my Cubes had Analysis
Services SP3. The box that I was developing the OLAP report was also running
AS SP3 but the Report Server did not have any service packs installed. This
was causing the OLAP report to lock up on the report server. Analysis
services was installed onto the report server after the report server and
visual studio. I believe that Analysis services over wrote the MSOLAP80.dll
to the 8.0.195 version.
After installing AS SP3 on the report server I was able to view OLAP Reports
through the Report Manager without locking up or bring down the web server.
"AndyT" wrote:
> I am creating a report in Reporting Services that hits an Analysis services
> cube using MDX. The report has parameters so some of the MDX queries are
> placed into strings. When running the report on my local machine it works
> correctly, but when I deploy the report and run it through Report Manager it
> locks up and will not display. It also brings down the Web server for a few
> minutes.
> The parameter lists in the report are created with a static MDX statement
> and they will display, but the report keeps turning and never renders to the
> screen.
> I have looked at the site
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
> but I cannot find anything on why the report would work locally but not
> through Report manager.
> Any advice or directions would be greatly appreciated.
>

Reporting Services in SQL 2000

I would like to learn/more, practice creating and using reports but I don't know if I can do that on my home laptop with version 2000. I know, I know... upgrade to 2005. Can't do that due to technical difficulties on my other pc. Can I do this with my current setup?

thx

Kat

Yes you can. For SQL 2000, Reporting Services came as an add on component rather that being part of main install package.

You will need to have Windows 2000 or XP Professional which comes with IIS. This is required for running Reporting Services.

|||

here are some links that will be helpful to you:

Download of Reporting Services for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en

Reporting Services for SQL Server 2000 documentation
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en

White papers and Technical articles about Reporting Services for SQL Server 2000
http://www.microsoft.com/technet/prodtechnol/sql/2000/technologies/rptsvcs.mspx

hope this helps,

Tai Yee
SQL Server

|||

It looks like I can't do this on a standalone pc, but need to have a server that I'm using... frustrating!

Kat

|||

Hi,

Do you have the SQL Server 2000 is installed on your computer? As I remember, Reporting Services needs at least a Standart Edition for SQL2K

If you have SQL Server, then you need the IIS also installed on your pc.

If you want to create reports, you need also the VS.Net 2003 installed on your pc.

I can all run them on my laptop which is an XP SP2. Your machine does not need to be a server :)

Eralper

http://www.kodyaz.com

|||That's right. But I believe you need XP Professional and not XP Home edition because you don't get IIS with XP Home.|||

I only have 2000 Professional Edition. Looks like I'll have to wait for my other laptop to be repaired and then I'll try again.

I HOPE, I HOPE, I HOPE it works!

thx

Kat

|||Windows 2000 Professional should work just fine.|||

Hi,

I should get my xp professional laptop back this next week and I will have the Developer edition of SQL Server 2000 soon to be upgraded to 2005. You say I need IIS installed which I understand, but is VS.Net 2003 a free product or does this have to be paid for?

thx,

Kathleen