Filters in request form

Dneal

Hi all,

I have created fields on the request form that I will be using has filters for different tables. Is there a way to have these fields behave like the field selections on the dataitem tab? I want to be able to use ..,>,<,<> and =.
Is this possible?

Thanks!

Dneal

ara3n

you can add a dataitem at the bottom of the report. You can use this to as a dummy dataitem to get the filters, On prereport you copyfilters to a global variable. Onpredataitem of these add currreport.break;

Dneal

That's a great idea! I'll give it a go.

Thanks kindly!

Dneal

Dneal

I used a dataitem of integer. Only number is available for the ReqFilterFields. How do I put the needed filters on this tab?

Thanks again,
Dneal

ara3n

you need to use the actual table not integer table

Dneal

Oh, I misunderstood. I have 5 tables in this report, the customer doesn't want to see 5 tabs. They want one tab, which is why I'm using an option tab with global varibles. I thought you meant I could use a dummy table for all the fields, and do it in one tab.

I'm still trying to figure out how I can get the fields on the option tab to behave like the filters on the dataitem tab.

Any ideas?

Thanks,

Dneal

Dneal

Quote:
Any ideas?


Read documentation (Application Developer's Guide, Development I, Development II). All answers are there.

I appreciate your response, as obvious as the solution you gave was however, I have read development I and II along with the Application Designers Guide. I can't find anywhere that lets me make the field behave like a filter in the tab.

Dneal

markborges

Did you try to put all those fields from those 5 tables into a single table, and used it as a dummy catch dataitem?

I think this would be very complex, but, if it's really necessary, this could work for you and your customer unbelievable request.

Dneal

Your idea does give me a solution. I'm starting to see that this is going to be complex. I will go back to the client to let them know how involved this request will be.

Thanks for your suggestion! If they go ahead I will have a way to proceed.

Thanks again,
Dneal

ara3n

Hello Dneal.
Please take a look at report 10028. On Option tab there is an example for budge filter. basically there view things that you need to change on text box property.

TableRelation. Copy and paste from actual field.
ValidateTableRelation := No
ClearOnLookup := No



Also on OnValidate()
"Acc. Schedule Line".SETFILTER("Budget Filter",BudgetFilter);
BudgetFilter := "Acc. Schedule Line".GETFILTER("Budget Filter");



The sourceexp is BudgetFilter;

Hope this helps.

Dneal

Thanks ara3n! That is exactly what I was looking for. =D>


Dneal

ara3n

You are welcome. :P

DenSter

@ Dneal: some people should just be ignored don't get annoyed with them, it'll only cause stress.