2 technical SQL questions
Posted: November 5th, 2005, 1:29 pm
Hello everyone,I am building a simple reporting system and came upon 2 difficult issues. I tried asking those technical questions on 3 SQL forums and did not get a satisfactory answer. So I come here - after all it might not be just SQL but a different solution The problem is that I have lots of reports in various Excel workbooks, some of them static, some dynamic (pivot-Access-based, menu-based etc). Plus the charts, where neccessary. I want to integrate those. First, I decided what needs to be done in VBA. The rest is template-based, with a single query to Access and and almost straightforward dump to Excel. I have 2 problems:1) sometimes I need to pivot the data and put a static version (not pivot-based) on one of the sheets2) Like4Like needs to be calculated automatically for given parametersI attach 2 sheets that illustrate those problems.On a more general level - maybe I just need to train the users of those reports in pivot tables and there - problem solved. Not entirely though, since some of the calculations are a bit more sophisticated and one would have to possess both good Excel and SQL skills to produce them quickly. I think some automation is good even if it were just for the sake of time and, probably, coherence.I would appreciate any suggestions.Cheers,Kuba