Telerik Forums
Reporting Forum
1 answer
80 views
We have a large number of reports with dynamically generated columns. We cannot create static reports since the columns to be displayed varies from user to user (and no, column groups are not an option since this reduces the performances too much).

The current solution is to design the report in VS with all the static info and grouping. We clear the data source in the report constructor. Then in the "NeedDataSource" event for the report (or table) we open the SQL query, examine the fields returned and create additional columns for the existing table based on the variable columns.

This works fine.

However, if we drill through to another report and navigate back, the table is recreated as it was at design time (without the extra columns). Furthermore there is no way to access the data source instance any more. The report and table data source reflect as NULL in the itemdatabound/binding events. It also seems as if a new instance of the report is created since all the other user added properties are gone / reset to NULL.

This effectively means we cannot use drill through and this is one feature we really need in our application.
Hinata
Top achievements
Rank 1
 answered on 09 Sep 2014
5 answers
1.0K+ views
<Cache provider="File">
      <Providers>
        <Provider name="File">
          <Parameters>
            <Parameter name="BasePath" value="C:\Temp\ReportingCache" />
          </Parameters>
        </Provider>
      </Providers>
    </Cache>

With the FileCache and FileCacheProvider how can you purge the file cache when the browser closes.

I'm attempting to purge reports from the cache when the browser is closed from a window.onbeforeunload event that triggers the purge with a fallback periodic trigger that delete any orphaned cache folders older then twice the SESSION TIMEOUT.

The {InstanceID}RenderingContext and {InstanceID}ProcessingReport exist in the System.Web.Caching.Cache and the WebForm.WebCacheManager adds an OnCacheItemRemovedCallback that calls Dispose which invokes a deletion of the rendering cache folder but does not pass the recursive as its secondary parameter.

When I manually remove the {InstanceId}RenderingContext and {InstanceId}ProcessingReport from Cache, the folders do not get automatically deleted.

I can manually delete the folders within my Purge trigger, but there is no correlation between the RenderID and the InstanceID and verifying the Folder CreationTimeUtc some times throws and Access Violation Error when from the ReportViewer under load when it attempts to Read {RenderId}/Page1.


Any suggestions would be greatly appreciated.




Steve
Top achievements
Rank 1
 answered on 08 Sep 2014
1 answer
41 views
I have a report with a Cross tab which has check Boxes for individual employees for each date. I would like to insert a single row which holds employee information beneath the columns which have the check Boxes, but which ignores those columns for each record.

For Example:

Employee   9/1/2014  9/2/2014 9/3/2014

john doe         X             O                X
                           EMPLOYEE ID 1

jane doe        O              X               X
                           EMPLOYEE ID 2

Is this possible?
Hinata
Top achievements
Rank 1
 answered on 08 Sep 2014
1 answer
304 views
Hi,
I have created Telerik report as Report1.vb, I want to call this report in my webform. Is there any code to call report in webform on button click. If any idea please help me to resolve this issue.

Thanks
Syam Anil.
Stef
Telerik team
 answered on 05 Sep 2014
5 answers
250 views
Hello everyone,

I want to export report object to database. 

The idea is to convert the object to byte array and then write to database.

But the problem is that the Telerik.Reporting.Report object cannot be converted to byte array because [Serializeable] attribute is not defined in the class.

My question is that, is there any solution to this. Can anyone give other solutions to export object to database or any workaround?

Thank you.
Stef
Telerik team
 answered on 05 Sep 2014
1 answer
94 views
I'm just evaluating Reports.  The first question that comes to mind is: Can reports created in VS Designer be opened and modified in Standalone Designer, and/or Can reports created in be opened and modified in  Standalone Designer be opened and modified in VS Designer?  is any functionality lost?
Nasko
Telerik team
 answered on 05 Sep 2014
1 answer
791 views
Hi there 

Try to make it work the HTML5 Telerik report and I have not managed to get it, they can appreciate please attach a demonstration of this. Currently I have the latest version of Telerik Reporting Q2 2014 SP1 (Version: 8.1.14.804) and Visual Studio 2013. 

Thanks a lot 
Nasko
Telerik team
 answered on 05 Sep 2014
3 answers
260 views
I'm getting having a few issues with the MVC reporting implementation. I followed every step in this link here: http://www.telerik.com/help/reporting/mvc-report-viewer-extension-embedding.html, but I can't even display the product catalog report from adventure works. Initially, i was getting a JSON.Parse error in this function: On line 4, line 743 in the telerikReportViewer-8.1.14.804.js file included in my project.

01.function formatXhrError(xhr, status, error) {
02.            var err;
03.            if (xhr) {
04.                var msg = JSON.parse(xhr.reponseText);
05.                if (msg) {
06.                    err = msg.message;
07.                    if (msg.exceptionMessage) {
08.                        if (err) {
09.                            err += "<br/>";
10.                        }
11.                        err += msg.exceptionMessage;
12.                    }
13.                }
14.            }
15.            if (error) {
16.                err = error + ":<br/>" + err;
17.            }
18.            return err || error;
19.        }

After I stepped through the javascript, I found that the STATUS being passed into the function was a "parser error" and the ERROR was "unable to get report parameters". Initially, I was using the adventure works database and product catalog report, but I just decided to design my own from my own database. I used the report wizard inside Visual Studio 2012 and the preview worked great. However, as soon as I added it to the report viewer on my page, I get stuck here again.... Not sure what to do, because none of my reports take parameters. The report viewer shows up on my page no problem, but nothing is displayed.

My Razor page I'm displaying the report viewer on.
01.<div class="row fluid spacer" style="margin-bottom:0px">
02.    <div class="md-col-12">
03.@{
04.       var dataSource = new UriReportSource() { Uri = "recipients.cs" };
05.        //dataSource.Parameters.Add(new Telerik.Reporting.Parameter() { Name = "CheckNumber", Value = "2315527" });
06. 
07.    }
08.@(Html.TelerikReporting().ReportViewer()
09.       .Id("reportViewer1")
10.       .ServiceUrl("/api/reports/")
11.       .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate-8.1.14.804.html")
12.       .ReportSource(dataSource)
13.       .ViewMode(ViewModes.Read)
14.       .ScaleMode(ScaleModes.SPECIFIC)
15.       .Scale(1.0)
16.       .PersistSession(false)
17.       )
18.</div>
19.    </div>

You can tell I tried just messing with adding paramters, but no luck.



Stef
Telerik team
 answered on 05 Sep 2014
1 answer
94 views
Hello,

We need a reporting tool with the ability to report across multiple distinct cube data sources into a single cumulative report.  Our current tools can only target a single cube at a time.  They are the premade cubes from TFS and we don't want to create any new data structures.  Is this possible with Telerik reporting?

Thanks!
Nasko
Telerik team
 answered on 05 Sep 2014
17 answers
1.6K+ views
Hello,

I'm trying to print a report directly to a Epson TM-C3500 label printer. My report has a size of 50mm (width) x 100mm (height) in portrait orientation. 
On the paper-roll the label is 106mm (width) x 51mm (height). So the report has to be printed in landscape mode.

But this seems not to work. The report is always printed in portrait orientation and so it does not fit on the physical label. In the properties of the printer the landscape orientation is selected.

When I first export the report to PDF and print it via the PDF reader, it works perfectly. But the label printing takes place at a point of sale, so it has to work automatically and the way via pdf is not an option.

Any ideas where I can tweak the direct printing process? I wish to use ReportProcessor.PrintReport in the end.

Thanks
Erik
Stef
Telerik team
 answered on 04 Sep 2014
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?