March 26, 2007 at 12:12 am
Can you please help me make a design decision? The requirements are that I have to regularly produce Excel spreadsheets that contain transactional performance information. Examples of this information would be:
1.) A count of transaction type X, Y and Z
2.) Of each of the above transaction types, how many had a response time under 2 seconds?
The Excel spreadsheets have to be laid out in a certain, unpredictable fashion (i.e. for transaction type X, the response time under 2 seconds should be shown in cell A10, the response time for transaction type Y should appear in cell D12, etc.).
And yes it has to be Excel.
It seems I have limited options. I either design an Excel spreadsheet with ActiveX Marcos that go directly to the data source and retrieve the data I’m interested in, or write a stored procedure that produces a csv spreadsheet which can then be imported in to Excel.
We’re using SQL Server 2000 and Excel 2000. I have access to development tools such as Delphi, but never found the Excel programming in
Dan
March 26, 2007 at 8:39 am
Please don't cross post.
Discussion here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=353763
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply