Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompting Username/Password - more than one datasource..

Status
Not open for further replies.
NoCoolHandle

NoCoolHandle

Programmer
Apr 10, 2003
2,321
US
Ok..
Scenario. All access to SQL server is done via SQL username/password pairs. (not my design)

In some cases the report has more than one datasource
(different databases) that has ment that 2 datasource objects are being used. Due to the connection this ends up with 2 username/password boxs showing up on the report.

Is there anyway to have only 1 set of username/password box's on the report?

TIA

Rob
 
Status
Not open for further replies.

Similar threads

tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
677
tarikqazza
tarikqazza
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
639
Ashajohn2021
Ashajohn2021
DamienTaylor2021
  • Locked
  • Question
SSRS - Datasource - Update Credentials from Powershell or .rds file
Replies
0
Views
743
DamienTaylor2021
DamienTaylor2021
aa888817
  • Locked
  • Question
One filter from multiple columns SSRS
Replies
0
Views
210
aa888817
aa888817
sardine53
  • Locked
  • Question
Combining Multiple Rows into One Row
Replies
0
Views
234
sardine53
sardine53

Part and Inventory Search

Sponsor

Back
Top