Telerik Forums
Reporting Forum
2 answers
415 views

I am creating a report in the report designer.

My rows looks like this:

Name, TripID, DepartureDate

I have a row group that is grouping by Name.

I have two parameters, Start and End.

My table displays:

=Fields.Name, =Count(Fields.TripID)

My row group has two filters, so that the Start and End parameters filter rows if the departure date is not between Start and End.

Right now my display for Count(Fields.TripID) always displays the count of unfiltered rows.  What do I need to do to get the Count of filtered rows?

Scott
Top achievements
Rank 1
 answered on 05 Jul 2016
1 answer
241 views

I have a table on a report and I need to be able to have a 1 as a superscript in the textbox.  I have tried a number of methods. I know I can use an htmTextbox and superscript works but the is when an expression is not used.

=IIF(Parameters.InceptionMonths > 11, Format("{0:P2}",Fields.InceptionReturn) + " " + &#185 Format("{0:P2}",Fields.InceptionReturn))

I get the error that it is a missing operand before "&" operator.  when I use <sup> I get the same basic error.  I cannot use chr(185).

Katia
Telerik team
 answered on 05 Jul 2016
3 answers
420 views

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 :)

Katia
Telerik team
 answered on 04 Jul 2016
4 answers
320 views

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.

Stef
Telerik team
 answered on 01 Jul 2016
1 answer
562 views

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.

Stef
Telerik team
 answered on 01 Jul 2016
11 answers
1.3K+ views
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

Stef
Telerik team
 answered on 01 Jul 2016
1 answer
138 views

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.

Katia
Telerik team
 answered on 30 Jun 2016
1 answer
275 views

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?

Stef
Telerik team
 answered on 30 Jun 2016
6 answers
104 views

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?

Isaac
Top achievements
Rank 1
 answered on 29 Jun 2016
1 answer
86 views

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

Katia
Telerik team
 answered on 29 Jun 2016
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?