CODEWITHSUNDEEP
sqlsql-serverssms
CoderBrien
CoderBrien

Reputation: 693

Barebones dynamic report tool for SQL?

[Ms SQL]

I've got some data dense sql queries that I view the results of through the SSMS u/i in the datagrid.

The queries are saved as stored procedures that select multiple result sets.

I would like to be able to control the grid formatting a bit more (eg override column widths, decimal formats, right justify numbers, etc).

Is there an alternative to SSMS that would give me more control of the data presentation? It needs to be dynamic and not require a bunch of coding to display a new query (lots of sql work is ad hoc data exploration).

Upvotes: 0

Views: 48

Answers (2)

Clay
Clay

Reputation: 5084

I suppose it depends entirely on what you're already comfortable with. Winforms + DataGridView controls inside TabControl objects are really easy to set up. Mostly you just bind the data to the DataGridView controls and they do the right thing based in data types. DataGridView has a virtual mode if your data is real freaking big (gives you control over paging, etc)..but this requires actual code. Old, easy and pretty robust if you're on windows UI...which is assumed given you're into the SSMS UI. Minimal C# or VB.Net required.

Upvotes: 1

Eric
Eric

Reputation: 703

You can set up a data source in an Excel workbook, as long as the dataset isn't too huge.

https://blogs.office.com/2010/06/07/running-a-sql-stored-procedure-from-excel-no-vba/

You could also use SSRS, but Excel would be the fastest way to get going. SSRS is a little more work and probably not what you're looking for.

Edit - you said it returns multiple datasets. I'm not sure that Excel can handle that properly.

Upvotes: 1

Related Questions