Reporting Services Help
-
I hope I'm posting this in the right forum -- apologies if not!
I'm running SQL Express and SQL reporting services 2000 and have developed a number of .rdl report files for an application that I've written in Visual Studio. I've gotten to the point in my application where I'm ready to launch the reports but I can't do this unless they've been deployed to a report server.
So I've duly set up a test report server on a machine running WinXP + SQL server 2000 but when I try to add the .rdl files to report manager, it errors and tells me that the report definition is invalid.
I'm probably just having a blonde moment, but what is the exact process for deploying the .rdl files onto the report server?
I've had a look at a couple of tutorials, but none of them seem to answer that magic question.
Can anyone point me in the right direction?
TIA
Lil Ms Squirrel
-
If you are using SQL Express with Advanced Data Services to develop your reports you are developing your reports in the SQL 2005 format which is different than the SQL 2000 format. This is why you cannot deploy the reports to your test report server (SQL Server 2000).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Well it's a bit complicated.
I installed VS.net 2005.
Then a while later I installed SQL express.
Then I installed SQL reporting services from an MSDN CD that said it is SQL Server 2000 reporting services.
So I assumed that's what I had. SQL reports 2000. Is there any way I can check my SQL reporting services version?
-
In VS 2005 you can go to Help->About and it lists the different products installed and by selecting Reporting Services it tells you the version. SQL 2000 is 8.* and 2005 is 9.*
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Ah, okay. Brilliant! That's a start at least.
I'm running SQL reports 9x
Now a friend of mine who is a bit of a SQL reports guru (well better than me :D) mentioned today that to make my life easier, I could develop .rdlc files and have them run on the client rather than having to faff around with Report Server at all.
But when I try to create a new report file, it doesn't offer me .rdlc files.
Does anyone know how I can get that into my default template list? Or how I go about creating them? I did find an MSDN article about how to change the xml on existing reports to make them rdlcs, but I still have a number of new reports to create (ugh, I hate reporting :hehe:) so I would love to know how to create the rdlcs straight away...
-
In order to get rdlc files you need to be in a .NET project, not a reporting services project. You do add new item and select report. Then you can design the report. If you are not going to have users directly hitting the report server web page this is the way I would go as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Yay!
Jack you are a complete and utter star!
Thank you so much
*Lil Ms has to restrain herself from jumping around excitedly* :hehe:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply