|
Sponsored Links
Resources
.NET Research Library
Get .NET related white papers, case studies and webcasts
|
News
News
News
|
Messages: 1
Messages: 1
Messages: 1
Printer friendly
Printer friendly
Printer friendly
Post reply
Post reply
Post reply
XML
XML
XML
|
 |
TechTalk: Jason Carlson
Jason Carlson talks about SQL Server Reporting Services including how reports are developed and that while the designer is integrated into Visual Studio, that Reporting Services is not a developer only tool. He also discusses features of the products such as the use of XML and it's ability to generate XML as a data source for other processes and the user of user defined types in SQL Server 2005.Reporting Services, SQL Server 2000 version, the development environment for reports is inside Visual Studio 2003. You do not necessarily need to be a developer to use the tool, but of course, Visual Studio has a developer flavor to it. It is designed for developers. When building reports, I have demonstrated this many times you do not actually have to write any code. There is no code necessary, it’s a drag and drop metaphor . We have found from our usability studies that people who use Access, for example, find it very comfortable to build reports using the designer as part of Visual Studio. Is it targeted at non-developers? Because of the Visual Studio integration, you do need to understand some of the interesting aspects of development. But it also provides a lot of power. So the ability to check things in and out of your source code control system, integrated with your application, would definitely cater to the developer. That is not to say the architecture is actually built for the developer. The Reporting Services architecture, the server, the client, the output formats are all targeted at people to be able to consume reports, and build reports, from many different types of tools, and in fact we have third parties that provide tools that are not inside Visual Studio. In discussing the use of XML in Reporting Services, Jason points out that the reports themselves are defined in XML but also that the output of a report can also be XML to be used as input to another process.Yes, you can actually define within the report definition what that XSD will look like based on the structure of the report you put together. It’s kind of interesting actually, thinking of a visualization, a report layout in terms of the data you want to expose, not in terms of the actual visual aspects of it, whether it is rows and columns or a chart, but actually thinking: I want to have this data element coming from my database, and I want its element name to be X, or its attribute name to Y, I want it to be element centric or attribute centric, I want to eliminate this level in the hierarchy, I want to add this new level or collection in the hierarchy, and think about it in those terms and then deliver that XSD in that XML file. The good thing is you can actually do both at the same time. You can define a report as both visual, delivering something very valuable to a manager or a business person as well as providing very rich data, maybe to your partners. Watch the entire interview here.
|
|
|
Message #152872
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
interestig interview
thanks for posting the interview. After reading it, I had some questions. It appears the new reporting services uses SQL and not OLAP. Is there a particular reason for that?
Having done quite a bit of data mining the last two years and using OLAP, somethings are faster with Sql like select distinct, but other things are much faster using OLAP. Is there a plan to use OLAP as the primary engine for reporting? The reason I ask is because it would be simpler for users to view reporting/reports by dimensions.
there are third party tools that provide this functionality already.
peter
|
|
|
| |
|
| New content on TheServerSide.NETNew content on TheServerSide.NETNew content on TheServerSide.NET |
|
|
Language "mashups" will become more prominent, and developers will become polyglots, one programmer suggests.
SearchWinDevelopment.com offers an introduction to the language, performance, testing and data management improvements in VS 2008.
VBCode.com code snippets cover all aspects of application development, from data binding to security to the user interface.
Get up to date on XAML best practices with a variety of articles, tutorials and webcasts. [SearchWinDevelopment.com]
One team's experience with the VSTS DB edition suggests that it can improve workflow for dev teams. It also enhanced Agile efforts.
(June 24, Article)
Microsoft has begun to include DSL tools in the VSTS kit. A new book by Steve Cook and other VSTS team members helps set the stage.
(June 24, Article)
Cartoon: Be it ever so humble there is no place like your home after you get a Microsoft Home Server .
(June 18, Cartoon)
Microsoft's Thom Robbins says new technology to highlight in NET 3.5 includes AJAX, LINQ for both C# and VB, as well as tooling enhancements intended to ease the task of building WPF, WF and WCF apps.
(June 29, Podcast)
Venkat Subramaniam discusses AJAX bottlenecks, the tenets of Agile development and more. He spoke at the Ajax Experience.
(June 25, Tech Talk)
In the second of a two-part series, Michele Leroux Bustamente discusses design decisions related to the claims-based security model. Read the story and walk through the process for creating a set of claims-based utilities to encapsulate claims authorization at the service tier.
(May 24, Article)
Understanding why the Entity Framework exists and learning where it can fit into your projects can get you prepared for the eventual release early next year.
(May 10, Article)
Resource: This learning guide gives you quick access to useful links on Windows Communication Foundation security information.
(April 24, Article)
TSS.NET's Jack Vaughan spoke recently spoke with Microsoft's Brad Abrams to find out what he is seeing in the field and what the chefs in Redmond are cooking. Along the way he discusses patterns of AJAX frameworks.
(April 11, Article)
In a two-part series, Michele Leroux Bustamente explains how claims-based security is supported by WCF, and how you can implement a claims-based security model for your services.
(March 29, Article)
Windows Workflow Foundation is a new technology that many developers will need to get their heads around. In a brief excerpt adapted from Programming Windows Workflow Foundation: Practical WF Techniques and Examples using XAML and C#, K.Scott Allen considers aspects of workflow definition.
(March 22, Chapter Excerpt)
|
|
