Questions on Reporting Forum

3 answers

426 views

Growing Crosstab vertical instead of horizontal

Hey folks,

I need a event count table. I have two type of tupple from sql datasource; EventDate and EventID. All i want is counting IDs at the same date.
I can do this with using crosstab by putting Date to Column groups and ID to Detail Values with Count() expression added. But when i do this, it grows horizontally (horGrow.png).
If i put Date to Row group instead of Column, the count function doesn't work, even I type it manually(verGrow.png).

How can I get what i want?

Is there a way to make count function work well with row groups?

Or can we change row group with column group so it grow vertically?

Thanks a lot :)

Report Designer (standalone)

answered on 04 Jul 2016

4 answers

327 views

Alternate Rows Color Strange Behaviours

I have a .trdx report file that uses Conditional Formatting to apply kind of an alternating rows color. This works fine inside the Telerik Report Designer but when I use the very same .trdx file with the HTML 5 Viewer, some colors get inverted.

Please find the attached screenshots. The first one is the one taken in the Designer, the second one is the one taken in the HTML 5 Viewer.

Regards.

General Discussions

answered on 01 Jul 2016

1 answer

571 views

How to open links to sub-reports in new windows

Hi,

I have a report with fields that can be clicked to open a sub-report. I implemented this functionality by selecting the field that I wanted to be "clickable" and then specifying "navigate to report" as the action property.

The issue is that when a user clicks on the link to navigate to the sub-report, the sub-report loads over top of the current report. The user is then unable to navigate back to the parent report without having to reenter the parameters and run the report again.

I'm looking for a way to open the sub-report in a new tab/window but I do not see an option to do so. There is an option to open a URL in a new window but we don't have a way to pass parameters into the URL which would be needed to populate the sub-report.

Is there a workaround to navigate to a report and have that report open in a new tab/window? Our team is using Report Designer so we're unable to create user functions.

Thanks in advance.

Report Designer (standalone)

answered on 01 Jul 2016

11 answers

1.4K+ views

Type own list of parameter values

Hi

Moving from ssrs to Telerik reporting I am finding it mostly easy to understand and the transition reasonably smooth but one thing I cant work out after much searching and experimenting is how to supply a list of values to use as a parameter selection for the end user without having to use a datasource

Many of the parameters I will be using in my reports simply require the values

Yes
No

or

Not started
In progress
Complete

In ssrs is was easy to use the report parameters dialog to type in the text / value pairs but i cant find that functionality in the parameter collection dialog in Telerik reporting

I would appreciate if anyone can assist as I would prefer not to have to make a table for each parameter value

Regards

Dwight

General Discussions

answered on 01 Jul 2016

1 answer

142 views

Chart - Fill the Table Cell

I am trying to replicate the sample sales order report in that you have a line chart in a cell within the Cross Tab.

How do you make the chart fill the contents of that cell? I keep getting white space on all 4 sides.

I am building the chart outside of the crosstab first, removing everything I can such as the legend, title, axis data and markers. No matter what I do, I still end up with that white space around.

