Hello everyone. I have a situation where I have created a master summary report with 2 detail sub reports in it. One of my 2 sub reports refuses to show any data. It is configured the same as the 2nd sub report with its parameters properly being passed along but I get bupkis.
I can run the sub report in question by its self and it will display data beautifully but not when I add it as a sub report to my master report.
I found some code while searching the forum to display a custom message when my sub report has no data and using that I have verified that the sub report is just not getting any data back when run.
Any ideas here to help me get over this hump?
Account Fund Amount Group Acct1 Fund1 $20 1 Acct1 Fund2 $30 1 Acct1 Fund3 $40 2 Acct1 Fund4 $50 2 Acct2 Fund1 $60 1 Acct2 Fund2 $70 1 Acct2 Fund3 $80 2 Acct2 Fund4 $90 2 Fund1 Fund2 Fund3 Fund4 Acct1 $20 $30 $40 $50 Acct2 $60 $70 $80 $90Group 1 Fund1 Fund2 Fund3 Fund4 Acct1 $20 $30 0 0 Acct2 $60 $70 0 0 Group 2 Fund1 Fund2 Fund3 Fund4 Acct1 0 0 $40 $50 Acct2 0 0 $80 $90Group 1 Fund1 Fund2 Acct1 $20 $30 Acct2 $60 $70 Group 2 Fund3 Fund4 Acct1 $40 $50 Acct2 $80 $90Hi,
I have report with one chart. I would like to have chart with dynamic series.
My dataset (attachment): 00ds.png
My C# code:
customChart.DataGroupColumn = "Status"; customChart.PlotArea.XAxis.DataLabelsColumn = "Quarter";I've got some strange chart as a result: 01.png. Some series are assigned incorrect. For example, in the Q1 there is "Deleted" with value 10, but it should be in the Q3.
I would like to get something like this: 02.png (note that Q3 and Q4 are changed in the X axis).
Is it possible?
Thanks,
Rafal
//DataSet passed in as parameter
foreach (DataColumn dc in reportDS.Tables[0].Columns)
{
//Add table column group
TableGroup tableGroup1 = new Telerik.Reporting.TableGroup();
tableGroup1.Sortings.Add(
new Sorting(grpTitle1, SortDirection.Asc));
tableGroup1.Name =
Group1";
//tableGroup1.Groupings.Add("1=1");
//tableGroup1.Groupings.Add(new Grouping());
tableGroup1.Groupings.Add(grpTitle1);
this.table1.ColumnGroups.Add(tableGroup1);
#region Grouping
if (!groupingAdded)
{
Group group = new Group();
Grouping groupExpression = new Grouping(grpTitle1);
group.Groupings.Add(groupExpression);
group.Sortings.Add(
new Telerik.Reporting.Sorting(grpTitle1, Telerik.Reporting.SortDirection.Asc));
group.GroupHeader =
new GroupHeaderSection();
group.GroupHeader.Height =
new Unit(10.0, UnitType.Mm);
group.GroupHeader.Style.BackgroundColor =
Color.LightSteelBlue;
Telerik.Reporting.
TextBox tbxGroupHdr = new Telerik.Reporting.TextBox();
tbxGroupHdr.Value =
"=" + grpTitle1;
tbxGroupHdr.Size =
new SizeU(new Unit(10, UnitType.Mm), new Unit(30.0, UnitType.Mm));
group.GroupHeader.Items.Add(tbxGroupHdr);
group.GroupFooter =
new GroupFooterSection();
group.GroupFooter.Height =
new Unit(10.0, UnitType.Mm);
group.GroupFooter.Style.BackgroundColor =
Color.LightYellow;
Telerik.Reporting.
TextBox tbxGroupFtr = new Telerik.Reporting.TextBox();
tbxGroupFtr.Value =
"Group Footer";
tbxGroupFtr.Size =
new SizeU(new Unit(10, UnitType.Mm), new Unit(30.0, UnitType.Mm));
group.GroupFooter.Items.Add(tbxGroupFtr);
this.table1.Report.Groups.Add(group);
groupingAdded =
true;
}
#endregion
 
//Add table body column
//this.table1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Unit.Inch(1)));
txtColumnHdr =
new Telerik.Reporting.HtmlTextBox();
SetTextboxStyle(count, columnCount, dc.ColumnName, fntHdr,
TextBoxType.Group, ref txtColumnHdr);
tableGroup1.ReportItem = txtColumnHdr;
txtColumnBdy =
new Telerik.Reporting.HtmlTextBox();
SetTextboxStyle(count, columnCount, dc.ColumnName, fntBdy,
TextBoxType.Item, ref txtColumnBdy);
this.table1.Body.SetCellContent(0, i++, txtColumnBdy);
this.table1.Items.AddRange(new ReportItemBase[] { txtColumnHdr, txtColumnBdy });
count++;
}