By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,247 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,247 IT Pros & Developers. It's quick & easy.

How to store report's calculated field

P: 2
I have a extensively calculated field in a report which would take many queries to reproduce. I need to take the existing reports' calculated field and store data for further use.

Is there a way to accomplish this?
Sep 13 '18 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,494
Not easily no. Nor would I advise you to go that route of storing calculation results (Database Normalisation and Table Structures).

You should probably be looking at creating the data in a Query and referring to that from elsewhere when you need it.
Sep 13 '18 #2

P: 2
Under time restraint and need to do this temporary till I have the opportunity to create queries. Can you explain how I could store the calculated field? Thanks for any help.
Sep 14 '18 #3

Expert Mod 10K+
P: 12,366
It would help if you told us what this calculation consists of
Sep 14 '18 #4

Expert Mod 15k+
P: 31,494
Can you explain how I could store the calculated field?
Not easily no. As I mentioned earlier that's difficult at the best of times. Here, as Rabbit points out, you haven't even shared any basic information we could use to start thinking about your problem.

I still believe that, far from taking a short-cut, trying to save the calculated data will be more complicated, more convoluted, and will take more time, than doing it the standard way. I may be proven wrong if/when we learn the details of exactly what it is you're actually asking about, but I very much doubt it.
Sep 14 '18 #5

Post your reply

Sign in to post your reply or Sign up for a free account.