- Adam Cogan
- SQL Server User Group
- Chief Architect
- Runs teams of developers
- Present .NET User Group, .Sydney
- Speaker for Microsoft Roadshows, Dev Conn, VSLive
- Microsoft regional Director, Australia
- VS.NET (resolution: Report Builder)
- Security not very definitive (resolution: make everyone Admin. Preferable make Security Model same as SQL Server)
- Lack of control over interface (e.g. Textboxes don’t break over pages).
- Easy way to put the RS box on the web
- IIS on the RS box
- No CSS
- Data Bars
- Dev, Test, Production
- Automated Deployment
- Report Builder
- Web Site (Report viewer control)
- Emails (aka Subscriptions)
- Good when:
- Faster to develop read-only reports
- Has a designer – non .Net developers needed
- No code – maintenance is easier
- Groups and totals is easier (in ASP.Net you would need to iterate…)
- Bad when:
- Parameters – forced to use built-in controls
- Query string – when you change the parameters and refresh a report, the values do not appear directly in the query string
- Can’t separate SQL in to a strongly-typed dataset or middle-tier object like in ASP.Net – if worried about it use stored procs
- Can edit data
- Control over parameters e.g. you can page through months using a hyperlink
- Can use query strings to pass parameters for easy URL creation
- Higher development time
- No graphs
- Install, Install, Open Folder
- Deploy Adventure Works OLAP
- Deploy Model
- Tip: When should this deployment story be sorted?
- Think about being Larry King before an interview…
- Import Reports
- Save and Interop with SSQ Access Reporter
- Tip: Export your report to PDF and do a print preview, so you don’t have to print a lot of testing pages to find out the best page settings.
- Or do you use expressions to show the correct scale on charts?
- Or do you use red for negatives for charts in tables?
- Do you use de-normalized database fields for calculated values?
Other related posts:
GeekPost Weekly Newsletter Volume 4 Issue 7
MSDN Unplugged Roadshow Wellington
Right Sizing Agile Development - MSDN Magazine Webinar
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.