I have been searching for the ability to store a calulated value in i view, but so far I have only found that in DataPages.
More spesific, I have made a huor registration table, then a view as a source for the DataPage to report these hours.
In the report,, I want to group hours by year, month and project, but the only values I can group by is the data that are already stored (and not the ones calculated in the DataPage).
The only solution I can think of at the moment would be to calculate month and year in the registration DataPage, and then store the values in the hour Table allthough this really is a violation against normalization. (I don't consider it a vioaltion to store it in a view).
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Parma2015
Hi!
I have been searching for the ability to store a calulated value in i view, but so far I have only found that in DataPages.
More spesific, I have made a huor registration table, then a view as a source for the DataPage to report these hours.
In the report,, I want to group hours by year, month and project, but the only values I can group by is the data that are already stored (and not the ones calculated in the DataPage).
The only solution I can think of at the moment would be to calculate month and year in the registration DataPage, and then store the values in the hour Table allthough this really is a violation against normalization. (I don't consider it a vioaltion to store it in a view).
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.