Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

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

Hi Experts,

I am generating some labels as shown in Label1.png. My design is in Labeldesign.png.  My client needs the output in two columns as shown in Label_Desired.png. Please suggest is there any way to do it?

Thanks in advance.
Label1.png
LabelDesign.png
Label_Desired.png
0
Enroll in September's Course of the Month
LVL 10
Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

I have a table which has FirstName,LastName columns and i need to display the result like Names must be entered Last name , then a comma, followed by First name (e.g., "Arnsley, Robert"). I want to handle this on SSRS reports and tried like that but not working =Fields!LastName.Value, Fields!FirstName.Value
0
I am trying to pass two parameters through my report to get a report window to pop up. I am getting the following error and cannot see my issue. Perhaps tired eyes and could use a hand.

Name 'PATIENTVISITID' is not declared.

="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"

&"/Billing Reports/Jeffs/Testing Folder/Sub_rdl_Detail_QuestionAnswerChecklist&rc:Parameters=False&rc:Toolbar=False
&PATIENTPROFILEID="& Fields!PatientProfileId.Value & PATIENTVISITID="& Fields!PatientVisitId.Value &"
','DetailsWindow','left=300,top=180,width=850,height=365,status=no,menubar=no,scrollbars=yes,location=no'" & ")"

Open in new window

0
I have 2 problems, but they are inter-related.

MS CRM 2013 on premise, all functions on a Windows Server 2008 R2 VM with the SQL DB on a separate Windows Server 2008 R2 server.

1) Report Server not working as expected
2) CRM workflows stopped working.

CRM 2013 has been installed and working fine for years. About a month ago they wanted to start using reports, but the report server was never used or tested before. Tried to do some subscriptions and got the error message about credentials not stored. So I researched and at that time the SQL server was SQL 2008 standard. The requirements stated it must be at least SQL 2008 R2. So on Sept 4 I upgraded the SQL server to 2008 R2. Everything still working as normal after that but still no reports or subscriptions. Further research suggested that both the CRM server and the SSRS needed to be at 2013 SPM U4. The Server was 2013 SP1 U3 but SSRS was only 2013 SP1. So Friday afternoon I installed 2013 SP1 U3 on SSRS but it prompted for a restart. Well can not do that so waited until Saturday morning. At that time I restarted the SSRS server then installed 2013 SP1 U4 on the CRM server and on the SSRS server and both were restarted.

So, Monday morning I get an email saying all workflows failed after Friday afternoon.  I was told this AFTER I had been attempting to get reports to work by making some changes to the SSRS via the SQL Reporting Services Configuration Manager.

So, I need urgent help. First to get the workflows …
0
This "Go To URL" in my SSRS report textbox works fine except it does not pass the text box value.
&SuffixSearch=Fields!Custno.Value    (this does not pass the textbox value)

What am I missing ? How do you pass the actual textbox value ?

Entire URL:

https://sqldevrs01.cn.ca/ReportServer/Pages/ReportViewer.aspx?/AGILERPTS/RMReports/ARInvoiceDetail&ProblemGroupSearch=&CCIDSearch=&SuffixSearch=Fields!Custno.Value&CustNameSearch=
0
I have the following query which pulls back details per style for how many units that are available to sell.

The query pulls 5 units where Size_Ind IS NOT NULL

DECLARE @OTSOVR CHAR(3);
SET @OTSOVR = 'OTS';

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT DISTINCT LTRIM(RTRIM(cs.group_code4)) + '-' + LTRIM(RTRIM(cs.STYLE)) AS Scale_Style ,
        ISNULL(zzxexfvr.stor_file, ' ') AS Img_File_Name ,
        cs.Scale_Name ,
        cs.group_code4 ,
        cs.SeaSyrScale ,
        cs.STYLE ,
        cs.EndLocation ,
        SUM(CONVERT(INT, CASE @OTSOVR
                           WHEN ( 'OTS' ) THEN ( cs.OTSPlan )
                           ELSE ( cs.OTSOpen )
                         END)) AS OTS ,
        cs.COLOR_CODE ,
        cs.lbl_code ,
        CONVERT(DECIMAL(10, 2), cs.std_cost) AS std_cost ,
        cs.Size_Ind ,
        CONVERT(DECIMAL(10, 2), cs.a_price) AS std_price ,
        cs.Main_Label ,
        SUM(cs.AvailQOH) AS AvailQOH ,
        SUM(cs.QOH) AS QOH ,
        CASE WHEN ( EXISTS ( SELECT *
                             FROM   zzxrangd AS Rg
                             WHERE  ( Rg.style = cs.STYLE )
                                    AND ( Rg.color_code = cs.COLOR_CODE )
                                    AND ( Rg.lbl_code = cs.lbl_code ) ) )
             THEN ( 'Y' )
             ELSE ( 'N' )
        END AS RangeComponent ,
        cs.season ,
        cs.Classification ,
        

Open in new window

0
I have reporting services 2008 r2.

I have an active report that I need to update.  I do not believe I have a copy of the original project.

Can I down load the report, make the update, then redeploy it??
0
I'm using SSRS 2016 and facing rendering issue in IE 11 (one e.g. Drilldown button is missing when we browse reports via IE 11 ). It works fine with Chrome, but our end users preferred browser for  SSRS reports is IE 11. Is there anything can be done at server level to fix the rendering issue.

Your help is highly appreciated.
0
I have multiple datasets in Report Builder 3.0.

I'm trying to calculate the following:

=Code.Divider(Fields!Amazon2016.Value + Sum(Fields!Amazon2016.Value, "DataSetOpen") - Fields!Amazon2017.Value + Sum(Fields!Amazon2017.Value, "DataSetOpen")   / Fields!Amazon2016.Value + Sum(Fields!Amazon2016.Value, "DataSetOpen") )

Open in new window


Textbox.Paragraphs[0].TextRuns[0]’ contains an error: [BC30455] Argument not specified for parameter 'Divisor' of 'Public Function Divider(Dividend As Double, Divisor As Double) As Object'.
0
No matter what I have tried from internet searches, my SSRS report date fields will show as General or Custom (in excel Number Format) cells when exported to Excel.

User wants cell's number format, in excel, to show as a Date not General or Custom.

Any idea's ?
0
[Webinar] Lessons on Recovering from Petya
LVL 10
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

I have tried the following as expression..
=IIF(Fields!Company.Value="B", "Perfect Order Details Report - Company B", "Perfect Order Details Report - Company C")

I only getting the "C" report ...the "B"Report shows no data..

If I swap the true for the false ...I only the "B" Report.

The "Text Box Properties" of this are Action > Go To Report.....Specify <<Expr>>  which I have displayed above
0
Current order of input report parameters is:

Customer#                                      Name
City                                                   State
Zip

Is there a way to change input order to this:

Customer#                                      Name
City
State
Zip

If not, is there a version of SSRS that allows you to do this ?
0
Hi Experts,

I have this:
=(Sum(Fields!Resolved_Vulnerabilities_in_30.Value) / Sum(Fields!Total_Vulnerabilities.Value)) * 100

Open in new window


as expression.

But I get this:
2/368,421 = 0.00

5.428

Please help and thanks
0
For my SSRS report I am using matrix which has two row groups and one column group with a value filed.
As a filed which is used for Column group has short name and Long name fields. Is it possible to show short name in matrix and tag(when user put cursor on it  then show long name) long name.
0
I upgraded the SSRS reports from my local to the server. For some reasons, I could not find the local version. Now I'd like to copy the folder of the reports from the server to local. How can I do that?
0
Hi All,

I'd like to use Windows 10 VM (latest Creators Update 1703) to run a special BI software (Workstation Edition).
I wonder what's the limitation or caveats when I also install the SQL Server 2008 R2 Std. Edition on this Windows 10 VM ?

The reason I cannot use Windows Server is that the BI software cannot be installed on Windows Server OS.

I also need to run the reporting service on this Windows VM.

Thanks,
0
For some reason the number format in column titled "Enroute to at Scene" is at times running over 2 decimals. It is an Average the same format as the "Turnout Time" . Is there a way to trim the number down to only show 2 decimal places?  example:  "6.37"  instead of "6.37536585........"

Sample of Fields
0
I have a very easy query, but I need the same report to run two ways and possible a third.

the query supplying the data to this report is  
Select * from Bills2017 where accountnumber = @accountnumber

