Stack Overflow
Stack Overflow

Questions tagged [sqlreportingservice]

54 questions
4
votes
3 answers

Count and pivot a table by date

I would like to identify the returning customers from an Oracle(11g) table like this: CustID | Date -------|---------- XC321 | 2016-04-28 AV626 | 2016-05-18 DX970 | 2016-06-23 XC321 | 2016-05-28 XC321 | 2016-06-02 So I can see which customers…
user2798561
  • 99
  • 8
2
votes
2 answers

Automating Configuration of SSRS 2016 with powershell (Need to change URL from "https" of "http")

I have already installed Report server database(SSRS 2016). I know how to configure Report server through RS Configuration Manager, but I want to do this automatically with power shell. I want to change Webservice and WebPortal URL to "https" and…
Karthik Karnam
  • 170
  • 11
2
votes
1 answer

Automate SSRS configuration C#

I am trying to create a program that I can run to automate the configuration of reporting service for MSRS13. The code correctly copies the cert into the trusted root store. The code correctly copies the URL information into the…
Thomas A. Bosler
  • 63
  • 5
2
votes
1 answer

SSRS report graph is working fine in outlook but it is not working in gmail and thunderbird

The ssrs reports is not showing any graphs in the thunderbird and gmail. But it works in the outlook without any problem. The graphs sent comes as an attachment and there is a rectangular box in the place of the graphs.
Ashish Chhetri
  • 23
  • 5
1
vote
0 answers

Multiple page size and orientation setting in power bi report builder

I am working on a report project using Power Bi Report Builder version 15.7.1740.1 (latest). And I have a request from the customer to create only the first page as portrait as cover page and the remaining pages orientation will be landscape. The…
vipmaa
  • 1,022
  • 16
  • 25
1
vote
0 answers

How to change ASP .NET WebForms ReportViewer control print to local printer no PDF

I have a report RDLC with SQL Reporting Services in ASP .NET WebForms, but Print Button in ReportViewer web control only allows to create PDF file? How could I change to default local printer or show printer local list?
Ejrr1085
  • 975
  • 2
  • 16
  • 29
1
vote
0 answers

How to delete SSRS report files from specific folders in Report Server?

I have to delete around 200 SSRS Reports from different folders in Report Server. DBA advised us not to use SQL script on Report Server database, which is not recommended. Is there any way to delete rdls from Report Server other than manually delete…
Sunjith
  • 76
  • 1
  • 11
1
vote
3 answers

SSRS-Datasource won't change when reupload report

I got a report with 2 data sources and both are Shared Data source. I am trying to change both of them to Custom Data Source but when I re-upload the report in my Report Manager, it won't work. Edit: I don't have an error because the report…
Marie-Catherine Richard
  • 13
  • 5
1
vote
1 answer

Dynamic Report creation

I hope someone here can help. I have a requirement from my client who is an ISV. They want to develop a solution whereby they want to offer their customer an ability to create any reports from the customer specific database. What I mean is, we…
user1716729
  • 387
  • 1
  • 6
  • 19
1
vote
2 answers

SSRS - Expression not working after putting Subreport

I have trouble regarding expression. I have a report that has a calendar style. (Screenshot below) I have an expression on the Day Number on the top left of the calendar cell, and it works (Which is in the top box). Here is the expression :…
interkey
  • 355
  • 5
  • 21
1
vote
2 answers

SSRS Expression to add two time field columns

I want to add two columns(Time Field-HH:MM:SS) in the SSRS table report. E.g.: Login_Time Logout_Time Total_Time 2:13:10 6:10:05 8:23:15 3:31:09 6:01:01 9:32:10 I have inserted new column in the report to get a…
Arun
  • 21
  • 3
1
vote
2 answers

Retrieving the COM class factory for component with CLSID failed due to the following error: 800703fa

This error occurs only at specific times and once iis reset is done,it comes back to normal I want to know about root cause of this issue. This is ocuruing in one of the server which uses sqlreporting services to fetch the data from the db
vikramnr
  • 93
  • 2
  • 12
0
votes
0 answers

Print multiple transfer order's Picking list (WMSPickinglist_OrderPick) report in ax 2012

My requirement is, I want to print Multiple Transfer order Picking list report (WMSPickingList_OrderPick). Navigation : Inventory and warehouse management > Periodic > Transfer update > Picking list. when I select multiple Transfer order's picking…
Moiz Ahmed
  • 1
  • 1
0
votes
1 answer

Is there a way to choose functions for dates when subscribing to an SSRS report?

I have a report that has a 'StartDate' and 'EndDate' parameter, with no default values. When subscribing to this report, the user chooses the dates that they would like to see. What I want to do is have options for them to choose, such as 'Today',…
Evie
  • 1
0
votes
1 answer

Showing full row at top of page for SSRS report

I am hiding duplicated values in my report. I only show those cells where the value is different from the one above it. This makes it look like a series of inverted stair steps or half an upside down pyramid. Data sort order is Field1, Field2,…
ARLibertarian
  • 155
  • 1
  • 11
1
2 3 4