I have been looking at the answer to this question and need a bit of further detail. https://stackoverflow.com/questions/5972947/frequency-of-strings-in-an-excel-column-pretty-sure-this-requires-vbs
I want to set filter values in the Excel file using code and then the user will be able to download it.
Note: I would like to do this in a single SQL statement. not pl/sql, cursor loop, etc. I have data that looks like this:
Hi I have 3 pivot tables in same sh开发者_C百科eet and data source is danamically changing when refresh depend on the parameter value which is passing from the front end. It is a report and I have don
I am developing a roster application (asp.net with VB + sql server) to let user input shift duty record, proposed screen is as follows:
I am trying to pull three items from a table that have no relation to each other (other than the fact that they are sequential) and get them on one row.
All, I have a pivot table that uses a SQL Server table as it\'s source. The numbers are all typed on SQL Server as INTEGER or MONEY. However the excel pivot table formats them as dates when drilling t
I haven\'t seen a question like this, but if there is one out there that has been answered, please let me know.
Is there a way to view the 开发者_StackOverflow中文版details (the grain) in an OLAP cube in excel? I know excel can already show the measures that are aggregrated, but the users want to see the detail
Do there exist any (ideally free or open-source) tools for performing OLAP analyses on arbitrary tables in a relational database, without requiring any advance specification of dimensional hiera开发者
加载中,请稍侯......