We have a number of reports that run out of our batch system behind data loads. There have been some recent updates. Previously, we have only one account type, so the parameter was just a single-value text value. We now use a multi-select parameter, and am getting an error when we attempt to run in batch although it runs properly through the web interface. I've captured the command line from our batch system:

\\xxx.com\share\CM\DEV\OPS\Apps\SSRSReportBuild\SSRSReportBuild.exe "Report=Solutions/ZZ-XX-12345-AccountAuditReport" "FileName=FCT-ZZ-XX-12345-AccountAuditReport.rdl" "MaxRunTime=1800" "Path=\\rpt2webtest\MFTest" "pAcctType=ABC,XYZ" "pAcctTypeList=ABC,XYZ" "pRunDate=20190906" "pRunType=D" "Render_Format=EXCEL"

Select all Open in new window

When executed, the job fails with this error:

System.Web.Services.Protocols.SoapException: This report requires a default or user-defined value for the report parameter 'pAcctType'. To run or subscribe to this report, you must provide a parameter value.

Select all Open in new window

Any suggestions of how to correct this and properly pass the value for pAcctType, a multi-value parameter?

Some of the questions that might come up

• The source of available values for the multi-select parameter in the report is a SQL query.
• The values 'ABC' and 'XYZ' do exist in the data.
• We cannot pass the same parameter name twice on the command line, as the API does not allow this and will generate and error (I mention this becasue some web searching I've done indicate that is how you pass multi-select values in the web interface (e.g. &pAcctType=ABC&pAcctType=XYZ...)

Hello:

I have attached a screenshot of the layout of my SQL Reporting Services report (SSRS report) in both the Design and Preview tabs.

As you can see, my issue is that EXTDCOST field does not appear (i.e. shows 0.00 for all records), even though data from the other three columns does appear.

The report and, therefore, the attached .rdl file pull data from a stored procedure which I have pasted below.

How can I get this one field to show data, without modifying this stored procedure.

Thanks!  Much appreciated!!!

John

ALTER PROCEDURE [dbo].[p_cis_seeHITB] @I_nSortBy TINYINT = NULL
	,@I_nReceiptOptions TINYINT = NULL
	,@I_sStartItemNumber CHAR(31) = NULL
	,@I_sEndItemNumber CHAR(31) = NULL
	,@I_sStartAccountNumber CHAR(128) = NULL
	,@I_sEndAccountNumber CHAR(128) = NULL
	,@I_sStartLocationCode CHAR(11) = NULL
	,@I_sEndLocationCode CHAR(11) = NULL
	,@I_nStartQTYType INT = NULL
	,@I_nEndQTYType INT = NULL
	,@I_dtStart DATETIME = NULL
	,@I_dtEnd DATETIME = NULL
	,@sStartClass CHAR(11) = NULL
	,@sEndClass CHAR(11) = NULL
	,@sStartGenericDesc CHAR(11) = NULL
	,@sEndGenericDesc CHAR(11) = NULL
	,@I_fUseGLPostDate TINYINT = NULL
	,@I_fIncludeZeroQtyItems TINYINT = NULL
	,@O_SQL_Error_State INT = 0 OUTPUT
AS

		
--testing
/* 
if object_id('cis_seeHITBParms') is not null drop table cis_SeeHITBParms 
Select @I_nSortBy SortBy
	,@I_nReceiptOptions ReceiptOptions
	,@I_sStartItemNumber StartItemNumber
	,@I_sEndItemNumber EndItemNumber
	,@I_sStartAccountNumber 

Select all Open in new window

…

Hi EE,

This question is more of a query looking for approaches to resolve the following issue:

The user has an SSRS 2016 report and filters the datasets efficiently with filters they have been given.

However, the user wants to save specific rows within the report to key the data into another system e.g Desktop application. Exporting initial the result set data to XML result is a simple task. My question is can you have a button on the SSRS which launches a subform that asks what rows /columns specifically do you want to save from the resultset in XML format.  Completing the necessary criteria on the subform, SSRS exports the data to the user via a download.  

Is this possible in SSRS if so are there examples out there?

Any links or tips, advice are welcome.

Thank you.

hi Can someone tell me if we have csv rendering format option for email subscription of ssrs reports?
as i want to email report only in csv format.

I want to deploy my SSRS reports on my local laptop. How do i determine what my TargetServerUrl should be?>

Management wants to know what employees are doing if working remotely. I would like to track and store their activity while they are connected to our work server via remote access.

I need to track all user activity such as select, insert, update and delete and put it into a table in order to create a report.

The Database we use is Microsoft SQL Server 2012.

we have migrated our SSRS 2014 Reports to SSRS 2016 . we have successfully deployed all the reports and data sources. However, the Report Subscriptions are not migrated .

can anyone help me how to migrate SSRS email subscriptions to 2016 ? I don't want to create them manually as there are loads of them.

Many Thanks

Hi EE,

I have a rather unusual problem I can only get either  Web Portal URL working or  Web service URL working but not both.

What is currently happening is if the web service URL and web portal URL match (virtual directory name is the name) the web service works but the web portal doesn't.

And if the web service URL and web portal URL have different (virtual directories) the web address for the web portal works.

Attached are pictures of my current settings.



Right now I can only see the web service working.

From the reportserver config file.

<URLReservations>
            <Application>
                  <Name>ReportServerWebService</Name>
                  <VirtualDirectory>Autumncareuatreport</VirtualDirectory>
                  <URLs>
                        <URL>
                              <UrlString>http://+:81</UrlString>
                              <AccountSid>S-1-5-80-4000206335-4242116595-3118339656-1734867201-556326921</AccountSid>
                              <AccountName>NT SERVICE\ReportServer$AUTUMNCARETESTRS</AccountName>
                        </URL>
                  </URLs>
            </Application>
            <Application>
                  <Name>ReportServerWebApp</Name>
                  <VirtualDirectory>Autumncareuatreport</VirtualDirectory>
                  <URLs>
                        <URL>
                              <UrlString>http://admin:81</UrlString>
                              <AccountSid>S-1-5-80-4000206335-4242116595-3118339656-1734867201-556326921</AccountSid>
                              <AccountName>NT SERVICE\ReportServer$AUTUMNCARETESTRS</AccountName>
                        </URL>
                  </URLs>
            </Application>
      </URLReservations>

Thank you
Web-Portal.PNG
Web-Services.PNG

SSRS rdlc with two dataset. The report prints a main textural record from the first data set.  The second data set prints related items to the first dataset as textural data.  Basically I'm creating documents.  I have two RECTANGLES and assigned the correct dataset to each. Inside each RECTANGLE I have a text box for the text and corresponding column data.  This works great if I am filtering on one set of data points; such as one record that relates to other records being in the second dataset.

Dataset1
name address owner

Dataset 2
occupant1
occupant2
etc...

I've been trying to keep them together but am running into problems.  I know how to deal with this developing RDL projects with sub reports; but can't seem to get that working correctly with RDLC. Is there anyway, given my current approach to group these correctly and print one record per page regardless of the grouping as well?

I have a background in computer programming including sql, access, cobol, vb for apps. I worked for a fortune 500 company generating reports with access at the time.  I have been a stay at home mom for the last 5 years.
I had minimal training 10 years ago in data warehouse. I took a couple of courses online and understand the fundamentals of using visual studio - creating a package with a data flow, defining the source and target, configuring the connection manager, linking table lookups to the reference tables in the warehouse. I brushed up as  i had an interview for a data analyst job that required ssis and ssrs ( I am familiar with reporting tools) - I did not put on my resume but it did state on the requirements. They want to interview me to trouble shoot failed packages. I can figure things out very quickly. However, I am not sure what type of questions they might ask that are more basic relating to ssis and ssrs. I was wondering if you might please be able to provide some basic questions regarding package failures or any questions that might help me get through this. Maybe I am over my head. Thanks again for your help