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

I am using SSRS 2012 to create a report with parameters. There are two parameters for  begin and end dates and two parameters to allow the user to add notes to the report. I am having a problem when the notes to be added contain carriage returns or special characters. The parameter ignores everything after a carriage return and doesn't seem to like other formatting like a asterisk(*) (example a comment has *Note: This indicates data highlighted in the report). I took the carriage return out and it still cut off right before the asterisk. Once I removed the asterisk, it displayed everything. Is there a way to allow a user to enter into the parameter carriage returns and special characters? If I can't use a parameter, is there another way that I can allow a user to type in(or cut a paste) comments?
0
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

My SSRS 2016 report is not displaying data.  The stored procedure run in management studio returns data.  When I run the report in the Query Designer within SSRS it returns data but nothing is displayed.  What could be causing this
0
Have aa SSRS report which has a table near the top with case information.  In SSRS, this table is formatted to be 7.5" wide, and displays like:
SSRS formatBut when my users export this report to Word, that same section of the report is shrunk (horizontally) so that it displays in about 5.25" and looks like:
Word outputWhile the rest of the tables all retain their 7.5" width and the proper appearance.

Although this table is editable in Word, and the client can widen columns to get it to fit appropriately, they would prefer to focus on content, not layout (my job).

Any ideas what is causing this and how to fix it?
0
I have a SSRS report.  There are certain pages within the report that need to be printed twice (the user needs an extra copy of that page).  Is there anyway I can programatically do this within ssrs instead of trying to duplicate records in a stored procedure temp table.  I call a stored procedure when I run this report.
0
I'm running Power Bi Reporting Service 2018 Version 1.2.6648.38132

The problem I am running into is when running scheduled subscriptions, only 1 subscription can be run at a time.

When starting the subscription manually through the SQL Agent (while the other one is running), the status of the subscription goes directly to: The report server has encountered a configuration error.

I notice that the SQL Agent is starting the job, but it does not seem to trigger the Reporting Service to run the subscription. (Image attached)

Do you have any suggestions?



See the error message in the attached file.
ssrs---schedules.jpg
SQL-Agent-vs-SSRS-Job.jpg
0
Parameter configuration in ssrs.    The dataset is configured with a normal query joining two tables.  At the end of the dataset is where i have a question.  it includes a where and "and" statement

Currently it is configured like this

Where a.rescode = ''
and a.adddttm > @conversion      -  This is a date field

How to i configure the variable to be one of the two choices instead of always Greater than  (user supplied date)


Where a.rescode = ''
and A.adddttm > @conversion

or

Where a.rescode = ''
and a.adddttm < @conversion
0
Dears,

1. can we generate 1 report from different data sources (MS SQL and Oracle)?

2. Should we propose separate HWs for reporting for better performance if many DB's are being fetched?

3. Does SSRS SW require any license ?
0
Hi,

I have a sales report based on 3 levels: area, region, sales rep and I implemented a sorting for sales.
The sorting works well on the basic level (sales rep), but does not work on the other 2, i.e. when I hide the sales rep.-details and want to sort on regions, SSRS opens the sales rep-details again and sorts on sales rep details.

Any suggestions how to fix the issue in such way the SSRS can sort based on the level which is shown?

Thanks.
0
Hi,

I have a table with sales data from 3 levels (Area, region, sales rep.). The default setting should be that the sales numbers are shown aggregated per Area (row visibility of "region": "hidden" - can be toggled by clicking on the plus in the "Area"-field).  "Sales rep." - details are visible by clicking on the plus in the "region"-field. To sum it up: "Sales rep" depends on "region" which depends on "Area".

My problem: When i chose the "Area" in to show in the parameter, the SSRS-report shows me "Area" + "Sales rep". When I click on the plus in "Area", "Region" is shown and "Sales rep" is hiding.

How I want it: 1. Chose "Area" (show only aggregated numbers from the area --> "Region" and "Sales rep" hidden)
 2. Chose "Region" (show "area" + "region", hide "sales rep")
3. Click on plus of "Region" --> show all the detailed sales data per "sales rep".

Please find the setup attached.
0
Created an SSRS 2014 report by joining 2 table ,related by CS_ID filtered by year . Notes column is in 2nd table and for each year it is unique . I am able to display data in a tablix. Issue I am facing is ,when some of the rows  are having notes (value of which is same for all rows). How to display that note on  bottom of a report on  a textbox  ? Currently I use another dataset to do this .  I want to do away with this. But I feel there is  way to set a report variable on expression of a column ( I use status column) of the row which has that  note column value. SetValue() does not seem to work . Ensured that report variable is not ready only.
0
Cloud Class® Course: Python 3 Fundamentals
LVL 12
Cloud Class® Course: 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,

how can I declare a Textbox or render it accessible in relation to the error-message below?

"Textbox313' is not declared. It may be inaccessible due to its protection level."

Thanks
0
Hi,

how is it possible to set more than 1 filter in SSRS, such that the values in the 2nd filters are shown according to the choice lade in the 1st filter?
In my example (see attachment), I have a sales area divided into regions. I would like to appear only the regions which are presented in the sales area chosen in the 1st filter
0
SSRS Report Builder - Export to CSV issue; Double Quotes exist for each record.

We have a report that is scheduled to produce a CSV file.
This file is consumed by another application and requires specific formatting in order to successfully process the file.
The following entry has been configured within the 'rsreportserver.config' file:

