Hi All,
Here i am describing an example of SSRS.
Before procceding your system must be installed with all this
1). Microsoft Sql Server 2005 Reporting Services
2). Microsoft Sql Server 2005
3). Microsoft Sql Server 2005 Business Intelligence Development Studio
Open Business Intelligence Development Studio, you will find this with Sql Server 2005, and create a new project with ReportingServicesExample
In the Project Types list, click Business Intelligence Projects.
now right click on the Solution Explorer, Add >Add New Item
In AddNewItem click on report and assign a name Order.rdl
Now what you will see is, there is a design as Order.rdl[Design]
select from dropdownlist of DataSet
now assign ConnectionString to Data Source and click OK.
i.e. Data Source=192.168.0.0;Initial Catalog=test_kapil
now you will find that there are few controls will be enabled
So what you have to do is:
write down the Query under the Data Tab and test by clicking run, if the result is as per your requirement. click the LAYOUT Tab.
Add a table, by selecting from the tools, to LAYOUT Tab.You can modify the table as per your requiremnt.
now you will find a DATASETS menu under TOOLBOX on left side.
you will find all the fields name there that you were fetching by writing an query under DATA Tab.
Report DataSets>test_kapil>field1,field2 etc etc
now drag fields to the LAYOUT Tab.
by default they will be shown as =Fields!CustName.Value
they contains the value from our query
save all and click on Preview Page
Here are the reports.
If you find me wrong somewhere, please feel free to correct me.
Thanks!!!
Happy coding.
|
| Author: hairat 28 May 2008 | Member Level: Bronze Points : 2 |
thanks!!! its really working...
|
| Author: RajaSekaran R 03 Jun 2008 | Member Level: Gold Points : 1 |
Hi, I am new to this Reporting services. can u be little bit clear, with those file names.. Thnaks.
|
| Author: Kapil Dhawan 03 Jun 2008 | Member Level: Gold Points : 0 |
Hi,
which file names you are talking about
|
| Author: RajaSekaran R 03 Jun 2008 | Member Level: Gold Points : 2 |
About which option has to be choosen while creating the new project(since their are so many options i am finding their.) also more clear abt db connections will be helpfull..
|
| Author: Kapil Dhawan 03 Jun 2008 | Member Level: Gold Points : 1 |
Hello,
each and every step is written here.
please follow above steps
you will get the way.
|