SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello:

In SQL Reporting Services (SSRS), the main report containing data from two subreports is displaying data accurately.

But, I'm curious as to why the data displayed upon generating the subreports "by themselves" is being pulled one day behind the data displayed on the main report.

Again, the data in the main report and pulled from the subreports is showing as accurate.  But, the subreports "by themselves" are one day behind.

What are some things to check, to determine why the timing in the main report is correct as compared to the subreports?

Thanks!

John
0
Starting with Angular 5
LVL 13
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

I have a table  with columns Billing Month, Price Category, System Part, Charge Type, FAMIS Expense Account, FAMIS Income Account,,Quantity,Rate.  I group the rows based on multiple columns.  I count the number of rows in each group and multiply times cost to get a new column, Amount.

My problem is I want a grand total of all the groups.  So in the bottom right of the table in the attached image is an expression which is where I want to put the grand total.  How do I do write the expression?
parts.jpg
0
How do I add a column group to a table that has a row group and details?
0
I need to change the formatting of 8 cells in a table in SSRS.  I want to set the number formatting.

How do I do this at one time?
0
Getting 'Metadata not available' when modifying existing reports and creating new reports - the reports will run and return data but cannot make any changes to the report. The Model.xml file is size 0 in the framework folder. Was able to get a model.xml file from a backup but not sure what to do with it so the .cpf recognizes it.

When I try to open the framework file .cpf it doesn't open it just flashes and closes immediately.
0
I had this question after viewing How do i modify specific ExtensionSettings details in the Subscriptions for SSRS.

Trying to add the value so when I query ssrs subscription information I do not get

@ReportName was executed at @ExecutionTime

but rather the actual report name and execution time

I got impression I could do without data driven subscription by updating xml parameter value but not sure how
0
I am trying to back up a reporting server using the following article:

https://docs.microsoft.com/en-us/sql/reporting-services/report-server/moving-the-report-server-databases-to-another-computer-ssrs-native-mode?view=sql-server-2017


I can back up the DB just fine but when I get to the command to back up the logs I get an error  "Backup LOG " cannot be performed because there is no current database backup.

Reading the article below, it makes it seem the COPY_ONLY command is causing me the issue. Is this the case? If I do not run the COPY_ONLY command, am I going to be missing anything important?

https://sqlbackupandftp.com/blog/backup-log-cannot-be-performed-because-there-is-no-current-database-backup
0
Hi all, when I was using SCCM Current Branch (1906) trying to create a report for the path it says "The Request failed with HTTP status 503: Service Unavailable"

When I go to System Status > Site Status it shows that Reporting Services Point is Critical. I run the logs and I get: Component SMS_SRS_REPORTING_POINT The report server service is not running on Reporting Service Point server "insert server name here" start the service.

When I type in Services in the windows search bar and look for SMS_SRS_REPORTING_POINT that service is not there at all.

This used to be working but the last time I needed a report and verified working was on June 10th, 2019.

I'm not sure what else to do. I've gone to the Report Server Configuration Manger. I verified the account credentials and they worked and connected. I made sure it can currently connect to our current report server database. And I'm still getting the 503 error.

Looking forward to any troubleshooting steps you're willing to offer!
0
Dear Experts
We are using CRM application which uses MYSQL database. we have customized the CRM application for our core process therefore the CRM modules marketing, sales and contacts and opportunities are not made use instead we have completely customized, the solution is deployed on premises.
Challenges: to build/develop certain reports which are very much essential for daily operations and monthly reports and analytics. At present we are taking csv dump from crm and preparing it manually by applying formulas,  this is time consuming and resource dependent and as reports are not ready made available therefore end users to depend on the technical resource to export the reports and bring it to the required format and then provided to the end users. We also require analytics from the CRM data.
We are planning to implement SQL Server Reporting Services (SSRS) and integrate with Power BI for analytics the data source will be CRM application either integrated OR excel as input to the SQL Server Reporting Services (SSRS) or Power BI.
Please suggest will this approach work for us.
0
Hello,
I have a problem exporting report to excel out of SSRS 2012.
Every cell with value 0 is showing in correct format in SSRS as 0.00 but after export to excel is showing 0.00000000000.
Also during opening exported file excel is showing error and display below message:
We found a problem with some content in 'Report Name". Do you want us to try to recover as much as we can ?....
Problematic field in SSRS is Calcualted field.
Please help.
thank you

henry
0
Python 3 Fundamentals
LVL 13
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Hi ,

i have ssrs report with many text boxes and each text box will have different size of text. My report is good when i view it in browser, no wrapping of text, can see complete text.
Problem is when i export to excel i can't see second line of text in the cell by default until unless i increase height of cell.

can some one help me how i can view complete text without wrapping or partially displaying? for some cells i tried increasing padding 2pt to 3pt. This is working fine for some cells but not for all. is there any setting or way so that all my text gets displayed properly?

Thanks in advance!
0
i have an ssrs report where people put in a service request number and then it generates the service request.  This is a 1 page document that they print out after the ssrs report renders.  I have a list of 100 service requests in an excel spreadsheet that lists service request numbers.  I need this report to print out 100 service requests in the order that the excel spreadsheet has listed instead of submitting the service request number 1 by 1.  Does anyone know the best way to accomplish this.
0
I have a column titled "TapeTech Tools Daily". This column is a currency and is summed. It is also group by a column called Region. There are three regions that splits the value of "TapeTech Tools Daily" 3 times. My issue is that I see the header "TapeTech Tools Daily" 3 times and not one. How do I only see the header once?

