Telerik Forums
Reporting Forum
1 answer
155 views
It seems to me like the support for Parametrized Queries is severely lacking.  If you choose to go the route of using an sqldataAdapter with parameters you can no longer use the table or cross-tab wizards and most of the report has to created by hand.

As far as I can see the performance difference between using a filter to select certain data over using a parameter in the sql query is minimal, but I am test on such a small scale I don't know if it will truly make a difference.

I need to know how the filters work.  I assume that the query pulls all of the data into the dataset and then the filter selects the needed data from that.  This seems very inefficient to me because we are pulling a large amount of data from the DB then grabbing the small chunk we need and throwing the rest away.  While a PQ will only pull the data you need from the DB, eliminating the need for a secondary filter.

Is this how it works, if so that just seems silly to me that there is such lacking support for PQ's in the designer.
Hrisi
Telerik team
 answered on 06 Nov 2009
1 answer
144 views
Hey

Is there any good example for building report dynamic. I can't find very much information about this. Only ifnormation i found was this: http://www.telerik.com/help/reporting/programmatic-control-of-reports.html

My problem is that the report would change depending on the data.

Here are some of mye problem:
- Add controls dynamic. I know i can add controls in design mode and look at the "code behind". But it looks like i need to place control with a absolute position. I need to use sections. I tried to use panels, but this is useless if i need to give the panel a absolute position, because the content length of every panel will be different.
- How can i control page break? I would like every new section to start on a new page.

Thanks

Steve
Telerik team
 answered on 05 Nov 2009
1 answer
136 views

 

Hi

I'm trying to fill a HTMLTextBox on a subreport programatically in order to change appearence depending on the data. I managed to get line breaks working by changing from BR to DIV tags, but I can't get the styles to work. Since I have a lot of subreports I really don't want to include FONT tags into the code and risk creating a maintenance nightmare. Is there a way to set styles programatically?

I've tried adding the HTML using a script that is called from the HTMLTextBox, such as
...
PositionLine = "<DIV Class='PositionCompany>'" & PositionLine & "</DIV>"
Return PositionLine

but this only gives me linebreaks, not the formatting. "'PositionCompany" is a style rule defined in the master report.

