How to make an SSRS parameter = a field from another dataset
pgunston
I am writing an SSRS report to create an invoice.
In my report, I have a dataset whcih runs the following query:
select Customer, Name, BillAddress, BillCity, BillState, BillZip from ARCM where ARCM.Customer = @BillCustomer and ARCM.CustGroup = 1
As you can see, I have a parameter called '@BillCustomer'.
I have another dataset which runs this query:
select Co, Customer, Invoice, TransDate, DueDate, PayTerms, CustRef from ARBH
Where Invoice = @Invoice
How can I change my report so that @BillCustomer does not need to be manually entered when I run the report however, it gets its value from the Customer field in the second dataset?
zhongxiao37
Could you change your Customer dataset to use the parameter @Invoice directly and change the query to
select Customer, Name, BillAddress, BillCity, BillState, BillZip
from ARCM where ARCM.Customer IN (
select Customer
from ARBH
Where Invoice = @Invoice) and ARCM.CustGroup = 1
Or using JOIN in above query.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How to display where the new middle is in recursive binary search
- Next: Why does saving a JavaScript regular expression to a variable produce different results when invoking the .test() method?
Related
Related Related
- 1
SSRS Putting field from executed Dataset as Parameter to Second Dataset
- 2
Is it possible to create a dataset from another dataset in ssrs?
- 3
Rending HTML from a dataset field in SSRS
- 4
SSRS: Call a dataset from a textbox with a parameter
- 5
SSRS Shared DataSet with Parameter
- 6
How to send parameter of a report to another? SSRS
- 7
SSRS Parameter update field
- 8
How to populate multi value parameter based on another parameter in SSRS
- 9
Create a dataset which is a subset of another dataset in SSRS
- 10
SSRS - Pass parameter from one drop down menu to another
- 11
How to pass all values of a field to a sub-report as a parameter in SSRS?
- 12
How to display a textbox in SSRS based on not null value in a column from dataset
- 13
SSRS: How to pass rowcount of a dataset from main report to subreport (child)
- 14
SSRS Dataset Field Refresh not updating for Tablix
- 15
SSRS Multiple Value parameter filter based on dataset
- 16
SSRS: Passing/Setting parameter to Dataset using Expression
- 17
Update field from ssrs
- 18
use estimates from proc glm to make prediciton on another dataset
- 19
How to make custom field from django field
- 20
How to make custom field from django field
- 21
SSRS 2012 Set a chart series legend from another dataset based upon the column name
- 22
How can I make a django datetime field dependent on another field?
- 23
SSRS expression - query from dataset, with group
- 24
SSRS expression replace NULL with another field value
- 25
SSRS take average IF value of another field is equal
- 26
SSRS passing multiple string parameter to another report
- 27
how to make a field of the class to be of the same type as parameter in constructor
- 28
Solr dismax: How to specify a field to make a search with the parameter 'qs'?
- 29
Solr dismax: How to specify a field to make a search with the parameter 'qs'?
Comments