<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                        <OverrideNames>
                              <Name Language="en-AU"> CSV No Header</Name>
                        </OverrideNames>
                        <Configuration>
                              <DeviceInfo>
                                    <NoHeader>true</NoHeader>
                                    <Extension>CSV</Extension>
                                    <Encoding>UTF-8</Encoding>
                                    <Qualifier></Qualifier>
                              </DeviceInfo>
                        </Configuration>
                  </Extension>

The file that is being generated from this contains double quotes at the start and end of each record (see below).
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
"DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY"
"180603,06/06/2018,AB,123,A,AB,123456789,-1234.56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TEAMJNL,123"

The output we need is shown below:
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY
0
Hi Experts,

We have some users that are Unable to run SSRS Reports. When they try to open any Microsoft SSRS report (From any computer) they get an error message that’s says: 'The remote server returned an error: (400) Bad Request'

I will attach a screenshot of the error message. The issue is not report specific or users specific and the issues doesn’t appear to be related to permissions as for example a user with the same permissions can open reports without an issue where’s another user with the same permissions hits the error message.

The SSRS is running on Windows Server 2012 R2SSRS report error

Any suggestions on what could be causing this issue and how to resolve?
Thanks
0
Hi,

I would like a customized (manual) sorting in my SSRS-columns. I.e. I want to show first the results of "Sales", then "Production", then "Logistics", then "Purchase".

How can I do it?

Many thanks!

Daniel
0
Hi,

I am working on a SSRS 2012 report and I need your help with this problem

The report has two parameters:
 1) @Search is a text type param and has two specific values
                                                              - "WorkerId"
                                                              - "DepartmentId"
2) @ActCodeFilter is also a text type param and only 1 default value
                                                              - "%"
When report is executed the first param gets "workerid" as the default value and
the second parameter get "%" as the default value.

My requirement is when I change the value of first parameter to "DepartmentId" the second parameter value should become Blank i.e the text box should become empty.

Thanks for your help.
0
Hi,

While deploying SSRS report , it asked for credential but somehow those were not correct. Now I am trying to deploy report again. It is not asking for credential.
It is saying "Permission granted to user ....  are insufficient for performing this operation". Please suggest how to get crendential asking popup again.

Regards,
Hari
0
I have created a query/agent job and I want to turn it into a ssrs report where the user can select parameters from drop down menus.

My question is, what tool should I choose to create my first report of this kind?  It seems like all 3 below will work, (different means to the same end) I just want to pick a good one as a starter.

1) Native tools on report server url?
2) SSDT?
3)1.BIDS ( Business Intelligence Development Studio 2010)>
0
Hi,

is it possible to publish a report created in "SSRS Report Builder" with the publisher for mobile reports? How?

BR
Daniel
0
Cloud Class® Course: Ruby Fundamentals
LVL 12
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

I have column chart with 2 categories in RDLC report.  Is it possible to make X-axis looks like the first chart instead of 2nd chart?  The 2nd chart is a standard multiple category column chart with line segment.

chart 1  Chart 1
chart 2  Chart 2
0
Window Server: 2016
DB server: SQL 2014

IIS Server hosting website.
IIS website uses windows authentication

Report server and Database is on 1 server
Service account: built in reportserver account
Current Report server Database credential:  net service\Reportserver

When going straight to SSRS, i get prompt for login credential, once in i can generate any report that I want. However if i run the same report via the web site. I get the following error

 WebException: The remote server returned an error: (401) Unauthorized.]
   System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request) +365
   System.Net.WebClient.DownloadData(Uri address) +111
   Events.Controllers.ReportController.Buyout(String param) +249
   lambda_method(Closure , ControllerBase , Object[] ) +139
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +280
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
   System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +33
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +80
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +385
   …
0
I have a web application that uses ssrs 2016 for reports.  I am looking at moving the sql database to a nosql database, but don't know how to maintain the reports I have created.  Any ideas?
0
I'm trying to write a expression in the fill to  get colors to appear in 2 different groups. If a person has been here more than a year I want there date to turn white if they have been here less than  year I want there date to turn Orange. When I run my expression I keep getting errors or no colors will show. Below is my Expression

=IIF(DateDiff(DateInterval.Month,Lookup(Fields!AgentID.Value, Fields!AgentID_FON.Value, Fields!BLStartDate.Value, "BLDate"),
Parameters!OverallStartDate.Value)>=12,"White", "Orange")
0
Hello experts,

in SSRS 2008 r2, I used to be able to create data-driven subscriptions. As a matter of fact I have quite a few reports with and without existing subscriptions that I can use data-driven subscriptions.
Now, after getting the failed error message, I decided to have a very simple query in the report.. something in the line of    select top 10 * from ACME.
And using a functional shared data-source.
here it comes.

When I upload this functional report to the server and getting to "manage/subscriptions" I cannot use the data-driven.
The error is :
data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using ser-defined parameter values, or if a linked report, the link is no longer valid.

> do not have parameters
> it is not a link
> using a good valid data-source that 100+ reports are running off of

Any ideas what can cause the server to act up like this?
0
I have a WPF MVVM application that I'm porting from a WINFORMS existing app. The reporting of the WINFORMS app uses both SSRS & CrystalReports for reporting.  Looking to convert these report in the MVVM pattern. I want to produce the reporting output on the server thru the Web Service and send back a link to the client ReportViewers. Does anyone know if possible and if so any examples?

Thanks
Chuck
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.