How do I call the CSS formatting? (By the way, I can't set it directly since I use several different style rules inside the same HTMLTextBoc depending on data.

Thanks in advance!

Re
Dennis

   Public Shared Function Position(ByVal Company As StringByVal City As StringByVal Country As StringByVal CompanyType As StringByVal Title As StringByVal DetailLong As StringByVal DetailShort As StringAs String 
 
        Dim PositionLine As String = Company.ToString  
 
        If City <> "" Then 
            If PositionLine <> "" Then 
                PositionLine += ", " & City.ToString  
            Else 
                PositionLine = City.ToString  
            End If 
        End If 
        If Country <> "" Then 
            If PositionLine <> "" Then 
                PositionLine += ", " & Country.ToString  
            Else 
                PositionLine = Country.ToString  
            End If 
        End If 
        If CompanyType <> "" Then 
            If PositionLine <> "" Then 
                PositionLine += " (" & CompanyType.ToString & ")" 
            Else 
                PositionLine = CompanyType.ToString  
            End If 
        End If 
        If PositionLine <> "" Then 
            PositionLine = "<DIV Class='PositionCompany'>" & PositionLine & "</DIV>" 
        End If 
        If Title <> "" Then 
            If PositionLine <> "" Then 
                PositionLine = PositionLine & "<DIV Class='PositionTitle'>" & Title.ToString & "</DIV>" 
            End If 
        End If 
        If DetailShort <> "" Then 
            If PositionLine <> "" Then 
                PositionLine = PositionLine & "<DIV Class='PositionDetails'>" & DetailShort.ToString & "</DIV>" 
            End If 
        End If 
 
        If DetailLong <> "" Then 
            If PositionLine <> "" Then 
                PositionLine = PositionLine & "<DIV Class='PositionDetails'>" & DetailLong.ToString & "</DIV>" 
            End If 
        End If 
 
 
        Return PositionLine  
 
    End Function 
 
Steve
Telerik team
 answered on 05 Nov 2009
1 answer
135 views
Hello there!
           When i export my generated report to Web Archive format in IE7 all my datas are exported correctly How ever when i try to export it to Web Archive format in Mozilla3.5 format it is displaying binary datas. Is there any solution for this problem? I have attached images for your understanding.
Kindly help me ASAP...

Many thanks
Steve
Telerik team
 answered on 05 Nov 2009
0 answers
104 views
Our application allows a user to generate a Telerik report.  Sometimes when the report is generated, the application is not fully maximized.  When in fact the application does get fully maximized, the top of the report has fallen off the page and there is no way to close it.  The functionality we are aiming to achieve is to implement a context menu that can be accessed by a right click, so when this happens they can simply right click and close the report.  Any suggestions?
Lindsey Kelly
Top achievements
Rank 1
 asked on 04 Nov 2009
4 answers
266 views
I am looking for a way to make the size of the parameter window always large enough to show the parameter input controls. Currently I have some reports that work nicely and others that generate a scroll bar that must be used to see all the parameter input controls. I cannot seem to find the setting or property that controls this. Can someone point me in the correct direction? Thanks!!
Bryan Strader
Top achievements
Rank 2
 answered on 04 Nov 2009
2 answers
199 views
Hi,


  I would like to apply the skin for Report Parameters.Report parameters may be date picker, dropdownlist.

Please help me how to do it?

Thanks for your help,
Steve
Telerik team
 answered on 04 Nov 2009
1 answer
172 views
Hi

string id = Request.QueryString["id"];
 Value Get

Telerik Report Parameters
 Value Set

Example
Q2 2009
using Telerik.Reporting;

string reportName = Server.UrlDecode(this.Request.QueryString["ReportName"]);
string id = Request.QueryString["id"];

if (!string.IsNullOrEmpty(reportName))
{
    Type reportType = Type.GetType(reportName);
    IReportDocument report = (IReportDocument)Activator.CreateInstance(reportType);

    ?????  report.ReportParameters

    this.ReportViewer1.Report = report;
    this.Page.Title = reportType.Name;


Kwon OhJong
Top achievements
Rank 2
 answered on 04 Nov 2009
2 answers
152 views
Hi,

is it possible to do something similar to this http://www.telerik.com/community/forums/aspnet-ajax/grid/self-referencing-hierarchy-in-programmatic-grid-with-a-xmldatasource.aspx

With some data in a xml format like this

<Lines>  
    <Item ID="IDI-1-17" ParentID="" UserCode="B24R" Description="Base"/>  
    <Item ID="IDI-1-75" ParentID="IDI-1-17" UserCode="FL.TOE" Description="Flush Toe Kick"/>  
    <Item ID="IDI-1-20" ParentID="" UserCode="B24L" Description="Base"/>  
    <Item ID="IDI-1-57" ParentID="IDI-1-20" UserCode="FL.TOE" Description="Flush Toe Kick"/>  
    <Item ID="IDI-1-63" ParentID="IDI-1-20" UserCode="FD.SH" Description="Full Depth Shelf"/>  
    <Item ID="IDI-1-53" ParentID="IDI-1-20" UserCode="CT2" Description="Knife Section Kit"/>  
    <Item ID="IDI-1-26" ParentID="" UserCode="B36-2" Description="Base"/>  
    <Item ID="IDI-1-81" ParentID="IDI-1-26" UserCode="FL.TOE" Description="Flush Toe Kick"/>  
    <Item ID="IDI-1-36" ParentID="" UserCode="SBFD36" Description="Sink Base FHD"/>  
    <Item ID="IDI-1-83" ParentID="IDI-1-36" UserCode="FL.TOE" Description="Flush Toe Kick"/>  
    <Item ID="IDI-1-40" ParentID="IDI-1-36" UserCode="SK.21-1TUB" Description="21&quot; 1 Tub Sink"/>  
    <Item ID="IDI-1-22" ParentID="" UserCode="W2424" Description="Wall"/>  
    <Item ID="IDI-1-24" ParentID="" UserCode="W2424L-GL" Description="Wall w/Glass"/>  
</Lines>  

I want to be able to create a hierarchical report. I know that I have to convert my xml into a dataset, but I'm stuck with the hierarchy part. Is there something similar to the ASP.NET AJAX Radgrid I can use ?

Thanks


pylacroix
Top achievements
Rank 1
 answered on 03 Nov 2009
39 answers
1.7K+ views
All,

I am just slightly confused about the PDF output described in the information available so far.

We are using ActiveReports 2.0 for .NET to report data that has been entered using RAD Editor and are having fits because of the insane limitations of their HTML rendering in PDF documents. What has happened is their engine will encounter HTML tags it can't understand so it just quits rendering.

1) How will PDFs be handled? As an export from the visible report? As a native viewer with the document directly rendered to PDF (like ActiveReports)?
2) Currently HTML code is very limited in ActiveReports. Will Telerik Reporting handle all the tags the RAD Editor supports? This is KILLER important. We have users importing into RAD Editor from MS Word and half the time AR just chokes and dies. To top it off, we are left to guess as to where the error occured in the report since their stack trace is totally encrypted.

Suffice it to say after absolutely pulling our hair out with ActiveReports, we would love something that works as advertised. If you hit a homer as you have with RAD Editor and RAD Combo, which we also use, we are in...

Thanks,
B
Diederik
Top achievements
Rank 1
 answered on 03 Nov 2009
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?