I have tried to follow the example but I fear it is outdated (you have a crosstab in the details section which I was told can't be done).

Any help is appreciated.

Report Designer (standalone)

answered on 30 Jun 2016

1 answer

288 views

Propeblems with line thick in table

I'm binding Table from Subreport to main report at report. I create Subreport as Report in code behind at run time and attach it to InstanceReportSource which i set to ReportSource porperty of Subreport instance.

When The table is shown in Report viewer some table lines are thikcer then other. The thicker lines seem to be random on different computers.

Is there some work around to get all table lines the same thicknes?

General Discussions

answered on 30 Jun 2016

6 answers

107 views

Rendered Report in XLSX Format, No Data in Apple Numbers

I'm having an issue with rendering a report in XLSX format. The rendered report opens up fine in Microsoft Excel, but when I try to open it up in Apple Numbers it doesn't display any data.

The report file is being generated using the RenderReport method and the returned RenderingResult DocumentBytes are then written to a file, with the Extension attribute used from the RenderingResult.

I've also noticed that if I open the file up in Excel, and then re-save it as XLSX, the file will then open up fine in Numbers, so that leads me to believe that it is just some issue with the way that the report is being generated by Telerik.Reporting.

Any ideas?

General Discussions

answered on 29 Jun 2016

1 answer

90 views

O Ponto de entrada não foi encontrado

Good Morning

When attempting to export a report to PDF happens the following error below.

{System.EntryPointNotFoundException: O ponto de entrada não foi encontrado.
em Telerik.Reporting.IReportDocument.get_ReportParameters()
em Telerik.Reporting.Processing.ParametersHelper.ApplyParameters(IReportDocument reportDocument, IEnumerable`1 parameters) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ParametersHelper.cs:linha 15
em Telerik.Reporting.Processing.ReportDocumentResolver`1.Telerik.Reporting.Processing.IReportDocumentResolver.Resolve(IProcessingContext context, ReportSource rs, Boolean loadParameters) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 171
em Telerik.Reporting.Processing.ReportDocumentResolver.<>c__DisplayClass1.<Resolve>b__0(IReportDocumentResolver r) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 130
em Telerik.Reporting.Processing.ReportDocumentResolver.Bind[T](IProcessingContext context, ReportSource source, Func`2 func) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 142
em Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IProcessingContext context, ReportSource source, Boolean loadParameters) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 130
em Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IProcessingContext context, ReportSource source) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 125
em Telerik.Reporting.Processing.ReportProcessor.ProcessReport(ReportSource reportSource, IRenderingContext context) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.ProcessReport.cs:linha 211
em Telerik.Reporting.Processing.ReportProcessor.ProcessReport(ReportSource reportSource, Hashtable deviceInfo, IRenderingContext context) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.ProcessReport.cs:linha 101
em Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.RenderReport.cs:linha 279
em Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.RenderReport.cs:linha 252
em Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.RenderReport.cs:linha 67
em NewsGPS.Web.Controllers.ChamadoVeiculoController.ChamadoVeiculoReporting(Int32 id) na c:\RASTREAMENTO\NewsGPS.Admin\NewsGPS.Admin\NewsGPS.Web\Controllers\ChamadoVeiculoController.cs:linha 387
em lambda_method(Closure , ControllerBase , Object[] )
em System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
em System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
em System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
em System.Web.Mvc.Async.AsyncControllerActionInvoker.ActionInvocation.InvokeSynchronousActionMethod()
em System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
em System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
em System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
em System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
em System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
em System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
em System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()}

My Code :

var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();

Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();

instanceReportSource.ReportDocument = rel;
instanceReportSource.Parameters.Add("VeiIdentificacao", "1");

var result = reportProcessor.RenderReport("PDF", instanceReportSource, null); -------- Error the error happens just when passing through this line

General Discussions

answered on 29 Jun 2016

1 answer

329 views

The entry point was not found

Good Morning

When attempting to export a report to PDF happens the following error below.
{System.EntryPointNotFoundException: O ponto de entrada não foi encontrado.
em Telerik.Reporting.IReportDocument.get_ReportParameters()
em Telerik.Reporting.Processing.ParametersHelper.ApplyParameters(IReportDocument reportDocument, IEnumerable`1 parameters) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ParametersHelper.cs:linha 15
em Telerik.Reporting.Processing.ReportDocumentResolver`1.Telerik.Reporting.Processing.IReportDocumentResolver.Resolve(IProcessingContext context, ReportSource rs, Boolean loadParameters) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 171
em Telerik.Reporting.Processing.ReportDocumentResolver.<>c__DisplayClass1.<Resolve>b__0(IReportDocumentResolver r) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 130
em Telerik.Reporting.Processing.ReportDocumentResolver.Bind[T](IProcessingContext context, ReportSource source, Func`2 func) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 142
em Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IProcessingContext context, ReportSource source, Boolean loadParameters) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 130
em Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IProcessingContext context, ReportSource source) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing\ReportDocumentResolver.cs:linha 125
em Telerik.Reporting.Processing.ReportProcessor.ProcessReport(ReportSource reportSource, IRenderingContext context) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.ProcessReport.cs:linha 211
em Telerik.Reporting.Processing.ReportProcessor.ProcessReport(ReportSource reportSource, Hashtable deviceInfo, IRenderingContext context) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.ProcessReport.cs:linha 101
em Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.RenderReport.cs:linha 279
em Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.RenderReport.cs:linha 252
em Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo) na c:\temp\reporting\RBuild-6690\Reporting_Build\Source\Code\Telerik.Reporting.Processing.ReportProcessor\ReportProcessor.RenderReport.cs:linha 67
em NewsGPS.Web.Controllers.ChamadoVeiculoController.ChamadoVeiculoReporting(Int32 id) na c:\RASTREAMENTO\NewsGPS.Admin\NewsGPS.Admin\NewsGPS.Web\Controllers\ChamadoVeiculoController.cs:linha 387
em lambda_method(Closure , ControllerBase , Object[] )
em System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
em System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
em System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
em System.Web.Mvc.Async.AsyncControllerActionInvoker.ActionInvocation.InvokeSynchronousActionMethod()
em System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
em System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
em System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
em System.Web.Mvc.Async.AsyncResultWrapper.End[TResult](IAsyncResult asyncResult, Object tag)
em System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
em System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
em System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()}

My Code :

var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = rel;
instanceReportSource.Parameters.Add("VeiIdentificacao", "1");

var result = reportProcessor.RenderReport("PDF", instanceReportSource, null); -------- Error the error happens just when passing through this line

General Discussions

answered on 29 Jun 2016

1 answer

847 views

Object Data Binding with ReportItem.DataObject

Hello,

I am attempting to pass cached data to a report. The data is cached in memory and retrieved. The report is designed using Report Designer and stored as .trdx. I create a dataobject that retrieves the data from the cache. I want to bind a table to a list of view models which match the described schema identically and contain all fields in the same order same spelling case sensitive. The header item is binding fine to reportitem.dataobject, but I cannot get the table to bind to the underlying List. it is saying that it contains LeadStatus that is not defined. However I have it defined in the XML

I load the report like so.

string reportsPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Reports");

string reportName = reportsPath + @"\LeadsActivity.trdx";

System.Xml.XmlReaderSettings settings = new System.Xml.XmlReaderSettings();

settings.IgnoreWhitespace = true;

//read the .trdx file contents

using (System.Xml.XmlReader xmlReader = System.Xml.XmlReader.Create(reportName,settings))

{

Telerik.Reporting.XmlSerialization.ReportXmlSerializer xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

//deserialize the .trdx report XML contents

Telerik.Reporting.Report report = (Telerik.Reporting.Report) xmlSerializer.Deserialize(xmlReader);

var dataobjs = new LeadsActivityDataProvider(cacheKey);

report.DataSource = dataobjs;

string mimType = string.Empty;

string extension = string.Empty;

Encoding encoding = null;

// call Render() and retrieve raw array of bytes

// write the pdf file

byte[] buffer = Telerik.Reporting.Processing.ReportProcessor.Render(

"PDF", report, null, out mimType, out extension, out encoding);

// create a new file on disk and write the byte array to the file

FileStream fs = new FileStream(reportsPath + @"\TestRpt.pdf", FileMode.Create);

fs.Write(buffer, 0, buffer.Length);

fs.Flush();

fs.Close();

}

return reportsPath + @"\TestRpt.pdf";

[DataObject]

public class LeadsActivityDataProvider

{

private ReportDataCache cache = new ReportDataCache();

public string TestTitle { get; set; }

public List<LeadActivityReportViewModel> TableData { get; set; }

public LeadsActivityDataProvider(string cacheKey)

{

TestTitle = "Test Title";

TableData = cache.Get<List<LeadActivityReportViewModel>>(cacheKey);

}

This element works

<TextBox Width="7.9999213218689in" Height="0.499999980131786in" Left="0.0000394185371988in" Top="0in" Value="= ReportItem.DataObject.TestTitle" Name="Arial">

<Style TextAlign="Center">

<Font Name="Calibri" Size="12pt" Bold="False" />

</Style>

</TextBox>

However this table is giving me an Error

<Table Width="7.97916757624932in" Height="1.21770811465888in" Left="0.0208326975504557in" Top="0in" Name="table2">

<Body>

<Cells>

<TableCell RowIndex="3" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.203993031202274in" Left="3.3999605178833in" Top="0.100000063578288in" Value="=Fields.EventDate" Format="{0:d}" Name="textBox33">

<Style BackgroundColor="White" />

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="3" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.203993031202274in" Left="3.3999605178833in" Top="0.100000063578288in" Value="=Fields.FollowUpDate" Format="{0:d}" Name="textBox34">

<Style BackgroundColor="White" />

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="1" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.236979214728681in" Left="0in" Top="0in" Value="=LeadStatus" Name="textBox37" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="1" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.236979214728681in" Left="0in" Top="0in" Value="=Fields.CustomerName" Name="textBox38" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="1" ColumnIndex="2" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.83333372958235in" Height="0.236979214728681in" Left="0in" Top="0in" Value="=Fields.SourceName" Name="textBox39" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="1" ColumnIndex="3" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.48958337554672in" Height="0.236979214728681in" Left="0in" Top="0in" Value="= Fields.QuoteNumber" Name="textBox40" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="2" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.236979462490679in" Left="0in" Top="0in" Value="Event" Name="textBox1" StyleName="">

<Style BackgroundColor="White">

<Font Bold="False" Underline="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="2" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.236979462490679in" Left="0in" Top="0in" Value="Follow Up" Name="textBox11" StyleName="">

<Style BackgroundColor="White">

<Font Bold="False" Underline="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="2" ColumnIndex="2" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.83333372958235in" Height="0.236979462490679in" Left="0in" Top="0in" Value="Details" Name="textBox29" StyleName="">

<Style BackgroundColor="White">

<Font Bold="False" Underline="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="2" ColumnIndex="3" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.48958337554672in" Height="0.236979462490679in" Left="0in" Top="0in" Name="textBox31" StyleName="">

<Style BackgroundColor="White">

<Font Bold="False" Underline="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="4" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.216145749138395in" Left="0in" Top="0in" Value="=Fields.EventCompletedBy" Format="{0}" Name="textBox42" StyleName="">

<Style BackgroundColor="White" />

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="4" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.216145749138395in" Left="0in" Top="0in" Value="=Fields.SalesmanName" Name="textBox43" StyleName="">

<Style BackgroundColor="White" />

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="3" ColumnIndex="2" RowSpan="2" ColumnSpan="2">

<ReportItem>

<TextBox Width="4.32291710512907in" Height="0.420138771518487in" Left="0in" Top="0in" Value="=Fields.EventDetails" Name="textBox30">

<Style BackgroundColor="White" />

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.104166595363224in" Left="0in" Top="0in" Name="textBox8" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.104166595363224in" Left="0in" Top="0in" Name="textBox9" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="2.83333372958235in" Height="0.104166595363224in" Left="0in" Top="0in" Name="textBox10" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.48958337554672in" Height="0.104166595363224in" Left="0in" Top="0in" Name="textBox12" StyleName="">

<Style BackgroundColor="White">

<Font Bold="True" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

</Cells>

<Columns>

<Column Width="1.40624906538001in" />

<Column Width="2.25000140574025in" />

<Column Width="2.83333372958235in" />

<Column Width="1.48958337554672in" />

</Columns>

<Rows>

<Row Height="0.104166603885721in" />

<Row Height="0.236979028603148in" />

<Row Height="0.236979518525301in" />

<Row Height="0.203992951132829in" />

<Row Height="0.216145760447272in" />

</Rows>

</Body>

<Corner />

<Style>

<Font Name="Calibri" Size="11pt" />

</Style>

<RowGroups>

<TableGroup Name="leadStatus1">

<ChildGroups>

<TableGroup Name="leadStatus">

<ChildGroups>

<TableGroup Name="group5" />

<TableGroup Name="group11" />

<TableGroup Name="group18" />

<TableGroup Name="detailTableGroup1">

<ChildGroups>

<TableGroup Name="group19" />

<TableGroup Name="group20" />

</ChildGroups>

<Groupings>

<Grouping />

</Groupings>

</TableGroup>

</ChildGroups>

<Groupings>

<Grouping Expression="=Fields.CustomerName" />

</Groupings>

<Sortings>

<Sorting Expression="=Fields.CustomerName" Direction="Asc" />

</Sortings>

</TableGroup>

</ChildGroups>

<Groupings>

<Grouping Expression="=Fields.LeadStatus" />

</Groupings>

<Sortings>

<Sorting Expression="=Fields.LeadStatus" Direction="Asc" />

</Sortings>

</TableGroup>

</RowGroups>

<ColumnGroups>

<TableGroup Name="tableGroup3">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.194444241854954in" Left="0in" Top="0in" Value="Status" Name="textBox3" StyleName="">

<Style>

<BorderStyle Bottom="Solid" />

<BorderColor Bottom="Black" />

<BorderWidth Bottom="1pt" />

<Font Name="Calibri" Size="11pt" Bold="True" />

</Style>

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group1">

<ReportItem>

<TextBox Width="1.40624906538in" Height="0.0250000016262168in" Left="0in" Top="0in" Name="textBox2" StyleName="">

<Style BackgroundColor="Black" />

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group14" />

</ChildGroups>

</TableGroup>

</ChildGroups>

</TableGroup>

<TableGroup Name="tableGroup4">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.194444241854954in" Left="0in" Top="0in" Value="Customer" Name="textBox6" StyleName="">

<Style>

<BorderStyle Bottom="Solid" />

<BorderColor Bottom="Black" />

<BorderWidth Bottom="1pt" />

<Font Name="Calibri" Size="11pt" Bold="True" />

</Style>

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group2">

<ReportItem>

<TextBox Width="2.25000140574025in" Height="0.0250000016262168in" Left="0in" Top="0in" Name="textBox4" StyleName="">

<Style BackgroundColor="Black" />

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group15" />

</ChildGroups>

</TableGroup>

</ChildGroups>

</TableGroup>

<TableGroup Name="tableGroup5">

<ReportItem>

<TextBox Width="2.83333372958235in" Height="0.194444241854954in" Left="0in" Top="0in" Value="Source of Lead" Name="textBox36" StyleName="">

<Style>

<BorderStyle Bottom="Solid" />

<BorderColor Bottom="Black" />

<BorderWidth Bottom="1pt" />

<Font Name="Calibri" Size="11pt" Bold="True" />

</Style>

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group3">

<ReportItem>

<TextBox Width="2.83333372958235in" Height="0.0250000016262168in" Left="0in" Top="0in" Name="textBox5" StyleName="">

<Style BackgroundColor="Black" />

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group16" />

</ChildGroups>

</TableGroup>

</ChildGroups>

</TableGroup>

<TableGroup Name="group">

<ReportItem>

<TextBox Width="1.48958337554672in" Height="0.194444241854954in" Left="0in" Top="0in" Value="Quote #" Name="textBox41" StyleName="">

<Style>

<BorderStyle Bottom="Solid" />

<BorderColor Bottom="Black" />

<BorderWidth Bottom="1pt" />

<Font Name="Calibri" Size="11pt" Bold="True" />

</Style>

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group4">

<ReportItem>

<TextBox Width="1.48958337554672in" Height="0.0250000016262168in" Left="0in" Top="0in" Name="textBox7" StyleName="">

<Style BackgroundColor="Black" />

</TextBox>

</ReportItem>

<ChildGroups>

<TableGroup Name="group17" />

</ChildGroups>

</TableGroup>

</ChildGroups>

</TableGroup>

</ColumnGroups>

<Bindings>

<Binding Path="DataSource" Expression="ReportItem.DataObject.TableData" />

</Bindings>

</Table>

Here is the view model

public class LeadActivityReportViewModel : ViewModelBaseActive {

public string CacheID {get; set;}

public string CustomerName {get; set;}

public string EventCompletedBy {get; set;}

public DateTime EventDate {get; set;}

public string EventDetails {get; set;}

public DateTime FollowUpDate {get; set;}

public string LeadStatus {get; set;}

public string QuoteNumber {get; set;}

public int Row {get; set;}

public string SalesmanName {get; set;}

public string SourceName {get; set;}

}

General Discussions

answered on 28 Jun 2016