Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

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

I have a url in my database so when I display a record per page I would like to have the web page from the url display as part of the report page. I see I can do it in 2016 but I only have 2012.
0
Hire Technology Freelancers with Gigs
LVL 10
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Hi,

I having little bit experience on SSIS,SSRS & SSAS. I want to get advanced knowledge on this.

Please provide some realtime scenarios with solutions?
0
I have a financial report that includes 3 fields that I'm trying to sum.  I only display a grouped total - not the detail.  One field sums a planned gift and both the grouped total and the final total works fine using sum(amount).  One of the fields is the asset balance and one is Net Present Value that is calculated on the report side.  All of the grouping totals work, but when I do the final totals I have a variety of problems.  I've listed some of the things I've tried and what the result is... sometimes it is an amount that is incorrect and sometimes it is an error.  The code I'm using (which I know very little about) is at the end of this.  

sum(asssetbalance)  - is the wrong amount - it is way too large (it should only sum the first asset balance)
sum(first(assetbalance)) - error that aggregate functions cannot be specified as nested aggregates
=Code.GetABTotal() - is the wrong amount - it appears that it totals each page, not a grand total
=sum(ReportItems!textbox72.Value) - gives me an error uses an aggregate function on a report item

I read that that you have to move the =sum(ReportItems!textbox72.Value)  to a footer so I tried that as well and it once again appears that it is totaling the page and not providing a grand total.  

Here is the code I tried and is for both fields that I'm trying to total:

Public Dim FVTotal as Double = 0
Public Dim ABTotal as Double = 0

Public Function AddFVTotal (Amt as Double) as Double
      FVTotal = FVTotal + Amt
      …
0
I have a trend defined in SSRS 2008 R2.

Under the Chart Data dialogue:
The value is defined as Sum(Result)
The category group is Result_On
The series group is Metric

My problem is I cannot seem to find the right expression for the Min/Max on the Vertical Axis Properties.
They are currently set to Min(Result) and Max(Result) respectively, but this does not work, as it does not sum the multiple Results for a given Result_On and Metric:

Sample Trend Issue
I would effectively like Minimum to be Min(Sum(Result)) over the Result_On category, and then take the min over all Metric series.
Similarly, the Maximum should be Max(Sum(Result)) over the Result_On category, and then take the max over all Metric series.

Is this do-able either through the Min/Max expressions, do I need to use ReportCode, or is this better done somehow in the database in SQL?

Thanks,
Jeff
0
I have an SSRS report that displays the TextBox contain muliple fields and it's content correctly in SSRS but when I try to export it to Excel the data is not show .

SSRS formatExeclLEDES-1998B.rdl
0
Please find the attachment .
I want the output like image Capture345.
Capture123.PNG
Capture345.PNG
LEDES-1998B.rdl
0
Background:
Sometimes when printing postal addresses to mailing labels, there may be a limited number of mailing addresses that do not consume an entire sheet of Avery labels. If an Avery sheet starts out with 30 blank labels and there are 20 addresses to print, this would leave 10 unused labels on the sheet. I was using a report that I created in SSRS 2008 to print the labels.

At a later time, when I needed to print more mailing addresses, I would have my SQL Server query generate 20 empty records, plus UNION in the actual mailing addresses, and this data would be passed to the SSRS report. This caused SSRS 2008 to skip over the 20 labels that were already used on the sheet, and begin printing on label 21. This allowed me to finish using the remaining labels on the sheet. The addresses would be properly printed on the remaining unused labels.

There was probably a better way to manage this, but at the time, it was the only idea that worked.

Current Day:
Several months ago, our environment was upgraded to SQL Server 2012 and uses SSRS 2012. The 2008 SSRS report was successfully deployed to SSRS 2012, but it no longer works as it did in 2008. If I were to repeat the scenario described above, the query is still generating 20 blank rows, but what SSRS 2012 appears to do is execute a carriage return / linefeed 20 times, and then starts printing, instead of skipping pass 20 "used labels" in order to start printing on label 21.

I have been researching to …
0
Hi,

I want to see the chart for the specific SQL report. But it is not displaying. Here i have attached the screen shot.

Thanks

Zahid
RPT_Design.PNG
Report.PNG
0
I have a report that needs to be run for 1 of 2 databases. The (2) databases are identical in structure, but not in data.

We have a company database that is identical in structure for 2 clients. I will call the clients "Coke" and "Pepsi" for this example.

I want the user to have a drop down in the report so the user can select to run the report for Coke or Pepsi. The stored procs that create the datasets exist in both Coke and Pepsi databases.

Is this possible or am I stuck managing 2 separate reports?
0
v2-native-ad-no-button.pngDo you work with and analyze data? Enroll in October’s Course of the Month to get step-by-step SQL training. Learn SQL to quickly and efficiently store and retrieve data!
0
Free Tool: Site Down Detector
LVL 10
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

cumulative update to sql server 2016 express causes ssrs to fail with error about scale-out deployments not being supported.  any help appreciated in getting around this error.
0
I hope to spend some time digging into SSIS and wonder what are the most useful aspects of SSIS?

Thanks
0
Hi Experts,

How Can I display the group name in the table header. I have attached a screen shot. I need to move the circled text to the yellow shaded area. Any suggestions?

