This content has been marked as final. Show 4 replies
929929 wrote:Nothing i'd recommend actually doing.
Is there any way to build the view so it shows the data like above?
I think you'd be best served manipulating the data inside excel (writing code) to have it display how you need. That or migrate to a more sophisticated reporting tool, Oracle's freely available APEX comes to mind.
If it must be Excel try the other way around.
Take it just as an idea.
Start in Excel and save the required data representation as *.xml (I'm not sure which Excel has the ability to do that)
Then try to write an Oracle function which returns "that" xml (using as a template the *.xml stored by Excel).
No experience with calling from Excel (did it only once just to demonstrate a security breech to colleagues)
I'm not sure if a pivot table would work out. If the data is displayed in Excel the way I'd like it the process isn't finished yet. It's supposed to be just raw data coming in from the view. After that the intention is to use that data to create/calculate graphs and things like median % and other analyses in another tab page.
I'm looking for a view that can export the sporttest data of one specific sport (there are many different sporttests with different objecs in the Oracle DB) to Excel in the way i've described. So I'm free to use that loaded data to make standard formulas and graphs. Then, certain people can use those reports to inform the persons who took the sporttests about their performances.