Telerik Forums
Reporting Forum
3 answers
350 views
Good afternoon,

I'd like to request your help on something I've been trying to do but haven't succeeded yet.
I need to create a few reports and need to provide them in a website (asp.net), where we also used telerik controls (we have recently upgraded to 2012 Q1)
Not all users will have access to all reports and there will be a menu built according to the user's permissions.
I was thinking ofstoring the report in a sql server (we use microsoft sql server 2008) database, so that the project won't need to be compiled everytime a new report is created.
I suppose i would have to store the project's dll in a varbinary(MAX) field.
My biggest doubt is how i set the report viwer to load the dll i stored in the database.
I've tried this:
            string reportName = @"Colaboradores.MapasFerias, Colaboradores, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";

            
            System.Type reportType = System.Type.GetType(reportName);

            IReportDocument report = (IReportDocument)Activator.CreateInstance(reportType);
            this.ReportViewer1.Report = report;
I know this is not going to the database, but it was just an experiment.... In this case reportType allways returs null...
I have a separate project where i create my reports and, like i said, i'd like to store them  in a database.

I have no idea how to set the report viewer to open a dll... Could you please help me?
Thank you very much!

looking forward to hearing from you,
António
AvgurD
Top achievements
Rank 1
 answered on 22 Jun 2012
2 answers
93 views
Hi everyone,

i've discovered a problem and would like to know, if this is an error on my side, or if anyone can reproduce it.

Here the HTML code:
<p style="margin: 0px 0px 0px 0px;text-align: left;text-indent: 0pt;padding: 0px 0px 0px 0px;">
<span style="font-family: 'MS Sans Serif';font-style: normal;font-size: 11px;color: #000000;background-color: #FFFFFF;">Test for the missing </span>
<span style="font-family: 'MS Sans Serif';font-weight: bold;font-size: 11px;color: #000000;background-color: #FFFFFF;">character</span>
<span style="font-family: 'MS Sans Serif';font-style: normal;font-size: 11px;color: #000000;background-color: #FFFFFF;"> at the end of a bold span</span>
</p>

When i put this into the expression editor (in html view) and switch to design view, everything looks find. But when the report is rendered, the last character of the bold part of the code (in this case the letter 'r' in the word 'character') is gone.

Waiting for you observations ;)

Regards,
Michael
Michael Hilgers
Top achievements
Rank 1
 answered on 22 Jun 2012
0 answers
77 views
Hi,
How to create line chart in telerik reporting using VB code
Gunasekar
Top achievements
Rank 1
 asked on 22 Jun 2012
1 answer
113 views
hello,

Do you plan to add a report item to show spatial data ? For example in sql server reporting service we can add a map item and show spatial data from a data source. i know i can insert an image but it is not handy.


Thanks in advance
sebastien
IvanY
Telerik team
 answered on 21 Jun 2012
1 answer
172 views
I have a Crosstab that is displaying data from a SQL data source. The data is grouped by the field FacilityID. I have a report parameter Facility that is a multiselect dropdown populated from another SQL datasource. How can I filter the Crosstab based on the selections in the Facility dropdown? When editing the filter property of the Crosstab it does not show the fields associated with that DataSource.
Peter
Telerik team
 answered on 21 Jun 2012
1 answer
203 views
Hi,

how can I extract the number of rendered pages from a Telerik.Reporting.Report ?
The idea is to check via a unit test if no empty pages are generated by a report.
(E.g. report with known data has 2 pages. Changing the layout later on causes an empty page. Report has now 3 pages, unit test detects this problem.)

Regards,
Marco
Peter
Telerik team
 answered on 21 Jun 2012
2 answers
200 views
Hi.
I made a report. It is very simply report, without no calculation no aggregation, only displaying data.
Storage procedure as a data source need 7 seconds to display 14.000 rows, but telerik report needs 3 minutes.
I read this article, but nothing described helped. Is any other possibility to improve report rendering?

--
Daniel
Daniel
Top achievements
Rank 1
 answered on 21 Jun 2012
3 answers
283 views
Hi there

I have reporting DLL setup up that I reference in my web application.

There is a report type called DefaultCertificate in this class lib, I can change the datasource dynamically, but what I want to do is apply a template at runtime as well.

Some clients will have their own template, but with the same fields. I know there is something like a trdx file that keeps the template? But can't seem to find decent documentation on it.

Long story short:

1. How do I save my current or any other report design to a trdx file
2. How would I apply that trdx file to the certificate at run time?
        DefaultCertificate applicantCertificate = new DefaultCertificate();
        applicantCertificate.DataSource = application.GetCertificateDetails(applicantID, applicationYear);
 
//something to do the following?
applicantCertificate.Template = "location of template trdx file";

Thanks.
IvanY
Telerik team
 answered on 21 Jun 2012
1 answer
92 views
If I have a WPF smart client with Server that contain all data. 
I want to add reports to the WPF client. 
What are the best practice for that? 
What data source should  I have? 
There is a lot of data, should I retrieve all rows to client?! or can I generate the report on server with some paging? 

Thanks. 

Peter
Telerik team
 answered on 21 Jun 2012
0 answers
60 views
Dear All,

    I have two questions:

    1st: End-user accessability
    ======
    I want to know if it is possible by any mean to give the end-user the ability to define the sort criteria to the generated report or not.
    I will appreciate any solution, as I couldn't find any by myself...
    
    2nd: Localization
    ======
    a. How should I localize the report contents
    b. I have a global switching of the language and it is working fine, except for the reportviewer ...I need to reload the reportviewer itself 
    to take the effect of the language setting changes, is there any way to implement this as the normal .resx files ? 
    as for normal .resx  files I can do this 
    
((ResourceWrapper)Application.Current.Resources["ResourceWrapper"]).ScreensRes = new ScreensRes();

    after changing the culture .

Best regards
Ubuntu
Top achievements
Rank 1
 asked on 21 Jun 2012
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?