Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Math problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00612981
Message ID:
00613068
Views:
27
>>>Maybe this is too easy but at the end of the exspression you can say:
>>>
>>>Whatever >= (Cutoff -+*/ somenumber)
>>
>>I'm not sure, I understood. Anyway, I spoke with my manager and he explained what he was talking not about reports (which would be really hard to change), but about some program, which I use to generate a file, which then processed by our Production department. So, my task becomes much easier (I hope). I haven't checked it yet, though.
>
>Well anyway, what I meant to say was you can just add a calculation to the when expression of the report instead of hard coding it in the app. If cutoff needs to be changed by adding, subtracting, dividing or multiplying by some known value. (I sure you know that already)

Hi Eric,

I guess, I didn't explain my problem well. Now it does not really matter, since the requirements changed, but here is a problem:

I have three complicated reports with lots of defined variables and fields with print when condition. One of the report variable is cutoff. All other variables used this variable inside of their expressions. CutOff determines, that I would print, say, top "n" lenders, who has their Market Share greater than CutOff (0.2 or 0.05). Obviously, this "n" number will vary from town to town, county to county.

Now, let's change the report definition. We want to always print predefined number of lenders, say, 1 or 3 no matter, what's their Market share is (e.g. top 3 lenders). So, my print when expression would change this way:
RankNumPur<2 (for printing just one lender). But, I would need to change the whole report (of course, I can open it as a table and hack).

My original idea was, is it possible to adjust CutOff variable to always have predefined number of lenders printed (this would mean, what I don't need to re-define the report). I guess, the answer is no, since two or more lenders may have the same number of mortgages.

Anyway, I'm glad, what my manager was talking not about report changes, but about some special program changes, which is much easier...
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform