Using the SQL Server 2000 Reporting Services
Pages: 1, 2
Deploying the Report
Before you deploy your report for the first time, you need to configure the target server for hosting your report. In Solution Explorer, right-click on the Project name and select Properties. In the TargetServerURL field, specify the location of your Report Manager, which is by default http://localhost/ReportServer (see Figure 12).
Figure 12. Specifying the server to deploy your report
To deploy the report, press F5. In your web browser, you will see the list of reports published by the current project (see Figure 13). Here, there are three reports (the first two were created prior to this current report): Report1, Report2, and TitlesReport. To view the new report, click TitlesReport.
Figure 13. The deployed reports
You should now be able to view the report (see Figure 14). Click on the + sign to expand the list of books under a particular type.
|
|
What's cool about the SQL Server 2000 Reporting Services is that you can also export the report to various file formats. My personal favorite is the PDF option (see Figure 15).
Figure 15. Exporting the report to other file formats
Summary
In this article, I have briefly shown you the steps to create a report using the SQL Server 2000 Reporting Services. Using the wizard, you can create a new report quickly and easily without much effort. While this is useful for beginners, you should really explore the other features of the Report Designer to customize the format of your report as you become familiar with how the Report Designer works.
In the next article, I will discuss how you can integrate reports into your .NET applications.
Wei-Meng Lee (Microsoft MVP) http://weimenglee.blogspot.com is a technologist and founder of Developer Learning Solutions http://www.developerlearningsolutions.com, a technology company specializing in hands-on training on the latest Microsoft technologies.
Return to ONDotnet.com.
You must be logged in to the O'Reilly Network to post a talkback.
Showing messages 1 through 13 of 13.
-
2005 SQL Server Reporting Services - Excel export
2009-01-13 23:41:24 P L [Reply | View]
When we export an Excel file from 2005 Reporting Service tool, those datestamp fields cannot be exported directly into a specific format "dd/mm/yyyy" for further manipulation by the Excel users. We cannot find the way out and only tail-made to export as string field "dd/mm/yyyy" and then manually convert using Excel formula. Is there any direct way to export into the specified date format without intervention on the Excel worksheet? Please help.
-
SSRS - Excel exporting
2007-07-05 05:25:30 SivaP [Reply | View]
When we export an Excel file from Reporting Service 2005 Report , all the formatted fields like "$100,00" , "$2" are getting exported as Text field in the Excel , so Iam not able to use any Math functions to manipulate the data..
is there any way that If I export to excel the data can be exported as numeric field or a field that can be manipulated ?.
Please respond.
-
exporting to excel Prescaled
2005-10-06 05:56:55 samdotnet [Reply | View]
when i to export report from report manager to excel and then take a print out i get my cols on 2 different page...for example i have 10 cols in my report what i get is only 7..other three come on next page..i have manual way to do it ..in
print preview ..
setup..
page--tab
scaling section...here there r 2 radio button 1.Adjust to 2.Fit..
by default 1 is selected..
when 2 selected it takes 1 pages wide by 1..even this doesnot work..setting this to 1 pages wid by 7 up to 99...work well and i get all my cols with visible values...
please help its urgent..thanks and regards
sanjay
-
Trying to export large report to excel.
2005-09-27 08:56:09 tcoggins [Reply | View]
I have a large report about 30,500 rows of data. When I try to export to excel it hangs the server up. If I use comma delimeted I have no problems. Any ideas?
-
Language Determination
2005-09-23 10:53:11 TJWARD [Reply | View]
How would I know which .NET language is being used?
-
Language Determination
2006-01-18 10:00:54 Drutch [Reply | View]
Not sure what you mean here..language for "..."? If you'll notice click on the Class View in VS.NET there are no classes...no classes no code. The report is generated from XML which you can view by right clicking a report in Solution Explorer and choosing View Code. Though editing the XML directly wouldbn't be advisable unless your familiar with XML, and unnecessary for most cases.
-
Dynamically Remove Rows In Report
2005-09-23 10:50:56 TJWARD [Reply | View]
How can remove a row from my report if the results is empty or a null? -
Dynamically Remove Rows In Report
2006-01-18 09:49:22 Drutch [Reply | View]
Include in your query"SELECT * FROM [TableName]WHERE [ColumnName] IS NOT NULL AND [ColumnName] <> ' '". I'm not sure if Reporting Services has a Filter option to get the same results, but if you filter your query the dataset used in the report will not contain those values.
-
Mailing List and Formula Fields
2005-09-23 10:47:42 TJWARD [Reply | View]
How do I create a mailing list (3 columns) in Reporting Services Layout?
Which control should I use? (ie. table, list...)
Example Layout:
12345 48548 857455
South Washington Street Harrison Blvd NBA North Avenue
Yoyo, IL 65859 Washington, DC 58485 Shreveport, Tx 74854
Also, how or where would I go within Visual Studio for SRS to create Crystal Report like formula fields to be added into the report?
EXAMPLE:
if {Addresses.ADDR_State} = ""
then
{Addresses.ADDR_City} + " " + {Addresses.ADDR_Zip}
else
{Addresses.ADDR_City} +", " + {Addresses.ADDR_State} +" " + {Addresses.ADDR_Zip}
Thank you.
-
Seperate Reporting Server
2004-12-30 12:22:45 jeff@digitalfoundry.com [Reply | View]
When I spoke w/ a Microsoft rep I was informed that you need a second full SQL Server licence to deploy the reporting services to a seperate server from your SQL server. This was do to the fact that they are not licensing the reporting services seperately from SQL. Has anyone heard anything different? I would like to recommend this technology to a client, however I am not likely to convinse them to buy another SQL Server licenes just for reporting.
