How Do I: Display a chart built on aggregated data (Eric Erhardt)

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

nickmiller — Thu, 12 Jul 2012 01:15:08 GMT

To get this working with the _InstrinsicData database I had to add "Enlist=false;" to the connection string in the Web.config of the Lightswitch Server project. Not sure why...

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

nickmiller — Wed, 04 Jul 2012 11:34:36 GMT

Great walkthrough thanks, learned a lot.

Had to put the bar chart control in a separate project. With VS 2012 RC, I could not add a reference to it in the 'New Custom Control' dialogue when I put it in the Client project.

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

Todd Hyatt — Wed, 18 Apr 2012 17:12:09 GMT

Thanks Eric.

Here is the new class definition that fixed this implicit filtering.

Public Class RollupStatus

<Key()>

Public Property GroupId As Guid

<Key()>

Public Property StatusDescription As String

Public Property iStatusCount As Integer

End Class

As Eric suggested these dialogs are probably best suited for the discussion group so I am putting a plug-in here.

social.msdn.microsoft.com/.../threads

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

Eric Erhardt — Tue, 17 Apr 2012 21:55:12 GMT

@Todd - As we discussed offline, the issue is that the aggregate query is returning multiple rows with the same "GroupId". Thus, only marking GroupId as the Key for the RollupStatus class isn't enough. LightSwitch sees multiple rows with the same Key values, and discards what it thinks are duplicate records.

To fix this, you need to put <Key()> attributes on the subset of properties that will uniquely identify a row. In this case, you need to add <Key()> to the StatusDescription property in the RollupStatus class.

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

Todd — Tue, 17 Apr 2012 17:38:22 GMT

Eric,

Very good article, works great when summarizing to a single row. What if my summary is a grouping of more rows, I am only gettting the first row in my Screen when trying to summarize a group of orders by there order status.

<Query(IsDefault:=True)>

Public Function GetRollupByGroupId() As IQueryable(Of RollupStatus)

Return From od In Me.Context.Orders

Join st In Me.Context.OrderStatus On st.OrderID Equals od.OrderID

Group od By od.GroupID, st.StatusType.StatusDescription

Into Count()

Select New RollupStatus With {.GroupId = GroupID.Value,

.StatusDescription = StatusDescription,

.iStatusCount = Count}

End Function

End Class

Public Class RollupStatus

<Key()>

Public Property GroupId As Guid

Public Property StatusDescription As String

Public Property iStatusCount As Integer

End Class

Thanks again,

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

Eric Erhardt — Wed, 11 Apr 2012 18:53:28 GMT

I have added the project (both VB and C#) to the MSDN code gallery:

code.msdn.microsoft.com/Display-a-chart-built-on-eb631504

Enjoy!

Eric

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

张向亮 — Mon, 09 Apr 2012 06:34:43 GMT

Added:

can you send the project of the paper to me?? I would like to learn it.My mailbox is zxliang999@hotmail.com

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

张向亮 — Mon, 09 Apr 2012 06:21:34 GMT

Hello!

I have a trouble when I try to make a project according to method in the paper.The problem is as problem:

when I enter F5 to run the project and can succefully enter into the system,at this time,the problem appears in the search screen,the information is "TypeName Format of Custom Control is not correct".So I want to ask you that what's wrong with the project and how to solve the problem.

thanks!

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

ADefwebserver — Mon, 01 Aug 2011 17:49:55 GMT

I created a Blog that coveres this material with more screen shots for those of us who need a bit more help :)

lightswitchhelpwebsite.com/.../WCF-RIA-Service-Combining-Two-Tables.aspx

re: How Do I: Display a chart built on aggregated data (Eric Erhardt)

ADefwebserver — Fri, 29 Jul 2011 06:31:25 GMT

For a C# version see:

social.msdn.microsoft.com/.../6485f314-d9aa-4293-8725-0295304d8e3f