Chapter 30 questions and Issues

fbuxo · April 29th, 2012, 09:36 AM

THANK YOU!!!!!!

christhecoder · April 29th, 2012, 10:39 PM

No worries.

fbuxo · April 30th, 2012, 06:12 PM

Hi Chris, the only thing left for me to finish the report application is to be able to do the following:

I have two related tables. The report dataset table has an integer field called Customer(many) and it is linked to another table called Customers which has a primary key called CustomerId(one) and that same table has another field called CustomerName. I want to be able to show in my report CustomerName. How can I do it? Please advise, thanks...

Dataset is based in an Entity Model, but I could do it from a dataset if necessary. Thanks again..

christhecoder · May 1st, 2012, 12:49 AM

There's 2 options. One is to simply include that related object in your query using the Include method (see the Navigating Entity Associations section in Chapter 29 of the book), and then use dot notation in your report to get to the property or properties you need. Alternativately, you can create a collection of anonymous objects, including the related field in the objects, like so:

var query =
from order in context.Orders
select new
{
OrderId = order.OrderID,
OrderDate = order.Date,
CustomerName = order.Customers.CustomerName
};

fbuxo · May 1st, 2012, 10:41 AM

When I choose the dataset from the report.rdlc design (New-Dataset...), a window comes up for me to be able to choose a New Dataset. Once I choose the DataSource, then I need to choose a dataset from "Available datasets" dropdownlist. I'm choosing a dataset based on a stored procedure in EF , GetTest(). What I need is that the related field appears in the fields list so that I can bind a report textbox to that related field. I sent you an email showing graphically.Please advise. Thank you very much.

fbuxo · June 6th, 2012, 03:42 PM

My subreport is working with Entity data. How would it be to have it working with a typed dataset? This is the code I thought would work but it isn't, please advise. GetData() is the name of the table adapter select procedure in the dataset. Thank you very much!!!

Code:

Private Sub ProcessSubreport(ByVal sender As System.Object, ByVal e As SubreportProcessingEventArgs)
        Dim cylinderid As Integer = Convert.ToInt32(e.Parameters("CylinderID").Values(0))
        Dim Context As New TestsDataSetTableAdapters.CylindersTableAdapter

        Dim qry = From cylinder In Context.GetData
        Where (cylinder.CylinderID = cylinderid)
        Select cylinder


        e.DataSources.Add(New ReportDataSource("DataSetC", qry))
    End Sub