Telerik Forums
Reporting Forum
1 answer
408 views

Hello,

I need help to get a report done as the image attached. I have 2 reports and I need to show them together in the same report. The first report will be shown always and the second will appear as many times as a parameter says. I don't know what is the best way to do it. Shall I create another report with 2 subreports? The thing is that the report 2 will have be added programmatically.

 WPF( C#) + Telerik.

I'd appreciate any light.

Thanks

Stef
Telerik team
 answered on 21 Oct 2015
3 answers
602 views
Hi, we're rendering a report in PDF format that contains a BMP image. We want the rendering to use the "Flate" algorithm so that the image is not compressed. We need to do that to keep as much detail as possible from the original image.

The image is contained in a PictureBox. We tried to set the PDF Dpi values to 600 dpi without any change in the rendered image quality.

Here's a sample code thta we use:

Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("pdf", instanceReportSource, null);

Is there a parameter that we can set to modify the Telerik PDF rendering so that it does not use the default color image compression ?



 
Stef
Telerik team
 answered on 20 Oct 2015
5 answers
581 views

Hello together

I have the issue, when MultiLine is set to true and having a text with line breaks in it, this gives additional rows in excel which makes it unusable for use for serial letters.
When having MultiLine set to false on the other side and having a text with line breaks in it, it gives an unknown character (�) which isn't cool either.

Any advice? Feature / bug request?

Thx & Regards

Stef
Telerik team
 answered on 20 Oct 2015
1 answer
311 views

Hi,

 I've ​currently trialling the 2015 Q3 Reporting HTML5 viewer in an MVC application.

 I've successfully created a custom parameter editor for the DateTimeEditor using the code below:

Code block to load report:

 

01.<div class="full-height-content full-height-content-scrollable">
02.    <div class="full-height-content-body">
03.        @(Html.TelerikReporting().ReportViewer()
04.              .Id("telerikReportViewer")
05.              .ServiceUrl(Url.Content("~/api/reports/"))
06.              .TemplateUrl(Url.Content("~/ReportViewer/templates/telerikReportViewerTemplate-9.2.15.930.html"))
07.              .ReportSource(@Model.TypeReportSource)
08.              .ViewMode(ViewMode.Interactive)
09.              .ScaleMode(ScaleMode.FitPageWidth)
10.              .PersistSession(false)
11.              .PrintMode(PrintMode.AutoSelect)
12.              .Deferred()
13.              .ParametersAreaVisible(true)
14.              .ParameterEditors(
15.                 editors => editors
16.                      .DateTimeEditor("createDateTimeEditor"))                            
17.              )
18.    </div>
19.</div>

Code block to define DateTime Picker:

01.function createDateTimeEditor(placeholder, options) {
02.    $(placeholder).html('<input type="datetime"/>');
03.    var dateTimePicker = $(placeholder),
04.        parameter,
05.        valueChangedCallback = options.parameterChanged,
06.        dropDownList;
07. 
08. 
09.    function onChange() {
10.        var dtv = this.value();
11.        if (null !== dtv) {
12.            dtv = myadjustTimezone(dtv);
13.        }
14.        valueChangedCallback(parameter, dtv);
15.    }
16. 
17.    return {
18.        beginEdit: function(param) {
19.            parameter = param;
20. 
21.            var dt = null;
22.            try {
23.                if (param.value) {
24.                    dt = myunadjustTimezone(param.value);
25.                }
26.            } catch (e) {
27.                dt = null;
28.            }
29. 
30.            $(dateTimePicker).find("input").kendoDateTimePicker({
31.                format: "dd/MM/yyyy HH:mm",
32.                parseFormats: ["MM/dd/yyyy HH:mm"],
33.                change: onChange,
34.                value: dt
35.            });
36. 
37.            dropDownList = $(dateTimePicker).find("input").data("kendoDateTimePicker");
38. 
39.        }
40. 
41.    };
42.}

The above works great and creates a DateTime Picker, but I want to be able to add another parameter that only allows for Date Entry without the Time component.

 Looking at the Parameter Types and Kendo Controls there's only an option for DateTime (kendoDateTimePicker) and not for Date.  Is it possible to create two parameters for a report, one for DateTime and one for Date?

 Adam

Stef
Telerik team
 answered on 20 Oct 2015
1 answer
122 views
{"message":"","exceptionMessage":"Report instance with ID '062519-c7a8' not found.","exceptionType":"Telerik.Reporting.Services.Engine.InvalidInstanceException","stackTrace":"   at Telerik.Reporting.Services.Engine.ReportEngine.GetDocument(String clientID, String instanceID, String documentID)\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetDocument(String clientID, String instanceID, String documentID)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"}
Stef
Telerik team
 answered on 19 Oct 2015
4 answers
455 views
Hi

We need to source data from a web service for both designing and running reports in the standalone Telerik Report Designer.

We have the web service written and published which exposes all the available methods and their parameters to the user.  When called from the web browser it works fine, returning the requested data in a DataTable in XML format (it is a standard .NET web service).

What we need is for the Report Designer to act in a similar way to the web browser, in that it should dynamically display the web service methods that are available - along with their parameters, and once filled in by the user, they should be invoked and the data made available.  This is needed when designing the report, and should be transparent when running the report.

Given that our end users are not programmers, the selection of the above needs to be simple.

We are often updating the web service and thus need the Report Designer to pick changes up dynamically without the need to distribute anything to the client.

I have created a custom reports datasource (inherits from ObjectDataSource), with config set up and referenced as follows in the Telerik.ReportDesigner.exe.config (per http://www.telerik.com/help/reporting/standalone-report-designer-extending-configuration.html)
:
<Telerik.Reporting>
        <AssemblyReferences>
            <add name="CustomReportsDataSource" version="1.0.0.0" culture="neutral" publicKeyToken="null" />
        </AssemblyReferences>
    </Telerik.Reporting>

The above assembly is only a stub but references the webservice, which I take it allows access to the webservice in the Report Designer due to the Report Designer's use of reflection.

I was hopeful the following config would enable direct access to the webservice, but it is used only by the CustomReportsDataSource.  This unfortunately means our webservices are not dynamic and have to be stubbed in statically in the CustomReportsDataSource.dll, thus necessitating the distribution of this dll whenever there's a change to the web service.
<system.serviceModel>
    <bindings>
        <basicHttpBinding>
            <binding name="ReportsWebServiceSoap" />
        </basicHttpBinding>
    </bindings>
    <client>
        <endpoint address="http://localhost:82/Webservices/ReportsWebService.asmx"
            binding="basicHttpBinding" bindingConfiguration="ReportsWebServiceSoap"
            contract="ReportsServiceReference.ReportsWebServiceSoap" name="ReportsWebServiceSoap" />
    </client>
</system.serviceModel>

To create a report in the Report Designer, I have to do the following (which is also required of a non developer):
  1. Click 'New Report'
  2. Use the Report Designer Wizard and select the Object Data Source.
  3. Click 'Add New Data Source'
  4. Select the 2nd available data source type (appended with 'ReportsServiceReference')
  5. Select 'ReportsWebServiceSoapClient'
  6. Click 'Next' and select 'Choose a data source member'
  7. Select the method required, click 'Next'
  8. Enter the parameters
  9. Select the fields, report type, etc.

Is there a way to simplify this for the end user?  i.e. include our object data source in 'Current Data Sources' and suppress all extraneous methods, displaying only those from the web service?  Ideally, the end user should not have to deal with steps 3-6 above.

Initially, I had an error in the config and at this point would always get the following (very vague and thus difficult and hugely time wasting to resolve) message:

"An error occurred while invoking data retrieval method"

There were no details pertaining to this message in the Telerik.ReportDesigner.log file (log enabled by adding the system.diagnostics section in the config file, per http://www.telerik.com/community/forums/reporting/telerik-report-designer/standalone-report-designer-exe-requirements.aspx).  Further, the webservice was not being called as evidenced by debugging messages not appearing in the server log.

It would've saved me hours and would be appreciated if you could provide more details for this type of error (simply displaying the exception generated would've made the world of difference!).

So my questions are:
  1. As above, is there any way to simplify the report creation process for the end user?
  2. Is there a way to invoke the webservice dynamically?
  3. There was talk of providing an OData data source, any progress/timeframe on that?

Thanks

Clinton Smyth
Top achievements
Rank 1
 answered on 17 Oct 2015
1 answer
99 views

hello,

i'm facing seriouse problem , thick borders printed while i'm trying to print textboxs with borders,there no overlapping,every border caused by one textbox

 i'm facing it in bottom borders too , it happens in printing too

ahmed
Top achievements
Rank 1
 answered on 17 Oct 2015
1 answer
90 views

Hi

I have a Web Api project with Telerik reporting, and ASP site that hosts the reportviewer.

I have had the following issues.

when i run report  report appear with result but if db changeing some data and re-run same report  , report appear with last result 

and i fetch in this case i found that the report keep caching so i want to remove Caching

i use last report version Q3 2015

Stef
Telerik team
 answered on 16 Oct 2015
1 answer
152 views
from where i can download reporting sp1 of q2 2013.? this version 7.1.13.802
Stef
Telerik team
 answered on 16 Oct 2015
13 answers
1.5K+ views
From what I read I don't think it could be possible to pass a field value from datasource1 to be a parameter of datasource2 in a subreport, but could I filter datasource2 based on a field of datasource1.

I don't want to use your product groups example because datasource1 has a lot of fields.
Say I have stores and products and I want to list store information and the products each store carries.
Now I could write 1 query to join products and store, but then I'd be repeating 10 columns of my store data for every product and it would be a very large result set.

say I'd want the report to look like:

StoreID | Store Name| Store Hours| Store Owner| Store Street| Store City| Store State ... ( few more)
  1                MyStore1    8-10               Me     ...
                                                                                                Table Product List MyStore1
                                                                                                       Cookies
                                                                                                        Milk
                                                                                                        Eggs
    2             MyStore2    9-5                Joe     ...
                                                                                                Table ProductList MyStore2
                                                                                                         Steak
                                                                                                          Eggs
                                                                                                          Orange Juice

What would be the best way to accomplish this.  I have a large amount of data, so join the data in 1 query probably isn't ideal.
                                                                                               
Stef
Telerik team
 answered on 15 Oct 2015
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?