How to create a SSRS server Report [Resolved]

Posted by Sksamantaray under Sql Server on 3/22/2012 | Points: 10 | Views : 922 | Status : [Member] | Replies : 8
Can someone guide me to create as SSRS Server Report.

Thanks,
Sanjay



Responses

Posted by: Patnaik.Jyoti on: 3/24/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi,
Now follow this link to create a SSRS Server Report.
http://www.dotnetfunda.com/articles/article1231-sql-server-reporting-services-ssrs-part-1-basics-on-how-to-create-a-re.aspx

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/24/2012 [Member] Silver | Points: 25

Up
0
Down

Resolved
Hi,
Very nice,
Its working fine.

Thanks,
Sanjay

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
First Check if Sql server Reporting Services are installed in your machine or not.
If Intalled check it is started or not?
Then let me know.

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/24/2012 [Member] Silver | Points: 25

Up
0
Down
Hi,
Thanks, But where to check the service is started.
Can you let me know .

Thanks,
Sanjay

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
Start --All Programs-- Microsoft Sql Server 2008 (R2)--configuration Tool--Reporting Services Configuration Manager

You get a Dialogbox--- Click connect.

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/24/2012 [Member] Silver | Points: 25

Up
0
Down
What to do next?
How to create sever Report?Where to start?

Thanks,
Sanjay

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 3/24/2012 [Member] Silver | Points: 25

Up
0
Down
Hi Jyoti,
Thanks,I could manage to create a report using the link you send, its really helpful.
one more question can i show country and city in 1 column like Germany-Berlin ?

Thanks,
Sanjay

Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patnaik.Jyoti on: 3/24/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,
Remove City column.
Right click on Country Cell go to Expression
Then in the dialog box type
=Fields!Country.Value + " - " + Fields!City.Value
Done.
Run the Report.


Sksamantaray, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response