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 answers
Related Questions in REPORTING-SERVICES
- SSRS cannot aggregate a variable
- How to filter data in a report using Microsoft Report Builder based on Orders of Service (OS) dates?
- Check if a value is not in a list in SSRS
- SSRS Report Builder returns error when entering more than one value in a parameter filter
- SSRS - Do not want to round a percent
- SSRS report exporting as PPT file
- SSRS use a dynamic SQL query with parameter
- Error when trying to change subscription owner (SSRS, SQL Server 2016)
- Background Colour Conditional Formatting in PBI Report Builder
- do you know any free reporting services like devexpress or boldreports?
- Embedded SSRS permissions error using rsweb:ReportViewer
- SSRS - Visual Studio round issue
- How to Implement Multi-Parameter Queries in SSRS Report Builder with Databricks ODBC?
- I want to integrate Crystal reports or SSRS reports in react js
- Column Grouping in SSRS report Matrix
Related Questions in REPORT
- how to make certain editable field as non editable in alv report for custom field
- Report: Cased Actively Open during any given Month
- do you know any free reporting services like devexpress or boldreports?
- Cognos 11 Query join problems
- Allure report stuck with a loading spinner after launching index.html from generated report
- I need information about reports
- Azure PublishCodeCoverageResults@2 issue with detailed report for coverage
- how to create in webi a text input control based on partial text or number for filtering a BO Report
- unable to upload Paginated report
- 401 Unauthorized https://api.powerbi.com/v1.0/myorg/GenerateToken
- apexchart javascript grouped stacked bars sometimes not working
- Column Reorder in PBI - I Want to rearrange/sort the order of my data within the columns in my report
- How to update custom reports in Dynamics 365 Field services
- Email based on no entries
- IIS worker process memory keeps increasing with each new devexpress report beeing served
Related Questions in REPORTING
- Can you report real-time visitors to your website using Mixpanel
- Add a eps file or pdf file to my report - MATLAB Report Generator
- I want to generate PDF automation report in XUnit using selenium driver and .net in visual studio?
- do you know any free reporting services like devexpress or boldreports?
- error NU1101: Unable to find package Telerik.Drawing.Skia.Trial. No packages exist with this id in source(s)
- Customization to Last Week filter
- Showing Different Sub-Reports Depending on a User Driven Parameter
- ASP.NET session has expired or could not be found in webforms app inside an iframe
- Row in Power BI Table blank
- xcresults tool is not able to export screenshots for failure cases ( xcresults-1.17.1 )
- how to create a textbox in ssrs for user entry as a parameter and limit the Character input to 18
- How do I find out where this error is coming from?
- Unable to call a custom dll method in Microsoft SSRS
- How-to export NUnit Attributes in one file/report
- Will reports still be accessible once an App is removed from Sale from the Apple Store
Related Questions in SSRS-2012
- Calculate the count and put in the same matrix table
- Automatically deploy .rdl files to PowerBI
- Showing Different Sub-Reports Depending on a User Driven Parameter
- Expression outside of a tablix
- Justify and Bold text in SSRS - SQL Server Reporting Services
- Aligning Two Matrix Tables in SSRS Based on Matching Column Names
- SSRS Grouping on Join(LookupSet only returns one column
- how to create a textbox in ssrs for user entry as a parameter and limit the Character input to 18
- How can I present the posted on date parameter from credit adjustments across individual columns for each date, based on customer
- How to import shared data sources located on my report server to Visual Studio reporting services
- Unable to call a custom dll method in Microsoft SSRS
- SSRS: one or more parameters were not specified for the subreport located at
- SSRS MS Dynamic Fetch Query Limitation
- Group multiple parameter values into one
- SSRS Visual Studio1
Related Questions in REPORTBUILDER
- Visual Studios Report Builder - is there a way to add a condition to the PrintOnLastPage element (boolean) of a report Footer?
- SSRS Report Builder returns error when entering more than one value in a parameter filter
- Power BI Report Builder =Today() function in datetime parameter causing it to gray out
- Create "Bingo Card" in Report Builder
- Expand/collapse all Report Builder without using parameter
- Trying to get a sum in the footer of SSRS Report Builder
- How to clear recent files list in standalone Microsoft Report Builder app v. 15.0.20073.0 that has stale paths to deleted or moved files?
- Publish PowerBI Report Builder Reports to a SQL SSRS server
- SRSS/PowerBi Report Builder - Add Category Total to Bar Chart
- How to get dashboard usage statistics for Report Builder reports?
- Converting Bar chart to star/polar chart in report builder
- IN SSRS How to get Current week Thursday date
- How to format thousand separator for a number in MS Report Builder?
- Fix number of columns in Power BI Report Builder with TOP 10
- Show wanted string when get an specific value from Datasource - SRRS SQL Reporting Services Report Builder
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?
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)
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