before going to problem let me clear that i know there are similar questions ask before but could not find the answer of my problem. my problem is:
I want to select the Data Source at runtime. First of all, i simply create a report by making a shared data source. then i create a data set using this data source. I run the report and it is working perfectly. Then I create two parameters, one for data source and one for data set. both parameters are type of "Text", their parameter visibility is "Visible" and their Available and Default values are "None". Then I created a second data source which is embedded and its connection string is :
="Data Source=" & Parameters!DataSource.Value & ";Initial Catalog=" & Parameters!DataSet.Value
Now when I click on test connection button it shows me error :
"The ConnectionString property has not been initialized."
Now can any one please explain me how to handle it. my credentials are correct. I test credentials by making embedded data source and hard codded connection string its working fine but not with dynamic connection string.
How to select the Data Source at Runtime in SSRS Report Builder
2.9k Views Asked by Hamza At
1
There are 1 best solutions below
Related Questions in REPORTING-SERVICES
- Pass multiple account variables to single parameter
- Update SSRS security for reports
- SSRS Report Expression, for 2 fields in one column
- How to assign dataset values in RDLC report header?
- SSRS Multi-Value Parameter Not Filtering
- Toggle groups based on a parameter
- How to build rptproj using C#
- Don't produce report if there is no data - PDF
- SSRS ListRenderingExtension Unauthorised Exception
- SSRS Color Expression Lesser than X
- Format Numbers in Multiple columns of SSRS Report
- Create Sum of calculated columns in Microsoft Reporting Services like Fibonacci series
- SSRS parameter Datatypes
- creating many reports from a single template - what is this called?
- SSRS Add Parent Group to Entire Tablix
Related Questions in REPORT
- Update SSRS security for reports
- parameter passing while generating report in ASP.NET
- Don't produce report if there is no data - PDF
- mysql -how can we store Testng results to database
- How can I hide a standard report from the print button pull down menu list on Odoo 8?
- SSRS 2012 - Hide Duplicate Rows
- INST-07407: Unable to detect machine platform or JVM bits while installing oracle forms and reports
- Writing doc output to pdf
- SQL Datename within a function
- Write a docx and password protect it
- Export Moodle report in csv file
- Using SQL Can I get incremental changes in data from query results? Loops?
- Conditional Formatting via VBA MS Access Report not working
- Insert a plot inside a paragraph
- STM32 USB HID reports
Related Questions in REPORTING
- Pivot Table with multiple rows all having the same level hierarchy
- creating many reports from a single template - what is this called?
- How to select the Data Source at Runtime in SSRS Report Builder
- How do I create a more filtered report in Version One, similar to an excel report?
- SSRS - Showing data's each character in box
- How to retrieve Install Statistics from the Google Developer's Console?
- Error handler for sum in ssrs
- Pentaho adhoc reporting functions
- How to retrieve my Install Statistics from the Google Developer's Console
- BIRT: Fit to whole page in report design?
- FastReport.Net. Registration of dataset
- In asp.net-mvc, what is the correct way to do expensive operations without impacting other users?
- How I can bind devexpress report table to list of strings?
- Generate PDF/html report and send report as mail in SonarQube 6.0
- SQL Group By in to separate result tables
Related Questions in SSRS-2012
- SSRS Multi-Value Parameter Not Filtering
- SSRS Add Parent Group to Entire Tablix
- SSRS 2012 - Hide Duplicate Rows
- how to migrate or copy SSRS datasource from one server to another without restoring the report server
- SSRS Tablix - Total with Top N
- Convert integer of MYYYY into Date in ssrs
- Tablix in Tablix - Header not repeating
- SSRS date & time parameter based on time of day
- SSRS: How to restore a deleted title in a chart
- If A Not Equal to B in SSRS
- Colour Formatting Based on Conditions
- How to select the Data Source at Runtime in SSRS Report Builder
- Use RunningValue in CRM Dashboard Chart?
- Trying to use Switch statement in SSRS
- SSRS - Showing data's each character in box
Related Questions in REPORTBUILDER
- Digital Metaphors Report Builder Surround Group Inside Box
- How to select the Data Source at Runtime in SSRS Report Builder
- SSRS Highlight Cells on Click
- SSRS Report Builder: Creating text color expression based on textbox value?
- Using ASP.NET Web API controller needs authorization, as the Data Source of SSRS Reports
- How to get the difference of dates or TAT in ssrs
- Oracle report layout issue
- Can't run SSRS ReportBuilder 1.0 from multiple sites
- add amount on tuesday as tuesday +monday
- SSRS Sub reports doesn't show it's own footer
- How do I make wildcards work in a like operator in SQL Server reporting services?
- coldfusion cfreport error when format is excel
- How do I set the report language in Report Builder 3.0?
- Using Reportbuilder for Delphi, is it possible to print landscape and portrait within the same report?
- How do you use cascading parameters in Report Builder 2.0 with a dynamic parameter value?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You can't use a Shared Data Source with a dynamic data source. Use an embedded one. I think it's to prevent you from corrupting other reports' data sources.
http://www.keepitsimpleandfast.com/2012/08/how-to-use-dynamic-data-sources-in-your.html