Telerik Forums
Reporting Forum
2 answers
141 views
Hi there,

I'm looking for  a piece of advice- any help would be appreciated!

Our Customer would like to have possibility to edit generated reports before exporting and/or storing them to the DB. Actually they would like to give users possibility to edit reports' content (not the layout itself) in preview mode. After several meeting-sessions we have split the requirements:
1. Power User should have possibility to create report template (stand-alone Report Designer is ok, but is there any component that can be integrated to the Web Site?);
2. Normal User should have possibility to generate a report instance basing on the template;
3. The generated report instance should be available as a preview inside our web site- Normal User will be able to edit the content (some of the fields), but not the layout;
4. The generated report can be saved to the DB and be edited later (optional);
5. There must be a possibility to export the generated report as a Pdf file (actually, they need secured Pdf). 

I've started with "googling", watching demo-videos, etc. and have found several potentially useful components, but I'm not sure if it's possible to stick them together to reach the goal... There are several findings:
1. There is no possibility to protect PDFs using Telerik- we will have to use something else;
2. HTML5 Report Viewer can be used for previewing (probably Editor component can be used together with the Viewer?);
3. Editable Pdfs are not the solution.

Did anybody implemented anything similar and/or does anybody have ideas how to make a trick?

Thanks in advance!

Cheers,
Kostya.
bk
Top achievements
Rank 1
 answered on 10 Sep 2014
11 answers
818 views
Hi,

   Sorting not working in the crosstab. I've given order by in the query. Even i set the Sorting property in crosstab. Sorting is not working. Is it a bug or i need to specify somewhere else? Pls help.

Thanks in advance.
Rich
Top achievements
Rank 1
 answered on 10 Sep 2014
1 answer
124 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.2K+ 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
75 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
332 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
285 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
104 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
849 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
299 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
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?