See the screen shots.

Screenshot1Screenshot2
0
I am running into a situation I can't figure out.  I have a date/time field that can be left blank.  In my report , I have formatted it to only display MM/dd/yyyy HH:mm and no seconds.  

I have created the following expression to account for blank/null values or print the unformatted date/time which works fine.

"=IIF(CSTR(Fields!endDate.Value) = ""," ",Fields!endDate.Value)"

However, since I only want the Date and Time of Hours/Minutes I updated the expression to show the following:

"  =IIF(CSTR(Fields!endDate.Value) = ""," ",Format(CDate(Fields!endDate.Value),"MM/dd/yyyy HH:mm"))  "

This works fine when there is a date/time enter but now throws a #Error when it's empty.

How do I get my expression to work with both empty and date values?
0
Hi , i have report with 5 filters in which some are dependent on other.
i have category filter which is dependent on project and type filter.
by default category filter will select all vaues.
suppose  if category filter has 5 values in drop down then if user agian selects parent filter project to some other value then this category filter is not refreshing in text box but it will display correct values in drop down.

but it needs to refresh values in category filter textbox as well. how can this be possible?
i checked google but it says this is because of invalidate of the parent param values and needs to create other dataset etc...not sure how to do this


or i have other option where category filter needs to display either blank/select value string so user can select values from drop down. but not sure how can this be implemented

can someone guide me on this please?
thanks in advance
0
We need to set up a SCCM report that shows all machines missing a hardware inventory. I had thought this would be a simple task but every query I can find is focused on age of inventory, not simply missing one.
0
When i click on "Find" in the reporting services configuration manager i get the error that is in the screenshot.  This is the correct machine name. Any clue what is going on?

reporting-services.PNG
0
Hi,

We have SQL Reporting Services 2016 and create SSRS reports, which are published to the report server. I have started to use Power BI Desktop (free), is it possible to upload the power bi reports to my SQL SSRS Server? Or do I have to pay subscription to do this? I am trying to share my BI Reports with my users...

Thanks, Greg
0
Hi all, in my execution log storage table format column is showing null value thoush it has been exported to pdf or csv
can anyone why that happens? it's coming only for certain times
sometimes it;s showing correct audit but sometime format column is showing null value
0
Fundamentals of JavaScript
LVL 13
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Hi, i am pretty new to SSRS reports
i have excel file with 54 spread sheets and i need to create single report by taking data from all the sheets.
first i tried to create a report with single sheet
select * from [shee1$]
when i tried to execute in query designer it's showing unable to  parse query '[
but when i preview report i can see the result

can someone help me on this
thanks in advance
0
I have two tablix in SSRS report.

One tablix is header contains department info and i want it repeated in all pages
second one is detail of each employee in this departement

How can i do this? any thoughts?
0
Hi Experts,

Here is my problem statement.
I have requirement to create report for more than  one customer.
each customer information has 5 sections and each section(Tablixes) is coming from different table. Each page has  customer name and customer id as the header.
These 5 sections can span more the one page. if it spans more than one page the header should be repeated in all the pages.

I have attached the sample layout here.  
SampleReport.docx
Please let me know if you need any more details here.

Any help on this is greatly appreciated.

Here are the different Solutions that tried but it couldn't accomplish fully.

Solution 1:
One Main Report and One Sub Report.  Sub report built  for one customer. In the sub report created 5 data sets and each data set for one Tablix. Since all the 5 data sets for one customer i was to able print the customer name and customer id in the header and In the Main Report calling sub report for each customer.
Issue:-  Sub Reports headers and footers are not visible in the main report.

Solution 2:
One Main Report and One Sub Report.  Sub report built  for one customer.  In the sub report created 5 data sets and each data set for one Tablix.  Each Tablix Header(static row property) repeat data header property to true and checked page break after Tablix property.  Now each tablix will be moved to a seperate page though  2 tablixes can fit in one page. which doesn't like by the business.
0
We get data from a client established SSRS.  Is there a way to set up a connection to SSRS in Access to pull that data in?
0
We have a report with multiple Tabs in it. So to reach  each tab, We have used Document Map.

As we did not want to see Document map tab in Excel so used  expression like this IIF(Globals!RenderFormat.Name="EXCELOPENXML", Nothing, "Test")  as per suggestion on the below link:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e6850044-78fb-4a13-8de4-f61388656835/exclude-document-map-in-the-excel-export-of-ssrs?forum=sqlreportingservices

But later we realized  that document map label stops working on Visual studio and Browser, once we export the report to excel .

As Per the code =IIF(Globals!RenderFormat.Name="EXCELOPENXML", Nothing, "Test") - Document map Label is Set to nothing post/During Export.

This issue we are facing in current Production Environment also.

Please advise.
0
Have SSRS report based on Teradata datasource with parameters.  Query runs in less than 1 second in Teradata but report extremely slow to render . This report has been in production for a year and has just started experiencing this issue.
0

SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.