C# – Crystal Reports Subreport Using DataSets

ccrystal-reportsdatasetondemandsubreport

I use Crystal Reports XI with C# Visual Studio 2005.
I am trying to create a subreport from a summary dataset.
A simple example would be Company listing with Employees.
I load the Company dataset (with CompanyId).
I want to create a subreport which is linked by CompanyId whereby the dataset is loaded (obviously) on demand. I can create this subreport if I load all the detail into one monster dataset, but in my real-world implementation this would involve loading millions of detail rows (not an option).

Is there a way I can capture the SubReport event and load the dataset from my database connection? I basically want to intercept the subreport link call to build the dataset myself.

Best Answer

This is simply possible. Create 2 data tables in the xsd dataset you have. Get values for these 2 datatables based on a common ID/key value. Copy one dataset table to the other like

ds2.Tables.Add(ds1.Tables[0].Copy());

then,

rpt.Load(path + @"Report\Report1.rpt");
rpt.SetDataSource(ds2); //datasource is single
crystalReportViewer.ReportSource = FFrpt;

when ur adding subreport, get the second table as the datasource and its values. add those fields to your subreport, its done !

Regards Shyam

Related Solutions

C# – Should ‘using’ directives be inside or outside the namespace

There is actually a (subtle) difference between the two. Imagine you have the following code in File1.cs:

// File1.cs
using System;
namespace Outer.Inner
{
    class Foo
    {
        static void Bar()
        {
            double d = Math.PI;
        }
    }
}

Now imagine that someone adds another file (File2.cs) to the project that looks like this:

// File2.cs
namespace Outer
{
    class Math
    {
    }
}

The compiler searches Outer before looking at those using directives outside the namespace, so it finds Outer.Math instead of System.Math. Unfortunately (or perhaps fortunately?), Outer.Math has no PI member, so File1 is now broken.

This changes if you put the using inside your namespace declaration, as follows:

// File1b.cs
namespace Outer.Inner
{
    using System;
    class Foo
    {
        static void Bar()
        {
            double d = Math.PI;
        }
    }
}

Now the compiler searches System before searching Outer, finds System.Math, and all is well.

Some would argue that Math might be a bad name for a user-defined class, since there's already one in System; the point here is just that there is a difference, and it affects the maintainability of your code.

It's also interesting to note what happens if Foo is in namespace Outer, rather than Outer.Inner. In that case, adding Outer.Math in File2 breaks File1 regardless of where the using goes. This implies that the compiler searches the innermost enclosing namespace before it looks at any using directive.

R – Crystal Report subreport loses linked parameter on production server

What about the datasource on the subreport - did you change it to sync with environments?

Best Answer

Related Solutions

C# – Should ‘using’ directives be inside or outside the namespace

R – Crystal Report subreport loses linked parameter on production server

Related Topic