I have created a drill down SSRS report where I have put text boxes and 5 sub reports and one as main report.For main report datasource I have selected "Display the following text to prompt user for a user name and password:" and have checked "Use as Windows credentials when connecting to the data source" box. But the problem is I have to login every time I click on each tab and go to next sub report. Please let me know if anyone has a solution.
SSRS Drill down report not using same credentials as parent report
185 Views Asked by Malik Kattubadi At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- SQL server not returning all rows
- Big data with spatial queries/indexing
- Conditional null constraint on Null
- SQL Query - Order by String (which contains number and chars)
- Optimising a slow running SQL Server Stored procedure ordered by calculated fields to return a closest match
- Dynamics CRM Publishing Customizations - Multi Developers
- Is there anyway to set the relationship of many tables from Model?
- Implementation of Rank and Dense Rank in MySQL
- ORM Code First versa Database First in Production
- MVC : Insert data to two tables
- Data streams in case of Merge
- table with multiple IDs but seperate notes need sorting (Tried SQL code to make a union query)
- SQL table Partitioning by Year with ColumnStore index implemented on the table
- Defining which network to use for SQL Server 2012 Management Studio
- Fill a week days in a table with preceding Sundays value
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 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 DRILLDOWN
- Drilldown for lines in Highcharts
- On highcharts drilldown, how to know which column that have been clicked
- Angular-Chart drilldown options in doughnut chart
- highcharts: use JSON in drilldown
- Repeat header for each drilldown row in ssrs
- How to drill down a report from a RDLC by clicking any where in the row
- Not able to export Highchart.js after Drill Down
- Hide columns in SSRS drill-down Report
- Show UITabBar when UIViewController pushed
- Java, drilldown an ArrayList of HashMaps
- Is it possile to create drill down option in Crystal reports?
- How to get the number of records for a Crystal Reports drill down section?
- Is there a way to custom sort records in a Google Data Studio table?
- My variable keeps losing its value
- How to update an array with data that matches another array's data
Related Questions in DRILLTHROUGH
- drilling from powerbi to ssrs
- how to rename drill-through columns in icCube?
- Drill through facts attributs
- How to Disable the double click option for DrillThrough Action in SSAS Cube
- Power BI Drill Through Small Multiples
- Birt graph drill through on date range
- Displaying Fields in a Drill Through Table Dynamically
- Power BI Drill Through on multiple rows
- Power BI - Understanding Filters in Drill Through from Table
- DRILLTHROUGH not returning Dimension Keys
- Microsoft Power BI drillthrough from one table report to another (each uses different datasets)
- How to have Drill Through Filters carry through buttons in PowerBI
- Linking to Another Report in Report Builder
- SSRS - Passing parameter to run stored procedure
- How to SSRS DrillThrough with multiple rows & multiple parameter
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?
According to MSDN, you need to make sure the datasource name is exactly the same for all subreports. Then it will only prompt for the main report.