Post reply

Adding a new report - Setting Connection String

  • February 15, 2007 at 10:07 am

    #369463

    OK, this is probably a really n00b question, but here goes:

    I have an installation of SQL Server 2005, including reporting services and BI Development Studio installed and running locally. I have created a new project, added two .rdl files that were emailed to me, and created a shared data source. However, whenever I try to preview the report or even view the data sources I get the following error:

    A connection cannot be made to the database.

    Set and test the connection string.

     

    How do I set the connection string? I've tested that the shared data source is working fine.

    What is best practice for importing reports developed elsewhere?

    Thanks.

  • February 15, 2007 at 10:27 pm

    #690123

    Hi

    Have you tried opening the Reports in VS and running them. If they do run redeloy them this should sort out your problem....If not try creating a simple report a test to see if you delpoy this report that it runs.

     

    Mike

  • February 16, 2007 at 7:42 am

    #690220

    Thanks for your suggestion, Mike.

    I am trying to preview the report in VisualStudio. I am able to see the layout tab, I can see the Datasets, however, like the Preview tab these also trigger the above error message.

    As an ancilliary question, what steps should one go through when adding a report developed elsewhere?

    I did the following:

    1. Create project.
    2. Copy .rdl files to project directory.
    3. In VS, right-click to add reports.
    4. In VS, right-click to create shared data source.

    I think that I'm missing setting the association between the datasets in the .rdl files and the shared data source?

     

    Thanks.

  • February 16, 2007 at 10:22 am

    #690279

    The solution is to copy the name of your Data Source and the DataSourceID from the data source file (.rds) to the <DataSource Name="????"> and the <rd:'DataSourceID> tags in your report definition file (.rdl).

    I added the ' in the <rd:'DataSourceID> tag to stop the damn smileys.

    Phew.

  • February 17, 2007 at 7:15 pm

    #690364

    Hey Matt,

    Sorry to come in so late on thsi but couldn't you achiueve the same thing by simply editing (it's a drop down isn't it?) the Data Source for each of the DataSets when in design mode?

    Steve.

  • February 19, 2007 at 2:21 am

    #690402

    And where were you when I needed you last week!

    Thanks Steve, you are right. Clicking the ... button between the dataset selection dropdown and the delete dataset button allows you to do this.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply