Filtering Report from Form inside the report

[aussiegirl]

I have created a application which will create a new report or edit existing reports, within these reports I have created a Form which I would like the users to use so that they can filter the report to how they want to see it.

I have a Combobox for the Customer so it picks up the Customer name from the Customer datasource
I have a Combobox for the Job Number and it picks up the Job number from the Jobs datasource
I also have two date time pickers for a range of dates that they can choose from

I would like the report to be filtered by the selected index of the combo box or the date values on the DataSales band on the report. I have tried looking at some of the previous forum questions but none of the them seem to work for me.


I cannot seem to change the Script to VB as I get the error message "Keyword is not valid" I think it's because the database I'm using has a column called Date in a couple of the tables which might be causing this issue

Thank you

[Andrew]

Hello,

Please run the Demo.exe and select the Prameters from dialog forms reports template from the SQL section.
Please also see the following sample project www.stimulsoft.com/private/SqlParameters.zip .

Let us know if you have some additional questions.
Thank you.

[aussiegirl]

Hi Andrew

I couldn't open the zip file because it must be C# I use VB..

I think you may have misunderstood what I'm trying to achieve, the examples that are in the Demo create the parameters from the VB application. I want to get the Parameters from the built in Form on the report itself, I can get these to display in the Report Header band, but I can't get them to be in the Filter section of the band

I have attached the Report, may you will be able to see what I mean

[Anton Lozovskiy]

Hello,

We converted the project for you in VB. Please see it.

Thank you.

[aussiegirl]

Hello

There is no Form in this Report.mrt file.

So I assume that you cannot directly Filter the Report from the Forms values?? You can only Filter it from the Databand itself or create the Form in my VB Application

Is this correct??

Hello,

We converted the project for you in VB. Please see it.

Thank you.

[Jan]

Hello,

Please run the Demo.exe and select the "Parameters from dialog forms" report template from the SQL section. This report demostrate how to create form inside report and use entered values in filters.

Thank you.