May 9, 2007 at 8:08 am
Is it recommended to create Data Source in Reporting Manager or should we create Data Source in Report Designer?
If created in Reporting Manager, do we need to give "Connection String"? and what type of credentials should we use?
It is little confusing to me since when I create Data Source, Report, Folder they all appear in Reporting Manager web site then why do I need to create all these in Reporting Manager?
Please assist me understanding the concept.
Thanks,
Data Sheet
May 9, 2007 at 9:58 am
I would suggest creating shared data sources in visual studio for your report project. When deployed to a server I keep all my data sources in a folder called 'Data Sources' and point all the reports to use these data sources. If necessary you can create them there but if you set it up right in visual studio they should all be created when the reports are deployed. Using the shared data sources is key, I would not recommend custom data sources for anything that may need to change or be reused.
Cheers,
Ben
Ben Sullins
bensullins.com
Beer is my primary key...
May 10, 2007 at 2:25 pm
Hi ben,
If you create all the Data Sources in one folder, Do you create this folder on Operating System level or how you create it?
is it not like you have to create a Project first and then you can defind Data Source?
Please give me little more clue. It is helping me.
Data Sheet
May 10, 2007 at 4:57 pm
When you deploy a report to the report server visual studio by default creates a folder named 'Data Sources' in the report manager and puts any shared data sources in there. Later on when developing new projects you can use the same data sources by right clicking on the 'Data Sources' folder in visual studios solution explorer and choose 'Add Existing'. This will allow you to browse to your share data sources and add them w/o having to reconfigure the connection info.
Ben Sullins
bensullins.com
Beer is my primary key...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply