Static data within report - changed only once a year, used in Calculat

[Tiina]

Hello there,

Trying to find out how to enter data such as :

Date ranges (up to 3)
% (up to 3)
Amounts (more then 3)

That would only be changed by the client once a year, but it's used for calculating other formulas in the report.

Parameter fields have to be entered every time, is there a way to make a semi-permanent parameter that is only changed when user requests it?

Is there a way using SQL Expression fields?

Is there a way using an Excel based table, I tried this but don't get the date fields to work.

Thank you so much,

Tiina

 

[lbass]

You could set these up as variables in a formula that you place in the report header and then in formulas in the body of the report, you would reference the variables instead of the values directly. Then the only update would be to the report header formula:

whileprintingrecords;
datevar range daterange1 := date(2006,1,1) to date(2006,4,30);
numbervar percent := 50;
numbervar amt := 12;

-LB

 

[Tiina]

Sounds good,

How do you use the formulas in the body to reference the variable.

Such that would display the date range: From 2006-1-1 to 2006-4-30.

Also, how would you use the numbervar percent within the other formula to calculate.

Thank you.

 

[lbass]

For the range display:

datevar range daterange1;
"From "+ totext(minimum(daterange1),"yyyy-M-d")+ " to "+
totext(maximum(daterange1),"yyyy-M-d")

For the percent calculation:

numbervar percent;
{table.price} * percent/100

Also (my mistake) remove the whileprintingrecords from the report header formula so that it reads:

datevar range daterange1 := date(2006,1,1) to date(2006,4,30);
numbervar percent := 50;
numbervar amt := 12;

Then you will be able to insert summaries on formulas in the report that reference the variables.

-LB

 

[Tiina]

It sounds really brilliant, I'll try it.

Thank you kindly,

Tiina

 

[Tiina]

Hi LB:

This doesn't work for some reason:
numbervar percent;
{table.price} * percent/100

What would the formula be for the amount?

Thanks again,

Tiina

 

[lbass]

You should be substituting your actual field for {table.price}. What is the calculation you want to perform? With what field(s)?

-LB

 

[Tiina]

Ok,

Next question

datevar range daterange1 := date(2005,01,01) to date(2005,02,28);
datevar range daterange2 := date(2005,03,01) to date(2005,12,30);
datevar range daterange3 := date(0,0,0) to date(0,0,0);
numbervar percent := 50;
numbervar amt := 12;

Can I also create percent1, percent 2 ect?

Is there a way to calculate # of days between daterange1?

Thank you,
Tiina

 

[lbass]

To add other values, just use the variable designation (numbervar, datevar, currencyvar, etc.) that matches the datatype of the field and then add a name that helps you understand what it is, as in:

datevar range salesdtrange := date(2006,1,1) to date(2006,1,31);

//etc.

For number of days in a daterange use:

datevar range daterange1;
datediff("d", minimum(daterange1),maximum(daterange1))

-LB

 

[Tiina]

Thank you LB, you are a genius,

Tiina