automatic rename of computed columns

Hi,

i have a report with more than 100 computed columns. Everytime I want to edit the dataset, the computed columns get a new automatic generated name. Please help me!

Find more posts tagged with

Comments

mwilliams

Hi Ulf,

I'm not sure I'm understanding correctly. Can you explain in a little more detail? Your computed column names are changing on their own?

Ulf

Hi Michael,

in our application we use computed columns for the correct view of prefix and suffix. For example:

Prefix:
if(row["PCA_DOSE_LIMIT_HLL"] != null){
if (BirtStr.indexOf( ".",row["PCA_DOSE_LIMIT_HLL"].toString())==-1){
row["PCA_DOSE_LIMIT_HLL"].toString()}
else {
BirtStr.left(row["PCA_DOSE_LIMIT_HLL"].toString(),BirtStr.indexOf( ".",row["PCA_DOSE_LIMIT_HLL"].toString()))}
}else{
"

"};

Suffix:
if(row["PCA_DOSE_LIMIT_HLL"] != null){
if ((BirtStr.indexOf(".", row["PCA_DOSE_LIMIT_HLL"].toString())+1)==0){
""}
else {
BirtStr.right(row["PCA_DOSE_LIMIT_HLL"].toString(),(BirtStr.charLength(row["PCA_DOSE_LIMIT_HLL"].toString())-(BirtStr.indexOf(".", row["PCA_DOSE_LIMIT_HLL"].toString()))))}
};

After I created the computed columns. I've refreshed the dataset. Everything fine till now. But when i try to edit the dataset again, every computed column gets a suffix, for example:

before the computed column has the name cp1, after editing again the computed column has the name cp1_175, then cp1_175_175 and so on.

mwilliams

Ulf,

Is this something you think you can reporduce with the sample database so that I can run it and see it?

Ulf

Hi Michael,

now I use JavaScript inside the report instead of computed columns. So the problem is not really solved, but I have found another solution.

Regards
Ulf

mwilliams

Ulf,

Glad you found a way around the issue. If you can reproduce the issue with the sample database, I'll gladly take a look at it. Let us know whenever you have questions!