Page 2 of 2
Multiple parameters
Posted: Tue Jul 08, 2008 8:25 am
by Edward
Please declare a variable "ClientListId" in the report's Dictionary. Type of the variable please set 'object'.
SQL query should like something like this:
select * from Categories where CategoryID in ({ClientListId})
Setting of the Variable must be done exactly as Brendan suggested:
report.Load(....); //Load Template
report.Compile();
report["ClientListId"] = "1, 2, 3, 4";
report.Show();
Thank you.
Multiple parameters
Posted: Tue Jul 08, 2008 8:37 am
by Edward
mir wrote:I've made a master detail report that shows the orders for every client. I have made also a total for every client, and now i want to make a GRAND TOTAL for all the clients.
Example (lets make a count of all the orders) : i have 3 clients. first client has 3 orders, second client 5, and the third one has 8. For every client i would make a count of the orders, and at the end of the report i would like to have a grand total count that shows the total number of orders, 3+5+8=16
Please place a FooterBand with a desired function (you can easily make it using the Summary-Wizard in the Text Editor of the text component) between Master and Detail databands. It is a trick.
Thank you.
Multiple parameters
Posted: Tue Jul 08, 2008 8:42 am
by mir
I must be a pain in the ass right now Edward, and I'm sorry for that.
I've tried your solution, but it SUMS up just the first order for every client. Now what ?
Again, I'm sorry :shame:
Multiple parameters
Posted: Tue Jul 08, 2008 8:56 am
by Edward
In that case please define the sum as follows:
Code: Select all
{Sum(MasterDataBand:DetailDataBand,MyDataSource.MyDataColumn)}
Thank you.
Multiple parameters
Posted: Tue Jul 08, 2008 9:13 am
by mir
It works ! :feelgood:
Thank you Edward for your time.
Have a good day !
Multiple parameters
Posted: Tue Jul 08, 2008 9:26 am
by Edward
We are working for you. Your success is ours as well.
Do not hesitate to contact us if you have any questions.
Our forum's community is always ready to help our new friends!
Thank you