SSRS

8K

Solutions

26

Articles & Videos

5K

Contributors

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 upgrading a series of applications from SQL 2000 and VB.net 2003 to SQL2014 and Visual Studio VB 2013.

The code all upgrade automatically, but I have to upgrade the reports.  I was going along fine until I got to subreports.

When I try to pull data for the subreport I get the error:  Data retrieval failed for the subreport Subreport3 located at "path to report"  Please check the log files for more information.

I have done some research and found that I need to add subreport processing.  I have found and deployed some code like the following.

Public Sub SubreportProcessingEventHandler(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)

e.DataSources.Add(New ReportDataSource("AdventureWorksDataSet_Contact", Me.AdventureWorksDataSet.Contact))

End Sub

Private Sub <FormName>_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'
' Other code is here.
'
Dim instance As LocalReport = Me.ReportViewer1.LocalReport

Me.ContactTableAdapter.Fill(Me.AdventureWorksDataSet.Contact)

AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf Me.SubreportProcessingEventHandler
Me.ReportViewer1.RefreshReport()
'
' Other code is here.
'
End Sub

But when I change the e.DataSources.Add statement to reflect the values from my programs,  which results in    e.DataSources.Add(New ReportDataSource("DSPrtCommSheets", Me.DSPrtCommSheets14.usp_PrtWrittenComms4SalesRep))

 I get a compile error of "Error      77      …
0
Free Tool: Path Explorer
LVL 8
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Is there a way to display SSRS pages immediately while long report is still executing ?

I do not want the users waiting until the entire report is completed before they can start seeing the report.
0
I have a main page with all the data in a tabular format.

I report dynamically generates data in number of tabs based on parameters with the main page as first tab.

Now when i export to the report and click on any one of the item (row data) in the main page then it should go that particular tab.

I tried DocumentMap - but it creates a separate tab with the links which i cannot use as the client wants to display the data in tabular format.

Also I tried bookmark - but it work only with the first row of the table in main page. On click of other tabs it displays an error message says "Reference is not valid".

Can you please help regarding this.

Thanks in advance.
0
There is probably a simple solution to this, but I've searched around the various properties within the Matrix and Chart controls and cannot work it out!
Anyway, using BIDS, I have a shared dataset which returns a simple value of the Number of Starters within a company Grouped by Gender. When I add the shared dataset and test using Query Designer, I get the expected results: "F 27, M 36" (columns are Gender, Starters and the field datatype on the SQL side is INT).
However, when I add a Matrix or a chart to the SSRS report, I always get M 1, F 1. It seems that the report is simply returning a count of the genders rather than displaying the starters.  

The dataset itself is from a stored procedure in SQL; there are several parameters passed to the SP, but in this case I am passing NULL to most of the parameters apart from the Dates (First Date and Last Date in order to get the number of starters within a date range).

I think I am missing something simple, but have no idea what it could be!

Output from Query DesignerQuery designer output

Output in SSRS ReportChart and Matrix output

Bar Chart SetupChart definition
0
Hello,

I need to create an ssrs report using 2 different tables from 2 databases on the same server. I"m looking for examples on how to to do this. I tried by creating a dataset from a view that I setup that works in SSMS but I keep getting errors when trying to use it in SSRS. Any examples would be helpful.

Thanks.
0
Hi have 2 charts on my ssrs report and below it is a tabular report. When I look at the report it looks fine but when I export the report to SSRS, 1 chart is exported normally and other chart is shrieked. How to show both charts to same size when they are exported to excel. This is only with excel export other exports like PDF are fine.
0
SSRS from Microsoft SQL Server 2012 - 11.0.5058.0 (SP1) when I export a report to CSV with no result, I'm getting header and commas below the headings.   I am expecting a header but I'm not expecting the commas.

 SSRS report Output
 Reference,Portfolio
, ,

 I'm looking for output without commas
 SSRS report Output
Reference,Portfolio

 ------------------------------------------------------------------------------------
 My rsreportserver.config setting is as below
             <Render>
                   <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                         <Configuration>
                               <DeviceInfo>
                                     <Encoding>ASCII</Encoding>
                               </DeviceInfo>
                         </Configuration>
                   </Extension>
             </Render>

With same SSRS rsreportserver.config setting from Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0  I'm getting correct result.
0
HI,

I have a parameter, that has multiple values. I tried to allow it to have null or blank value, but it says I can't do that with multiple values selected. I want to make the parameter optional to the users, because they may not always want to select it.

In the attached file, there are the parameters the user has to select. Products, and EventDetails need to be optional parameters

C--Users-039824-Pictures-Capture_Par.PNG
0
Hi Expert,

I want to inventory all of my SQL Server Instances along with Server Name, DB_Name, DB_Owner, Create_Date, Version, Edition, Recovery_model as much i can retrieve.

Please Help!
0
Hi Expert,

In the following report i want to see total section based count like this Total EBS Core count xyz
Expression i used =sum(cint(trim(Fields!processorecount.value)))


is_ebs      Hostname appname      Processorcount memory      instancename