Thanks in advance.
Delivery.png
0
Migrated web application from one sever to another. couple of folders in web app have rdlc files.
When trying to browse on the browser <ip-address>/Reports/default.aspx , it prompts with windows username and password.

Then it displays error on browser saying

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly.

I can see on the web application drive the reports folder and default.aspx exists along with rdlc files. What am I missing here?
0
Hi Experts,

In my RDLC report I have 2 table and connected to 2 datasets.  Table1->Dataset1 and table2->dataset2.  I don't want to show the table if it has no data. Is there any way I can stop running it from my program.  Because if I make it invisible in the report, then it does not show up but still it creates an empty page. Any suggestion??

Thanks in advance.
0
Is it possible to transfer usernames and passwords when adding an existing data source in SSRS? I have not had any success in finding a solution. We want to keep passwords secure so report developers cannot see them. I have created a Shared Data Sources folder in SSRS with the intention of having the developers simply add an existing data source from this folder into their solutions. However, when I ran a test, the existing data source did not import with the credentials.

Is that by design and if so, is there a workaround?

We are using SSRS 2008.

Thank you.
0
I have an SSRS report that displays a person's photo if it is stored in the table. It will be defined as binary. If there is no photo, I want to display a bmp image that just says NO PHOTO. Can you write an expression for an image that will either choose a binary or a embedded image? When I choose image for my report, it requires you to choose database, embedded or external. I created a custom field for my dataset that is named NOPHOTO. When I do the below expression, the binary pic displays fine but the NOPHOTO doesn't display. It has the red X in the top left corner.


=iif(isnothing(Fields!PIC.Value),Fields!NOPHOTO.Value, Fields!PIC.Value)

Thanks
0
I have two tables A and B. Both have same fields names ( Group and Roles)
Now I want to compare two tables A and B, I only want to only field group, not roles

I want to have the results
1. common groups
2. Groups in A but not in B
3. Group in B but not in A

This may need 3 queries. How to do that?
0
I am looking for a good third party tool that will help manage SSRS report subscriptions. We want to expose this to our business users so that they can manage their subscriptions as well as client subscriptions. Is there anything out there right now that can help with this particular requirement?
0
Free Tool: ZipGrep
LVL 10
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

I inherited some web application that seems to be using some reports within aspx pages. I am trying to migrate them to new server. When page in question is browsed on new server it pops up with windows username and password dialogue box.
Has anyone encountered this before?
0
I have problem in txt file output. I have record "His short film features 4 readings of a prose poem from Leonard Cohen’s novel Beautiful Losers". when output comes in txt file like"His short film features 4 readings".
It will shows half records.But in PDF format i got well result..I can not the drag the width of SSRS reports bez it will show unformatted manner.
1img.PNG
2img.PNG
0
We have SCCM current branch 1706, with a SQL 2012 server on the back end running SSRS. I would like to allow our Service Desk access to create their own reports in one specific folder only - protecting all the other folders containing the standard SCCM reports.

Is there a way to define a security scope that's SSRS folder aware? I don't think I can do this from the SSRS side. I believe SCCM sets all permissions via policy on those SSRS folders every 15 minutes.
0
I have column Name is FirstName and It has 30 characters like ' signs agreement with HTC continuing our big bet'. when I am displaying this value with ssrs reports it shows me half characters like 'signs agreement with HTC'. I need to display all values.
0
Hi Experts,

I have this bit of code:
,(Select SUM( Case when ActionableResult = 1 THEN 1 ELSE 0 END ) as [Fail] FROM CTE_Compliance as di1 where di1.[Branch Region] = own.[Branch Region] ) as RegionFail
,(Select SUM( Case when ActionableResult = 1 THEN 1 ELSE 0 END ) as [Fail] FROM CTE_Compliance as di1 where di1.[Branch Region] = own.[Branch Region] and di1.[Branch Network] = own.[Branch Network] ) as NetworkFail
,(Select SUM( Case when ActionableResult = 1 THEN 1 ELSE 0 END ) as [Fail]  FROM CTE_Compliance as di1 where di1.[Branch Region] = own.[Branch Region] and di1.[Branch Network] = own.[Branch Network]  and di1.[Branch] = own.[Branch] ) as BranchFail
,(Select Cast( SUM( Case when ActionableResult = 1 THEN 1 ELSE 0 END)  as float) /Count(*) as PercentCompliant  FROM CTE_Compliance as di1 where di1.[Branch Region] = own.[Branch Region] ) as RegionPercent
,(Select Cast( SUM( Case when ActionableResult = 1 THEN 1 ELSE 0 END)  as float) /Count(*) as PercentCompliant FROM CTE_Compliance as di1 where di1.[Branch Region] = own.[Branch Region] and di1.[Branch Network] = own.[Branch Network] ) as NetworkPercent
,(Select Cast( SUM( Case when ActionableResult = 1 THEN 1 ELSE 0 END)  as float) /Count(*) as PercentCompliant FROM CTE_Compliance as di1 where di1.[Branch Region] = own.[Branch Region] and di1.[Branch Network] = own.[Branch Network]  and di1.[Branch] = own.[Branch] ) as BranchPercent
,(Select count(*) as [All] FROM CTE_Compliance as di1 where di1.[Branch 

Open in new window

0
I need to make SSRS 2012 reports available to users on a mini ipad.
What would be the best way to implement?
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.