Skip to main content
Share Your Experience: Take the 2024 Developer Survey
6 votes

Pass a parameter from SSRS to MySQL

If you are using a MySQL ODBC connector in SSRS you can't use named parameters but you should use ? instead. So for your query it should look like: SELECT DISTINCT CompanyId, Company FROM ...
Tom V's user avatar
  • 15.7k
5 votes
Accepted

Multi values for SSRS parameter with Like statement

You would need to change your query in an expression and concatenate the condition using the JOIN expression on your parameter values. For instance, if you create a report based on the Adventureworks ...
Tom V's user avatar
  • 15.7k
5 votes

SSRS is missing after failover to other node

Reporting services is not cluster-aware. If you want high-availability you need to set up a scale-out deployment where multiple Report servers share the same back-end database. From the documentation:...
Tom V's user avatar
  • 15.7k
3 votes

Migration from SSRS 2012 to SSRS 2017

I too am in the midst of similar SSRS migration (2008SSRS:2016SSRS). Yes, the reports will need to be downloaded from one server and moved to the other. Also you will likely need to migrate other ...
SherlockSpreadsheets's user avatar
3 votes

Migration from SSRS 2012 to SSRS 2017

Here's the process I use to migrate to a new report server. This is assuming you are not already using source control and you don't have a Visual Studio solution for your reports. If you do, skip to #...
aduguid's user avatar
  • 281
3 votes
Accepted

Why is this SSRS Report rounding a BIGINT Value to the nearest Thousandth when exporting to Excel?

OHHH Man I completely misread your initial question. This is 100% an excel issue. You NEED to convert that value to text/string before you export it to Excel. You will get the same exact issue if ...
SQLDevDBA's user avatar
  • 2,244
3 votes

Why is this SSRS Report rounding a BIGINT Value to the nearest Thousandth when exporting to Excel?

Like MguerraTorres suggests, SSRS has probably got confused somewhere, and the value suggests it's getting cast to some kind of floating point datatype somewhere along the line. Try checking the ...
Jerb's user avatar
  • 606
1 vote

Convert SID string to varbinary(85)

Try the undocumented SID_BINARY built in function SELECT SID_BINARY('S-1-5-21-39949945-591092532-1226208319-1007'); --Results in: 0x01050000000000051500000079966102345B3B233F741649EF030000
st100's user avatar
  • 344
1 vote
Accepted

SSRS breadcrum just breaks into multiple lines

AFter days of scratching my head and google finally fixed with a vey simple setting. This was resolved by adding the url to the Compatibility View Settings in the IE browser settings.
Ramakant Dadhichi's user avatar
1 vote
Accepted

SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data

I have managed to resolve this issue, thought i'll be helpful for others. The order needs to be on the main tablix and not on the inner group or Matrix.
Vinayak's user avatar
  • 21
1 vote
Accepted

Can I rename the View Report button in SSRS

Nope. That button can't be edited. Up until SSRS 2016, the amount of customization possible in SSRS outside of the report canvas was close to zero. With 2016, there have been some improvements, but ...
AMtwo's user avatar
  • 16.2k
1 vote
Accepted

SSRS minimal permission to download reports

At the end, just so that I don't need to download the reports for them to edit, I have granted a very selective AD group with the contents manager permission, so that they can do their work. any ...
Marcello Miorelli's user avatar
1 vote

SSRS --> .xlsx file --> SQL ETL -- "External table not in expected format" error, but only when files have not been opened

Here are the possible reasons and solutions I can think of: The Excel file instance may be getting opened in protected mode. Opening, saving, and closing them is solving this issue temporarily. To ...
Shivam Kumar's user avatar
1 vote

SQL Server 2012 SSRS: Creating a report using global temporary tables

I have been there trust me, to resolve this issue try modifying accordingly and then add this code in applicable places in your Stored Procedures: BEGIN IF(1=0) Begin SET FMTONLY OFF END EXEC(@...
Shivam Kumar's user avatar
1 vote

Querying the Username in a Share Data source (SSRS)

After doing some digging, I doubt you'll be able to find an unencrypted list anywhere. It's storing it in the report server, so the SSRS engine is encrypting it on it's own; i.e it's generating a key ...
Haris Khan's user avatar
1 vote

SSRS 2012 Report with Oracle database as datasource never finishes

I would recommend the following: 1) Run the report and check Oracle's session (v$session) view to see if the Oracle database even registered the connection and the query was passed to it. a) if YES,...
codedawg82's user avatar
1 vote

Grouping and Row limit in SSRS

As you said you want to do this at report level here is what i can think of: You can try reducing the value in Height section in Interacivesize property of your report according to your needs,which is ...
Shivam Kumar's user avatar
1 vote

SSRS Lookup #Error on some rows

If I had to guess I'd say that the datatype of transactionnotes does not match the datatype of code. I suggest trying ... =iif(Fields!itemid.Value = 100785, "Allocated to: " & lookup(...
MrGoodfix's user avatar
  • 111
1 vote

SSRS - ERROR NUMBER:7357 while passing multiple value parameters using comma delimited string to stored procedure

The problem here is the way the SSRS parameters returns the value : for example when you tried executing the bsp_GetServerDBRoles stored procedure(I have skipped the @Login parameter in demonstration ...
Shivam Kumar's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible