reporting-services Questions
7
Solved
I have 'param1, param2, parma3' coming from SSRS to a stored procedure as a varchar parameter: I need to use it in a query's IN clause but then need to change its format like this first:
select *
...
Leviathan asked 22/12, 2014 at 15:59
4
Solved
I have an SSRS report to which I am passing a Start Date and End Date parameter but I keep receiving the following error:
Procedure or function 'MyReport' expects parameter '@startDate', which w...
Absorbed asked 24/8, 2015 at 19:11
4
I'm trying to execute an SSRS report in .NET Core.
Since .NET Core doesn't let you add service references, you have to use the WCF Connected Service to add a reference to the WSDL so it can genera...
Complainant asked 30/1, 2017 at 18:15
11
Solved
1.-I'm using reporting services and sometimes I get this error ASP.NET session has expired or could not be found when I try to load a report.
2.-I realized that I get this error when the Session.S...
Semiology asked 29/2, 2012 at 2:15
3
Solved
So I am running into the problem where my report header is being displayed on every page, but I only want to display it on the first page. The solution that people on this forum have given is to ju...
Phaeton asked 30/4, 2013 at 17:56
16
Solved
In my asp.net application, I am trying to open a particular report. I have the ReportViewer Control set with width of 100% and height of 100%. Now I expect that to mean that the report will take up...
Irrawaddy asked 22/4, 2009 at 19:4
2
Solved
I have a SSRS report with a single integer parameter.
Using Report Builder I've:
changed the parameter to allow null values.
set the default value to Null.
saved the report.
However, when the ...
Ulani asked 29/6, 2016 at 13:56
5
Solved
I am calling this rs.exe script to run and export the report:
rs -i RunReport.rss -s http://localhost/reportserver -u myUsername -p myPassword -e Exec2005
The error I get is:
Could not connect ...
Habitation asked 8/11, 2012 at 22:24
5
I installed Microsoft Reporting Services Projects VS2019 extention and ssdt based on this link on vs 2019 : https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-s...
Neoterism asked 7/5, 2020 at 17:56
4
Solved
How do you you display the running GROUP count via SSRS 2005?
I have a report that has n groups where the source data must remain anonymous and I want that number in the header of the group...
So...
Austronesian asked 12/5, 2010 at 13:56
7
Solved
We are in the process of migrating our reports from Crystal Reports to SSRS. In Crystal Reports we use variables to dynamically generate our filenames so when the report gets sent out via email, th...
Thermos asked 7/9, 2012 at 21:8
3
Solved
My dataset currently has 12 rows of data. Each representing data for a month. I would like to have variance of a column between to rows, the rows being last & last but one i.e., latest month an...
Rhnegative asked 4/11, 2011 at 3:48
5
Solved
Is it possible to render .rdlc reports with ASP.NET Core? Currently this only seems to be possible if I target the .NET Framework as opposed to .NET Core.
I don't need a report viewer I just need ...
Registrant asked 28/2, 2019 at 18:51
3
Let me specify the environment. The client has UI for entering orders in SQL Server database. A Windows Service one another machine is processing these orders from database at particular intervals....
Schofield asked 1/7, 2010 at 20:53
9
Solved
Is there a way to put a SQL Server Reporting Services report viewer control on an ASP.net MVC view? If not...what is the best way to accomplish this?
Pipestone asked 9/11, 2010 at 19:50
2
Solved
How does one dynamically load a new report from an embedded resource? I have created a reporting project that contains a report as an embedded resource. I added a second report file and use the fol...
Delta asked 2/10, 2008 at 15:24
5
I want to change the Datetime parameter to DDMMYYYY format.its default value is MMddYYYY.when user will select date from date picker the date should be display in ddmmyyyy format.
I tried all expr...
Hyoscyamus asked 21/4, 2015 at 14:29
9
Solved
I'm trying to pass a userId (string) in the URL which will be passed to the database and used by a query in SSRS.
base URL:
http://blah/Reports/Pages/Report.aspx?ItemPath=MyReport
I tried this, bu...
Disremember asked 3/7, 2009 at 11:4
5
Solved
Using SQL Server 2008 Reporting services:
I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so
DECLARE @Results TABLE (Number int
,Name n...
Washroom asked 23/4, 2010 at 15:0
3
Solved
I am trying to connect to Datasource but getting this error:
An error occurred during local report processing.
An error has occurred during report processing.
Cannot create a connection to data ...
Tarazi asked 13/1, 2017 at 11:5
6
Solved
I have a question according to SSRS.
I am working with MSSQL Server management studio 2012 and BIDS Visual studio 2008 for the report design.
I have a report with some multivalue parameters and a...
Eustazio asked 27/8, 2013 at 9:4
3
Is there a way to add in custom http response headers to the response from SSRS?
Something similar to adding the following to an IIS web.config file? I tried adding it in C:\Program Files\Microso...
Wilmer asked 16/5, 2017 at 17:30
6
Solved
I am new to using SSRS. I am using a .rdlc file for report generation in a PDF with VS 2012. When I tried to set the parameters like
ReportParameter param = new ReportParameter(kvp.Key, kvp.Value)...
Toniatonic asked 24/3, 2014 at 4:56
8
Solved
I'm having a very peculiar issue with SQL Server Data Tools 2012. Whenever I attempt to launch the report previewer, I get the following exception:
There was no endpoint listening at net.pipe://...
Huynh asked 7/8, 2014 at 17:20
5
Solved
I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it...
Queer asked 4/2, 2011 at 13:13
© 2022 - 2024 — McMap. All rights reserved.