thankQ Help
In this report we want to be able to select several ledger codes and payment types.
For this reason the parameters are going to be from the lookup tables.
1.Right Click on Parameters from Field List
2.Select Add Parameters
3.Enter a Name e.g. LedgerCode
4.Enter a Description e.g. Ledger Codes
5.Select String from Type
6.Click Supports the collection of standard values
7.Click Allow multiple values
8.Select sqlDataSource1 for Data Source
9.Select the Destination Code Lookup Table for Data Member
10.Select the Ledger Code value for Value Member
11.Select the Ledger Code value for Display Member
12.Click OK
13.Repeat the steps to create a Payment Type parameter with the lookup table
14.Click and then Right click on sqlDataSource1 from Report Explorer
15.Select Manage Queries
16.Click on the … ellipsis beside View_DonationsSourceDestination at Manage Queries
17.Click Run Query Builder
18.Click Filter on the Query Builder form
19.Make sure there is a tick in the box beside Select only so only the top 100 records are selected while testing
20.Add a filter for the Ledger Code and Payment Type binding them to the parameters
21.Click OK on Filter Editor
22.Click OK on Query Builder
23.Click Next on Query Editor
24.Click Finish on Query Editor
25.Click OK on Manage Queries
26.Save the report
27.Click Print Preview tab
28.Select a Source code and Payment Type and click Submit
Example of Report
