Copying SmartFields

[DBohner-(db)]

Hi All!

When working with Financial reports – is there a way to change the field/column type?

Here’s the issue:

A FASTR Conversion created a Financial report with FINRPTQ1 columns. We need to duplicate the report for the other quarters and YY. The issue is that there are about a dozen select criteria rows within each column. I really don’t want to manually address each row in the column select criteria – If it is possible to change the smartfield type (without losing all the selects) – that would be a dream.

The other ‘dream’ would to be able to copy the selects to a new smartfield (is that possible???)

(db)

 

[artur_urban]

You don't have to manually address each row in the column select criteria. You can change the smartfield type without losing all the selects. Go to column ER, event Do Variable and find BSFN doing current calculation. Just replace it with needed BSFN. Be careful about parameters you pass in. Good way is to add a temporary Smart Field to a report with needed BSFN and copy BSFN to your column. That way you have a BSFN with right parameters and you just replace 1 or 2 parameters if needed. Then a temporary Smart Field can be removed.

 

[DBohner-(db)]

Artur,

Thanks for the reply - the example of creating the 'dummy', to use as
the example is an excellent idea (to maintain the correct parameter
mappings)

Thanks!

(db)
--