I need the user to be able to provide an accountnumber to see all the bills for this accountnumber.
I also want the query to be able to ignore the "where accountnumber = @accountnumber) part
basically a whole dump of the table into the report.

how do I do this
0
Hi guys-
I have an application that i want to generate a hyperlink to a report in ssrs.  
Here's what i am trying to fix.

let's say i have an ssrs report that shows account Information.
example.    http://reportserver/reports/pages/accountinfo

this report asks for the variable... accountnumber.

is there  a way to configure a link to the report that will also supply the report with the variable at the same time.....

example... i want to create a hyperlink that will not only go to the accountnumber page... but will also supply the accountnumber so that the report will open up with the results when the user just clicks the hyperlink
0
Free Tool: Subnet Calculator
LVL 10
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

how do I join two queries, join them HORIZONTALLY, i.e. extra columns, second columns query 2 to right of first query



--query 1 OUTPUTS
SELECT a.timeStampKey, t.timeStamp,MAX(CASE WHEN a.PIE2_O_ID = 1 THEN value END) AS 'K_DESIGN_SG_A_AVERAGE_A', MAX(CASE WHEN a.PIE2_O_ID = 2 THEN value END) AS 'K_DESIGN_SG_B_AVERAGE_B'FROM   tblOutputs as a INNER JOIN       tblTimeStamp as t ON a.timeStampKey = t.timeStampKey GROUP BY a.timeStampKey, t.timeStamp
--query 2 INPUTS
SELECT a.timeStampKey, t.timeStamp,MAX(CASE WHEN a.PIE2_I_ID = 10104 THEN value END) AS Flow, MAX(CASE WHEN a.PIE2_I_ID = 10006 THEN value END) AS Head FROM   tblInputs as a INNER JOIN       tblTimeStamp as t ON a.timeStampKey = t.timeStampKey GROUP BY a.timeStampKey, t.timeStamp
0
Permission issue but i can't figure it out
0
when we upgrade the report to our new server the xml export stopped working.

I've been trying t troubleshoot but since i'm not to familiar with xslt transformations i'm having a hard time finding the problem.

I think the problem is with name spaces.
if i use this code i got from here i can get the entire xml to export
</xsl:template>
    <xsl:template match="node()">
        <xsl:copy>
            <xsl:copy-of select="@*"/>
            <xsl:apply-templates select="node()"/>
        </xsl:copy>
    </xsl:template>

but when i try to match a specific node it fails.

my original xml without the transformation comes out like this:
<?xml version="1.0" encoding="UTF-8"?>
<Report xmlns="Logos_x0020_Export_x0020_Report" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="Logos_x0020_Export_x0020_Report http://reportserver?%2FLogos%20Export%20Report&rs%3AFormat=XML&rc%3ASchema=True" Name="Logos Export Report">
   <Tablix1>
      <Textbox15>
         <Textbox19 />
      </Textbox15>
      <Group2_Collection>
         <Group2>
            <Group1_Collection>
               <Group1 Group1="PB2017-1886&amp;#xD;&amp;#xA;">
                  <NamePaidby1 NamePaidby1="INTERIOR ENVIRONMENTS&amp;#xD;&amp;#xA;48700 ADDRESS City ST 111111" PaymentType="Check Number: " CheckNumber="30000" TotalAmount="167.00">
                     <Details_Collection>
                        <Details Description="Initial Plan Review Fee" …
0
Hi ,

Please provide detailed procedure for In-Place Up-gradation from MS SQL Server 2012 to MS SQL Server 2014 include MSBI Components like SSIS Packages, Cubes/OLAP Databases and SSRS Reports.

Please consider this high priority.

Thanks,
Chandra
0
I have sqlexpress with data reporting on a web application server.  How can I deploy reports that I have created on my local computer to the the server?
0
Hello,

How can I force language report server 2016 culture fr-fr. Report Server has been installed on server 2012 US, regional settings are french. But some reports display date in format En-US.
I try the following without result :
UPDATE dbo.Catalogue
SET Property = N'<Properties> <Language>fr-FRLanguage> </Properties>'
WHERE CAST(Property AS NVARCHAR(MAX)) = N'<Properties> <Language>En-US</Language> </Properties>'

How can I resolve?

Thanks

regards
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.