.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to do a calculated series in 2008 R2?

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
An RDL from pre-R2 shows a calculated series section in the chart data context menu, however I can see no way to add a new one.  How?

View Complete Post

More Related Resource Links

Calculated Series Period


If there is less data than the period value for the calculated series then the entire chart does not render and I get the ugly message 'Formula error - There are not enough data points for the Period'.  Reducing the period to an artificially low value to prevent the error is pointless really.   The period value cannot be formula driven so what options are available for at least displaying the normal values, or perhaps paramaterising the period value?


[RS 2008 R2] Advice for Multi-series stacked chart



I need an advice about the layout of a multi-series stacked chart (which I hope is the correct way to realize my report). The data I need to draw has the following structure (aggregations have already been calculated in the database query due to the high amount of data):

Date             Priority    Value
2010-09-19   A             48
2010-09-19   B             50
2010-09-19   C             45
2010-09-19   TA A        11
2010-09-19   TA B        18
2010-09-19   TA C        2
2010-09-19   Total        143

The chart must contain Date on X axis, the Value on Y Axis and stack in the same chart area 7 different graphs according to priority field:
- 4 must be line graph (Priority = A, B, C, Total)
- 3 must be column graph (Priority = TA A, TA B, TA C)

Here follows the way I conceived the chart:
- Date field goes into Category Groups
- Priorit

Formulas used for Calculated Series

I'm trying to find documentation on what the formulas are that are used for the various selections for SSRS 2008 Calcuted Series.  In particular, the Performance formula appears to be based on the slope of the underlying data points.  But, what is the true calculation used?  I can not find this information anywhere (in MSDN and in searches).

Optimizing Data Mining processing time for a Time Series model in SQL Server 2008 R2


Does anyone have any references around optimizing the initial processing time for a data mining model? Books, blogs, etc. I have the Wiley “Data Mining with SQL Server 2008” book, and while I’ve learned a lot from it, it doesn’t seem to cover much around trouble shooting things like processing time. I also have a few other books that have a chapter or two on data mining, but again just basic “here’s what it is and how to set it up”, nothing that quite covers trouble shooting or optimization. I’ve also checked out the various Data Mining blogs/sites.


I’ve got a Microsoft Time Series model I’m basing on a Cube. Very simple, trying to forecast sales. I have one dimension which is the list of products (about 1600), a second which is the time dimension, finally the measure is daily sales figures for each, about 3.2 million rows in total. On a brand new server, with two quad core processors and 16 gig of ram it took 40 hours to process. Seems rather high?

Visual studio 2010 and SQL Express 2008 with advanced series


Hi I recently found out that you can only do full text indexing with the advanced series of SQL Express and I managed to download and install it on my machine.

My question is how do I integrate it with Visual studios 2010 so that I can do the full text indexing ?

When I installed SQL Express with advanced series 2008, it created an instance of SQL Server management studio so im wondering if I have to do it there and then move the database into my project or if I can do the full text indexing from inside my project

Anyone's help would be much appreciated

Chart display issue with Moving Average Calculated Series


I have successfully produced a line graph containing 2 data series; a count of events by month and a moving average (5 month period) of said events.

My problem is trying to limit the chart to show ONLY a certain period of time.  In order to generate the Moving Average (calculated series) I had to make the query go further back in time to count the previous months' events.

For Example:  Chart should display Jan2010 through Oct2010, EventsPerMonth (series1), MovingAVG (series2). 

At first it displayed back to the begining of the data which was Sept2009 - Oct2010.  I figured out how to cut it off at Jan2010 using the Horizontal Axis Properties > Scalar features.

Final issue: I need to get the first data point (Jan2010) off of the Y-axis as a starting point.  Basically I need to shift it one interval to right, leaving a space, so that there is no line connected between the data line and the Y-axis. 

This is difficult to discribe, I apologize if this isn't super clear. 

Thank you!


ASP.NET, HTML, JavaScript Snippet Support (VS 2010 and .NET 4.0 Series)

This post covers another useful improvement in VS 2010 - HTML/ASP.NET/JavaScript snippet support. Snippets allow you to be more productive within source view by allowing you to create chunks of code and markup that you can quickly apply and use in your application with a minimum of character typing.

Visual Studio has supported the concept of "snippets" for VB and C# in previous releases - but not for HTML, ASP.NET markup and JavaScript. With VS 2010 we now support snippets for these content types as well.

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.

VS 2010 and .NET 4 Series

VS 2010 and .NET 4 are the next major releases of our developer tools and framework. Together they contain a ton of new functionality and improvements that I think you'll really like, and which make building applications of all types easier, faster and better. The improvements range from nice small tweaks to major, major enhancements - and can be found across the .NET Framework, the languages, and the IDE.

GridView Sorting/Paging : 'REAL' AJAX with Asp.Net Series

This is a continuation of my 'REAL' AJAX with Asp.Net (not Asp.Net AJAX) series posts for those of us trying to stop relying on Asp.Net 'AJAX'.

Ok, nothing too dramatic to start things off, we are going to make some tabled data sortable and pagable all without using a bit of postback. Not only that, but it is going to be incredibly easy!

Free Series of SharePoint Workflow How-to Videos

This is the series of "How to" Document Workflow with SharePoint using Visual Studio 2008 (using the .NET Framework 3.0 for backward compatibility to Visual Studio 2005). I have created video's that show the most common requests that I have seen around MOSS/SharePoint 2007 workflow & document workflow.

Feature available to Silverlight 4 with VS 2010.

In Part I of this article series we have seen some features available to Silverlight 4 with VS 2010. We will continue to explore more in this article.

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Building Re-Usable ASP.NET User Control and Page Libraries with VS 2008


I am having problems with a user control. I want my solution to have a separate project for holding my user controls.

The main project can get a reference to this user control project and can import this user control dll into my main project. 

Thanks in advance,

Dheeraj Mittal


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend