I am trying to write a sql statement to control a report header selection of multiple database by user groups a user is assigned to. This is to limit the database selection security when running an SSRS report so that they can’ only select their branch or group of branches they have access to. So far I …
Tag: reporting-services
SQL Query to get 2nd most recent results with multiple columns
I am trying to obtain the 2nd most recent results for all distinct part_id’s(based off of order_date) to go into a report I am working on making to compare it to the most recent results. The commented sections are from another approach I was trying but unsuccessful with. Any help is greatly appreciated!…
Why is the output for my datediff expression to return a number of days bracketed?
I have written the following expression to give me the number of days between a date and today. The output is correct but is bracketing the number ie. (292) instead of 292 Any help as to why this is Answer if you are using text box to display your result, check what is the type of your text box. Make
Significant delay in generation of View (Viewed Table) in SQL Server
I have a few Personnel Details tables in a database in SQL Server 2014. There is a view that pick up selected data from these tables by implementing a few joins. One condition to select the row is if its columnn isActive = 1 in NominalRoll table. There is a report in SQL Server Reporting Server that calls thi…
SSRS giving error as HResult E_FAIL has been returned from a call to a COM Component
When I run the SSRS report with data having 150 000 characters it gives error HResult E_FAIL has been returned from a call to a COM Component I am using the single textbox to display this data. For any other data it works fine. I have searched on some other forums and they say that you can only print 32
How to create SSRS report that use different aggregation algorithms on the same column? [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question I’d like to create a report that has columns like Year, Month, Earni…
SQL SSRS How to drill down State into top three cities. Do I do it in SQL or SSRS?
I am creating a simple report where I have a location (down to the city level) and some information about that city in regards to my customers. Here is what the table look like Now what I want to …
SSRS : How to make a data set field appear in the footer?
I have a simple report with a dataset( Patient id, programid, name, address, phone). In my report footer, I am trying to write a condition where the footer value shouldn’t show up for specific program …
How to retrieve current month in SSRS expression
I want to get current month as default value of a parameter. I’ve come up with (which does not work): Answer If you want to get the month as an int that goes from 1 to 12, you can use this This answer was based on the official documentation that you can see in here – http://technet.microsoft.com/e…
what is the difference between Coalesce and nullif
I am currently working on an SSRS report that will need to display a Dr’s ID based on either their DEA number or NPI number. I need to be able to do a coalesce on DEA and NPI to find the non-unknown one, which I will then add code to the SSRS report that will display a hover over stating