Improve company productivity with a Business Account.Sign Up

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

Trying to combine multiple fields into one where other column is duplicate.

Select S.SerialNumber,  P.Packaging
From Serial S inner join Packaging P on S.Item = P.Item

Example of Results
SerialNumber            Packaging
1111                            10 Carton/Metal Can
1223                            10 Carton/Metal Can
2222                            12 Carton/Wood Container
2333                             15 Carton/Wood Container

What I would like is
SerialNumber            Packaging
1111, 1223                 10 Carton/Metal Can
2222                            12 Carton/Wood Container
2333                             15 Carton/Wood Container

It's for a SSRS query. Using SQL Server 2008 R2 and SSRS 2008 R2.
0
Free Tool: IP Lookup
LVL 12
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.

In SSRS report how can we add the index pages at end of the report with page # and Group Description.

I have a ssrs report group by Product and for each product I'm starting in new page by page break at group level now how can we add the index page at end
0
Windows 2012, SQL 2012, Dynamics 365

The ReportServer and ReportServerTemp databases, from our CRM 2011 SQL server, were restored to our Dynamics 365 SQL Server.  This did not work and made all reports in Dynamics 365 non-functional.

I have tried creating a new ReportServer database using the SQL Reporting Configuration Tool however this does not make the existing reports functional.

What is the solution to get back to where were before the  ReportServer and ReportServerTemp databases were restored from our CRM 2011 SQL server?

Is there a method to map the existing reports to the new ReportServer datasource I created?

Thanks
0
We have SSRS reports that pull from our data warehouse.  The IT team Active Directory group has Read permission to the data warehouse.  However, there are some reports that are going to be used by other staff, not just the IT team, but I don't want to grant Domain Users permissions to the data warehouse.  I see when setting up SSRS data sources I can store a username/password, but it says the 'Credentials stored securely in the report server'.  Is it talking about the Report Server database?  Because Report Server is a different database than the data warehouse, however they are on the same server.  

So at the report level, I will only give permissions via the report security so certain non-IT staff will have access to the report.  But how do I get the report to be able to pull from the data warehouse without adding those certain staff (and the list may grow of who they are) to the permissions of the data warehouse database?
0
Hi I have the following requirement. I am having trouble breaking it down into tasks and would appreciate any input from Power BI and SSRS experts here to do so. I am new to PowerBI and am having trouble even figuring out how to get started on this.

"Initially we want to setup an existing SSRS report via SSRS/ w/Power BI integration

 Using new authentication methods (not sure what’s best, but other people are doing this so no need to re-invent the wheel)
http://www.itprotoday.com/microsoft-sql-server/using-reporting-services-internetextranet-environment

We want to be able to have an extranet user authenticate, Have parameters applied to their user object that only allows them to see data they’re associated with by individual and groups.


This may require an Azure instance of SSRS/IIS to pass credentials (which I’m fine with as we can treat that as a DMZ) we should have plenty of dev azure space with our MSDN accounts.

Some of the things to consider as you’re doing this,..
We eventually want to make a lot of this “self-service”
So a Customer Admin” could add/remove e-mails for trend users get notifications, add/remove logins (restricted to trends data obviously) add/remove those users from groups, add remove pages from groups etc…"

HELP! I don't even know where to begin with this.
0
How to print directly from SSRS report without showing Report Viewer by specifying printer name in code behind.
0
I am using Visual Studio 2012 to edit an SSRS report.  VS does not show the SQL Data Tools so I downloaded and installed the latest version.  However, it does not show Update under the SQL menu option of VS 2012 to add the SQL Data Tools

I restarted my computer but still do not see Update or SSDT

Can someone tell me how to get SSDT on VS2012?

Thanks
0
I have reports displayed on the Reports Manager Web page.
Some of these reports are currently not used and I would like to hide them rather than delete in case they are needed in the future.
There is a Delete option in the menu bar, if I use this does this delete all the code for creating the report?
If it does, how can I just hide the report?
Thanks
0
Hello all, I am trying to create the attached dummy file in SSRS. I have the data that populates into a table already. The problem I am having is getting it into the format shown. We are moving to a new platform and our teams have requested that the format remains the same as in the previous system...I have the Stored Proc setup accordingly with parameters I pass to return GL Period and Year along with Departments. I need the report to give me the detail and sum of the different sections(Revenue, Salaries, Other Expense) as shown.  It needs to be separated by Department. So when I produce the report it will show Department A , its related data(Revenue, Salaries, Other Expense, then begin a new page with the next department and so on...Any help out there ?
EE-PL.JPG
0
  1. I need to allow my user to select a column name and its value from a parameter (or two params) to filter the result.
  2. I have a text parameter with a few column names that are listed in my dataset Column1, Column2, Column3. Each of those columns has only two values 1 and 0.
  3. I would love some help in getting an idea how to filter my dataset based on the column name listed in the parameter and a selected value (1 or 0)
  4. I assume it has to be related to a dynamic sql but, not sure how to incorporate that in either the WHERE clause or the actual dataset filter.
  5. Thanks for any points guys!! :)
0
Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

SSRS 2016, and I'm trying to create a subscription.  I keep getting an error that there are no stored credentials.  I've provided credentials to the data source and to the report; SA as a matter of fact; but keep getting the same error.  I've looked at the same report I have on a 2012 instance and that works fine.
0
We use RDLC reports in vb.net, we use VS2010 to develop, the reports connect with database in SQL Server 2014.  

We want to create animated column or pie charts, for example, a column chart is growing from bottom to top when the page is loaded.  

Can RDLC report do animation?  Do you have sample?  I don't know how to get started.
Thanks.
0
SSRS 2008 Margin problems when downloading report to MS Word.
Hello, I have some reports that users generate and then they download into MS Word.  When this report is downloaded and
rendered in MS Word, it 'cuts off' the bottom of the data within the report.
I first thought it would be the page, table, header or footer settings, so I changed those or modified those to see if the data
would show.
Interesting facts:
When I try other formats or download, like .pdf, .xlsx, these files render just fine and show all the data, as expected.
Also, if I open the MS Word file after downloading, and then view it in Read Mode or Web Layout, the data also all shows.
Thanks, and the SSRS version is 2012.  (Sql Server 2012)
0
How would I create a SSRS report that would automatically output and excel spreadsheet with multiple tabs?
0
I Have Product Gold .
How print Label Barcode .
Size Paper 7.5c 1.3c
Brand of Zebra printer.
How to Add CheckBox To Report RDLC.
And Print Only Selected Row.
Maybe one or more Row
Thank Vey Much
0
Hi all.

I would like to add 2 numbers in an expression that uses "HTML - Interpret HTML tags as styles" as the Markup type. I've tried the following:

="<b>" + "Net Order: " + "</b>" + CDbl(First(Fields!NonTaxableAmount.Value, "DataSet1")) + CDbl(First(Fields!TaxableAmount.Value, "DataSet1"))

Open in new window


AND

="<b>" + "Net Order: " + "</b>" + CDec(First(Fields!NonTaxableAmount.Value, "DataSet1")) + CDec(First(Fields!TaxableAmount.Value, "DataSet1"))

Open in new window

But it displays #Error when I preview the report.

Any idea how I can add these 2 fields? They are of type Decimal in the table.

Thank you in advance.
0
show or hide parameters in ssrs 2016 based on a radio button selection.  I have a report that can show either all items by year or items by month.  I want a radio button that will show a year parameter if selected and show the month and year parameter if selected.  How can I achieve this?
0
I am using Ghostscript to convert a PDF to a PNG.  When I convert it I would like to rotate it 90 degrees because on the SSRS report I am inserting it into I need it to display "vertically" rather than horizontally.  Is there any way of to do this in Ghostscript?
0
How to add Index and page # for SSRS report. I want to add an Index page as a last page where group by as index name and page #.
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

I have a SSRS Report using Report Builder and inserted an Image.  It is set for:
MIMEType = image/png
Source = Database

I want to be able to rotate the image 90 degrees.  How can I do this?
0
The rectangle is too complex to export data to word using ssrs report
0
Hi Guys ,
 I need help with one query, i need to get multiple count and amount from the same table for a report e.g

 Loans table.


Status, Amount  , date
 approved , 1000 , 2018 03 16
approved , 2000 , 2018 01 16
 rejected , 10000 , 2018 03 16
rejected , 30000  , 2018 01 16
pending, 10000  , 2018 03 16
pending, 10000 , 2018 01 16

now the result I am looking for is to give me the count of how many cases I have for reach status for today, this month and this year with total amount e.g...
Approved                                             Rejected                                               Pending
Today ,     This MOnth , This Year      Today      , This MOnth   , This Year          Today        , This MOnth , This Year
1 , 1000  , 2 , 3000         ,2 , 3000        1 , 10000  , 2 , 40000      , 2 , 40000           1 , 10000   , 2 , 20000      ,2 , 20000    

Open in new window


 


Thanks
 Ali
0
I have an issue with a calculation in SSRS 2016. My tablix reports on orders and has 3 row groups. From outside to inside that is:
- Whether the order was closed or missed (boolean)
- Market segment
- Market subsegment
I also have a column groups for month and year-to-date.
My problem is that I want to perform a calculation for the ytd column group that involve results from both the "closed" and "missed" results in the row groups, for the market group and subgroup records. I've tried to illustrate it in attached example.
Anyone have any idea what expression i can use to achieve this? Not sure if it matters, but the datasource is an SSAS MDX cube.
Thanks.
0
I am using Subscriptions to save an SSRS report as pdf into a network folder mjd\send at 6:00 am on weekdays. The name of the file is rptPot.pdf. The file is overwritten each day. I would like to create a package in integration services that would rename this file to rptPot_CurrentDate_CurrentTime so that I have a copy of each day's file.  How would I accomplish this ? Thanks.
0
I have a Monthly expenses report deployed to a 2008 Reporting Service’s Server.
Individuals can run this report by choosing their name from a drop down list.
However they can also chose other names and run the report, and this is causing a privacy issue.
Is there some way I can use the users logon credentials (it is an AD network) as a parameter and not use the drop down list of names?
I am using Visual Studio 2008 for modifications.
Any advice appreciated, thanks
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.