Using TypedView for SSRS Datasource

Posts   
 
    
Posts: 11
Joined: 29-Oct-2008
# Posted on: 23-Sep-2011 03:20:43   

LLBLGEN Pro 3 with .net 4.0 VS 2010 ASP.Net Website

I'm using a TypedView as the data source for a Local SSRS report (.rdlc file). From the RDLC designer, when I create the datasource I have the dropdown for the Datasource pointing to the LLBLGEN generated TypedViewClasses. This gives mulitple options for the Available Datasets dropdown, a Clone, 4 Select, a Copy and a CreateDataReader. (see sceen shot)

If I use the CreateDataReader all works OK. The problem is I cannot see any custom properties I have added to the Partial Class.

If I use any of the "Select" data sets I can see the custom properties OK but the report fails as the the RDLC designer sees multiple "Item" fields. (see screenshot) Duplicate field names are not allowed. I'm assuming that the Designer is seeing all the overloads for the "Item" as seperate fields. Is there any way around this?

Thanx Colin...

Posts: 11
Joined: 29-Oct-2008
# Posted on: 23-Sep-2011 03:26:23   

Screen shots of RDLC Datasource

Attachments
Filename File size Added on Approval
RDLC Designer.jpg 228,803 23-Sep-2011 03:26.41 Approved
daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 23-Sep-2011 08:08:00   

Two options:

A. Make your custom properties Columns of the TypedView, and use the datasource as CreateDataReader. Related threads: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8913&StartAtMessage=0&#49475 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=6254&StartAtMessage=0&#34422

B. Use the datasource as "Select", then edit the report definition in an XML editor and delete all "Item" fields. That should work.

David Elizondo | LLBLGen Support Team
Posts: 11
Joined: 29-Oct-2008
# Posted on: 26-Sep-2011 23:24:29   

Adding the Columns to the dataset by overriding the onInitialized method, then populating with a method after the fill works OK!

Thanx for your help simple_smile

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 27-Sep-2011 06:38:09   

ColinPBriggs wrote:

Adding the Columns to the dataset by overriding the onInitialized method, then populating with a method after the fill works OK!

Thanx for your help simple_smile

Good! You are welcome wink

David Elizondo | LLBLGen Support Team