OPEN      xyz                         ddd            4                    15.42 GB      NULL
OPEN      xxx                         ccc            48                    125.64 GB      NULL

=Total EBS Core count xyz



is_ebs      Hostname appname      Processorcount memory      instancename

EBS                        yzx       eee            10                          251.57 GB      DEV


=Total Core count xyz


is_ebs      Hostname appname      Processorcount memory      instancename

NON-EBS crs                   rrr            10                          251.86 GB      xyx

=Total OPEN Core count xyz

  Please help me!
0
Free Tool: IP Lookup
LVL 8
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have a schedule report. Each row represents a time in 30 minute increments. Each column is a person. Each cell has information on what the person is scheduled to do at that time. It is highlighted in a color to indicate the type of task. What I need to add is if the task is longer than 30 minutes, I need to highlight the cells below to show the duration of the task. So if Joe has OT (Blue) from 1pm to 2pm, The information goes in the 1pm cell and is highlighted BLUE. What I need to do is also highlight the 1:30 pm cell. I may be able to come up with a solution by changing the query and creating more records for the report that will contain information so I can highlight the cell without repeating the text information. But what I would like to do is make the textbox with the highlight span multiple rows based on the duration. In essence, what I'm trying to do is duplicate the look of an Outlook Calendar where the height of appointments is based on how long the appointment lasts.
Thanks
Example of Result needed
0
Hi Experts,

I have a report that until recently used one SQL database to populate.  Business requirements are forcing me to split the database up.  When I deploy the report it fails and I get the following error.  Both databases are housed on the same server.  
I checked the documentation and found that "Remote data sources are not supported. Reports that are hosted in a SQL Server Express report server must retrieve SQL Server relational data from a local SQL Server Express Database Engine instance."  Which both are but still getting the error.  Report runs fine until I deploy it.  Any suggestions?  

An error has occurred during report processing.
Cannot create a connection to data source 'POSReportSupport'.
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.
0
I added the Parent line to one of my reports that only had a detail line, and along with  =Int((RowNumber(Nothing))/65520) was able to break report into multiple sheets if user imported  huge reports to .XLS (which they do once in awhile).

Now, I have another report that already has a parent and child grouping. When I added another Parent line with the  =Int((RowNumber(Nothing))/65520) again, the report runs but will not break into multiple sheets if user imports a huge report into .XLS.
.XLS import will just fail when it reaches that magic of number of 65536 records..

Is there another way of breaking huge report into multiple sheets when importing into .XLS ?
0
Hi Expert,

This is my following query but there are 3 condition ebs, non-ebs and open

select
case when i.is_ebs = 1 then 'EBS'
        when i.is_ebs <> 1 then 'Non-EBS'
        when i.instancename IS NULL then 'OPEN'
        when i.is_ebs is null  then 'Non-EBS'
            end as is_ebs
    ,o.hostname
      ,o.appname
,      o.processorcount
,      o.memorysize
      ,i.instancename


from oraclehosts o
left join oracleinstances i on o.hostname = i.hostname
left join hostwarranty w on w.hostname = o.hostname
Collate SQL_Latin1_General_CP1_CI_AS
left join puppetdb_certname_facts p
on p.certname = o.hostname where ipaddress not in ('xx.jj/cc', 'cc.uu/dd') and
p.fact = 'oracle_license' and p.fact = 'oracle_license' AND  p.value = 'true'


group by
i.instanceName
   , o.hostname
,      o.processorcount
,      o.memorysize
 , i.is_ebs
 ,o.appname

Query Output:--

is_ebs      Hostname appname      Processorcount memory      instancename

OPEN                     xyz      ddd            4                            15.42 GB      NULL
OPEN                    xxx     ccc            48                           125.64 GB      NULL
EBS                           yzx      eee            10                           251.57 GB      DEV            
EBS                          crs      rrr            10                          251.86 GB      xyx      





NB. I want create three section report and each section want to add processor count



is_ebs      Hostname appname      Processorcount memory      instancename

OPEN      xyz                         ddd            4                    15.42 GB      NULL
OPEN      xxx                         ccc            48                    125.64…
0
Hi EE,

All of the sudden multiple reports on our SSRS instance have begun timing out I have checked the underlying database no, or index/stats issues and IO performance (read/write) is between 11-16ms to great but not enough to cause problems. However, when running the SSRS reports that were having problems, I noticed the temp DB (On a separate Drive) read/write stats jumped from 37-46ms.

How would I begin troubleshooting this, any assistance is appreciated?

Thank you.
0
Hi,

I have the report shown in the image. I want to make the parameters (Region, Area, Field OfficeName) invisible, until they chose a report type. If they choose the value "region" then I want only the region parameter "region" displayed. If they choose area then "region and Area" and if they choose field office, then "region, Area, and field office" parameters to be visible.

That's the first part.

The second part, if they choose Region, I want on data set invoked, if they chose Area, another and if they choose field another. I would have three stored procedures, that would be the data sources for those data sets.

Thanks

RPT Image
0
Hi Expert,

I want to get the result only if the condition is true in the Oracle_License Column. This is for Reporting purposes.

Select
    o.hostname
,      o.lsbdistdescription as OS_Version
,      o.processorcount
,      o.memorysize
,      o.appname
,   max(w.warrantyEndDate) as LeaseEndDate    
,   p.value as Oracle_License

from oraclehosts o
left join hostwarranty w on w.hostname = o.hostname
Collate SQL_Latin1_General_CP1_CI_AS
left join puppetdb_certname_facts p
on p.certname = o.hostname where p.fact = 'oracle_license'


group by
    o.hostname
,      o.operatingsystem
,      o.lsbdistdescription
,      o.processorcount
,      o.memorysize
,      o.appname
,p.value


order by oracle_license desc

Here is the query output:--

hostname   processorcount      memorysize      Oracle_License

xyz1          4                                   15.42 GB                true
xyz2         48                                  125.64 GB        true
xyz3         1                                  7.55 GB             false
xyz4         1                                  7.55 GB             false
xyz5        1                                  7.55 GB             Null
xyz6        1                                  7.55 GB             Null


Please help:)
0
From SSRS when export a blank report to CSV, I'm getting a line of commas below the headings.

SSRS report Output
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D
 ,,,,,,,,,,,,,,,,,,

I'm looking for output without commans
SSRS report Output
Portfolio_Reference,Portfolio_Name,R,TR,TD,TC,D

------------------------------------------------------------------------------------
My rsreportserver.config setting is as below
            <Render>
                  <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                        <Configuration>
                              <DeviceInfo>
                                    <Encoding>ASCII</Encoding>
                              </DeviceInfo>
                        </Configuration>
                  </Extension>
            </Render>
0
I'm building a Windows application with a form to run an SSRS report.  I added the form, added the Report Viewer, docked it to the Parent Container, chose the rdlc file, clicked on rebind the data sources and when i click on choose Data Source, the two Data sets included in the project do not show up in the choose data source window.

What do I need to do to get the Data sets to show up so I can choose them?

When I view the data from the Data Set view, the data pulls in fine.
0
Guide to Performance: Optimization & Monitoring
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

I have SSRS report and calling child report using URL option. I tried with URLEncode and URLPathEncode but not working for country name = "Åland Islands" in Internet Explorer browser.
even after using the script as you mentioned URL converts that Country name to "%u00c3%u0083%u00c2%u0085land+Islands" .

below is the link i am passing to call report :

="javascript:void(window.open('http://azwindsqd02/ReportServer/Pages/ReportViewer.aspx?%2fDEMO%2fOEM+Models_V2&rs:Command=Render&Area="& Parameters!Area.Value&
"&Country="&Code.URLEncode(JOIN(Parameters!Country.Value,"&Country="))&
"&FormFactor="&JOIN(Parameters!FormFactor.Value,"&FormFactor=")&
"&PremiumFlag="&JOIN(Parameters!PremiumFlag.Value,"&PremiumFlag=")&"&SKUGroup="&JOIN(Parameters!SKUGroup.Value,"&SKUGroup=")&"&FiscalYearMonth="&JOIN(Parameters!FiscalYearMonth.Value,"&FiscalYearMonth=")&"&OEMType="&JOIN(Parameters!OEMType.Value,"&OEMType=")&"&TileFlag="& Fields!TileFlag.Value &"','_blank','directories=0,titlebar=0,toolbar=0,location=0,status=0,menubar=0,scrollbars=no,resizable=no,width=850,height=520'))"

can you please provide solution to me how to handle this kind of random special characters in country names like Curaçao, Saint Barthélemy etc.
0
I'm trying to figure out how to get rid of space at the top of a report, between the header and matrix. it makes it hard when exporting to excel. it adds an extra row to the spread sheet, which the users find annoying.
0
I use SSMS often and have used SSRS as well.

What does SSIS do? What are the biggest features of SSIS?
0
Hi,

I have a report, that I need to column headers to repeat on all pages. I have gotten this to work on other reports, but on this one, it doesnt' for some reason. What are the general rules ? attached is the file. (.rdl)
C--Users-039824-Documents-Visual-Stu.rdl
0
I have an application that helps inspectors complete inspections.  the backend of the application is sql and we also have a few ssrs reports that run off the database.  My Boss wants me to figure out a way to email inspection results to customers.  There will probably be about 100 inspections a day.  does anyone have a reference to use ssrs for completing this.  I would think every 15 minutes or so. ssrs needs to identify new resulted inspections and then email the report as an attachment.  any article or recommendation would be awesome

the reason I plan on using ssrs is because the inspection results need to be an attachment of some sort that looks official
0
I have a layout where text boxes in the report header must align with a table created in the body of the report. However, upon execution, there is a gap between the header and body. Is there a way to remove that space (gap)? See Screenshots below.

I have tried several ways but no avail. I even tried removing the page header and putting everything into one table on the report, but I still get this gap.

I'd appreciate any help with this.
Thanks.

Design
Report Design
Result
Report Result
0

SSRS

8K

Solutions

26

Articles & Videos

5K

Contributors

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.