How do divide ALL my numbers by 1000?

[Razor1973]

Subject is self-explanatory, but I will provide more details.

I have created a set of reports and my client now wants to see all figures in thousands. Dividing the amounts at the data source is not an option, before this is suggested. Long story.

I have had no choice but to create ONE FORMULA PER NUMBER on my report and divide by 1000. Actually, I created a function called {@Scale} that only returns 1000 and I am dividing by that function, just in case they change their minds. I could always go change the value of my {@Scale} formula.

This is an extremelly tedious job, to say the least. I have created 80+ formulas in one of my reports and I still have many more reports to go. Obviously, this increases the margin for errors.

Can you recommend an alternate solution to this problem?

 

[satinsilhouette]

What version CR are you on? Do you have access to the repository on the BOE Server? If so I would create a custom function that would handle this formula for you, then you just apply whatever field you need to to that CF and you wouldn't have to re-write it over and over.

I am curious as to why you think you have to write a separate formula for each number?

Thanks so much!
satinsilhouette

 

[Razor1973]

Thanks for your feedback, satinsilhouette.

I apologize. I am using CR XI SP2.

We do not use a repository or BOE server. Also, as I said in my original post, dividing the amounts at the data source is not an option. I am not using an ODBC connection to a database where I can create views. I am using a connection to a proprietary OLEDB provider we have absolutely no control over. The way the data is returned is the only way the data can be returned, so all the work needs to be done at the Crystal Reports end.

In these circumstances, what option do I have other than having to write a formula for every single amount on my report?

Thanks again!

 

[Razor1973]

By the way, this scarlet person is up to something -->

http://www.dbforums.com/showthread.php?p=6231866#post6231866

 

[Razor1973]

Actually, that was it! Go to that thread if you're interested in the solution.

Thanks!