Creating reports and dashboards | Stimulsoft community forum

I have a Report which has two bands (master and child) one below another. Both bands have columns in them. When I try to execute this Report, it hangs with message "Connecting to Data". However if I run the same report by removing the child band by keeping the columns on Master band, it works fine. The report also works fine if I don't place columns on both bands. But as soon as we place columns (3) on both bands, the reports starts hanging. One more data point is that if I remove relationships between master and child band, then the reports works fine as well. Please help.

The report is attached below: -







Master File

nmfuid,ID,System.Int32


nmfid,Reference_x0020_ID,System.String


nmflast,Last_x0020_Name,System.String


nmfspcf,First_x0020_Name,System.String

Data.nmf

nmf


Home



nafzip,Zip_x0020_Code,System.String


nafstate,State,System.String
nafnmfuid,ID,System.Int32


nafcontry,Country,System.String
nafcity,City,System.String


nafadd2,Address_x0020_2,System.String


nafadd1,Address_x0020_1,System.String

Data.Home

Home




Master File

nafnmfuid



nmf

nmfuid


nmf_Home






ReportOptions,PrintBannerPage,PrintBannerPage

,System.Boolean,,False,False


ReportOptions,UpdateAccounts,UpdateAccounts,S

ystem.Boolean,,False,False


ReportOptions,Copies,Copies,System.Int32,,Fal

se,False


ReportOptions,AsOfDate,AsOfDate,System.DateTi

me,,False,False


ReportOptions,PrintedBy,PrintedBy,System.Stri

ng,,False,False







None;Black;2;Solid;False;4;Black
Transparent


Transparent


8.1,0.6,0.6,0.2

Arial,8
0,0,0,0
Text6


{Home.nafstate}
Black



Transparent
False


0,0.2,7.49,0.3
3


Transparent


0,0,0.7,0.2

Arial,8
0,0,0,0
Text1


{nmf.nmfspcf}
Black



Transparent


0.8,0,0.7,0.2

Arial,8
0,0,0,0
Text2


{nmf.nmflast}
Black




nmf
Top



True


False


False
DataBand1





Transparent
False


0,0.9,7.49,0.4
3


Transparent


0,0,0.8,0.2

Arial,8
0,0,0,0
Text3


{Home.nafadd1}
Black



Transparent


0.8,0,0.8,0.2

Arial,8
0,0,0,0
Text4


{Home.nafadd2}
Black



Transparent


0,0.2,0.7,0.2

Arial,8
0,0,0,0
Text5


{Home.nafcity}
Black



Transparent


0.7,0.2,0.8,0.2

Arial,8
0,0,0,0
Text7


{Home.nafstate}
Black



Transparent


1.5,0.2,0.7,0.2

Arial,8
0,0,0,0
Text8


{Home.nafzip}
Black






nmf_Home
Home
Top



False


False

DataBand2






470550ec1cf6433d8c6e95609fbbbc7d
0.39,0.39,0.39,0.39
Page1

11.69
8.27


Arial,100
[50:0:0:0]





System.Dll
System.Drawing.Dll
System.Windows.Forms.Dll
System.Data.Dll
System.Xml.Dll
Stimulsoft.Controls.Dll
Stimulsoft.Base.Dll
Stimulsoft.Report.Dll

Report
2/19/2007 11:45:49

AM
2/17/2007 3:39:27

PM


17a27321e2f344e58cfbecb1cb894276
Report
Inches
2007.1
using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.ReportControls;
using Stimulsoft.Report.Components;

namespace Reports
{

public class Report :

Stimulsoft.Report.StiReport
{

public Report()
{
this.InitializeComponent();
}
#region StiReport Designer generated code -

do not modify#endregion StiReport Designer generated

code - do not modify
}
}
CSharp

I'm experiencing almost the same problem. I have 2 databands (master and detail). I want to layout my data into 2 columns to save some space on my report. When I change the columns-property to 2 columns in my master-band the report 'hangs' during compile. When I do the same with my detail-band the report compiles without errors. What do I want to achieve?

Contents of Column1:
"property1" (master)
--- "value11" (detail)
"property2" (master)
--- "value21" (detail)
--- "value22" (detail)
...

Contents of Column2:
"property3" (master)
--- "value31" (detail)
--- "value32" (detail)
...

How do I define the corresponding design of my report?
How do I tell the report it has to put "property3" in the second column?

If you divide Master DataBand into columns then the report engine does not understand how to process the detail bands for each column from the Master. On the other side the detail databand can be rendered via columns. In this case each Master row produces as many columns in the detail band as you need. But request if I understood in the right way is the following: 1 Master row produces 2 or more detail columns via different relations (Master the same for all) and each column contains data from the different detail DataColumns. This task may be compleated in the following way:
1. Master and Detail are not divided into columns at all.
Each Master dataBand contains a Master datacolumn, a container and a detail databand inside the container.

Master

DatacolumnMaster1 DatacolumnMaster2

container1 container2
DataBanddetail1 Databanddetail2
DataColumnDetail1 DataColumnDetail2

Thank you.

Edward wrote: 1 Master row produces 2 or more detail columns via different relations (Master the same for all) and each column contains data from the different detail DataColumns.

This is not exactly my problem. I have only one master-band and one detail-band, but I don't want the data to appear in only one column. To save some space on my report I want to display the data in two columns. How do I tell the report that it has to put 'property1' and 'property2' (with their details) in the left column and 'property3' (with details) in the right column?

In that case please see an example Side By Side List with Containers in the Demo Application in the group Containers from the standard delivery.
You can download via the following link the example with some modifications:
http://forum.stimulsoft.com/upload/Side ... asters.zip

Thank you.