Improve company productivity with a Business Account.Sign Up

SSRS

Solutions

Content

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.

SQL permissions for SSRS

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?

2 Comments

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.

SSRS
powerBI

0 Comments

Question by

vensali

6d ago

ssrs direct print

How to print directly from SSRS report without showing Report Viewer by specifying printer name in code behind.

SSRS

2 Comments

LVL 1

Question by

apollo7

2018-04-13Solved

How to add SSDT to VS2012?

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

2 Comments

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

SSRS

3 Comments

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 Comments

I need to allow my user to select a column name and its value from a parameter (or two params) to filter the result.
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.
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)
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.
Thanks for any points guys!! :)

0 Comments

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.

SSRS

1 Comment

Question by

finditout1

2018-04-02

animate rdlc/ssrs reports

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.

8 Comments

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)

9 Comments

How would I create a SSRS report that would automatically output and excel spreadsheet with multiple tabs?

SSRS

3 Comments

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

SSRS

2 Comments

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.

HTML
SSRS

2 Comments

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?

SSRS

1 Comment

Question by

maverick0728

2018-03-23Solved

Ghostscript rotate image 90 degrees

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?

1 Comment

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

1 Comment

Question by

maverick0728

2018-03-22Solved

SSRS Image Rotate 90 Degrees

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?

3 Comments

The rectangle is too complex to export data to word using ssrs report

2 Comments

Question by

Syed Ali Shah Rashdi

2018-03-16Solved

SQL multiple Count

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

5 Comments

LVL 13

Question by

Koen Van Wielink

2018-03-16Solved

SSRS expression to calculate per row across group results

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.

3 Comments

Question by

StampIT

2018-03-14Solved

Rename pdf file using Integration Services

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.

4 Comments

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

SSRS

3 Comments

First
Prev
1
2
3
4
5
6
7
Next
Last

SSRS

Solutions

Content

Contributors

Expand your skills with this month's free Premium course.

SSRS

Related Topics

SSRS

Related Topics