5

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 User_Hierarchy_Mapping WHERE UserId = ? That way you should get a parameter named Parameter1. If you have more than one question mark your ...


5

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: High availability in SQL Server Reporting Services A scale-out deployment provides a way to share a database. If one report server goes down, other ...


4

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 2014 database you could add a parameter like this: With some values that appear in the table: If you then enter an expression for your dataset instead of a ...


3

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 you try this experiment: Query the procedure via SSMS and display the results in a grid Copy the results and paste them directly into Excel. Noting this ...


3

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 datatype SSRS is assigning by looking at the xml in the .rdl file raw text. for a simple bigint column I'm seeing an SSRS field definition something like this: &...


3

Best is to use Reporting Services Scripter Reporting Services Scripter is a .NET Windows Forms application that enables the scripting and transfer of groups of SSRS catalog items from one server to another or from one SSRS folder to another on the same server. Reporting Services Scripter is flexible and lets you transfer catalog item properties, such as ...


3

Yes, you can have several Report Servers installed on a single SQL Server. As you noted, the multi-instance support on a single machine is available, but not what you are after. For multiple distinct ReportServers on different servers, but using a single database, you simply have to configure this in the Reporting Services Configuration Manager. As ...


3

If you are using the web interface to run and view the reports there is an option to set the zoom level by appending &rc:Zoom=Page Width or whatever percentage you want. Also it can be configured in the SSRS configuration file see MSDN for details.


2

@matt you might want to adjust the tablix or row KeepTogether property. This affects how it tries to have all rows/table on the same page.


2

If all the databases are on the same instance you could have a central database (named reports, admin or whatever you like). Your report could use that database for your reports datasource. You could then have a stored procedure that made use of dynamic SQL and a parameter to determine which client database the query should read from. So your report ...


2

This may be a simple matter of Internet Explorer not automatically detecting server2.newdomain.net as an "intranet" site. By default, IE will only do automatic Windows authentication in the intranet zone. To see if this is the case, you can add "server2.newdomain.net" to the list of trusted intranet sites. Open IE, and do this: Go to Tools, Internet ...


2

You cannot use an aggregate like CountRows() in a calculated field in your dataset. But you can use CountRows() as an expression in a textbox (alone or within a table) scoped to your dataset. Now that you have your dataset created, you can put a textbox on the report and populate it with the expression =CountRows("DataSet1"), and it will provide the correct ...


2

You could use a RS.exe script. This would allow you to create a script, a batch file and a set of .rdl files. Then you just call rs.exe with the script you created to upload the files to the report server. You can find an example here There is also a tool called rsscripter.exe created Jasper Smith, a SQL Server MVP. Apparently it is now included in ...


2

(I don't have an SSRS server handy at the moment to test/confirm this, so I'm going a bit off-the-cuff here, and might not be 100% spot-on) I've never had luck with using the ReportManager URLs when I want to pass in specific parameters. Try using the ReportServer URLs instead. BOL gives this example format for passing dates using the ReportServer URLs: ...


2

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 #4. If you have the database permissions, you can use the Microsoft guide Moving the Report Server Databases. 1. Backup deployed reports Remote to the current ...


2

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 SSRS content-- shared data sources, shared data sets, report subscriptions. Below are some tools and processes that have worked well. Tools: ReportSync is an ...


1

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.


1

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.


1

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 I believe that button is still not customizable.


1

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 as its too long): exec bsp_GetServerDBRoles @SERVER=N'my server' ,@DBS=N'UK15AUTMProduct,UK15SUMMProduct,UK15SUMSProduct,UK15WINPProduct' The expected ...


1

Solutions that provide HA will serve you well - both a failover cluster instance or AOAG. Technet articles are great to help you with this and understand it deeper. For instance, if you use a FCI (SQL Server failover cluster instance), while installing you provide a network name which identifies the instance. Your SSRS only needs to know this networkname\...


1

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 better alternative please post an answer or comment, I will review the situation accordingly.


1

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 fix it permanently, you need to add the Excel file location as a trusted one in the Trust Center. To do this, you need to go to excel>>file>>options&...


1

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(@YourDynamicSqlhere) Select * from ##YourTempTable drop table ##YourTempTable END


1

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 and salt in the engine code and using it to encrypt\decrypt those columns. You won't be able to query it via T-SQL, but you might have better luck using ...


1

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, then check your report server's timeout settings. If the initial data return is elapsing the timeout period in either your report or your RS config file, this ...


1

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 set to 11in by default and shows whatever records can fit in that much space : Note: In case you have a small database and want to show all the values in 1 ...


1

I was able to add the data set by putting it into the XML manually, the GUI refused to save the change.


1

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(cint(Fields!transactionnotes.Value), cint(fields!code.value), fields!fname.value, "EmployeeInfo") & " " & lookup(cint(Fields!transactionnotes....


1

After some more research I realised that what I wanted was data regions. I'm now using different lists and tablixes to bind to the different datasets.


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