Telerik Forums
Reporting Forum
0 answers
102 views
Dear Sir, 
                 i have created a report with back ground color for report as well as for report viewer for good looking, but i wanna take print out without the back ground color ( transparent ). Is it possible or not, if it is possible whats the process ?

reply soon.,

With Regards
S.Suriya Narayanan
Suriya
Top achievements
Rank 1
 asked on 17 Feb 2010
3 answers
204 views
Dear Sir,
             I am using telerik report. Till now i have creates above 50 reports. So i wanna give back ground color for all reports using cascading style sheet. It is possible or not? If it is possible how it is? plz reply


With regards
S Suriya Narayanan
Steve
Telerik team
 answered on 16 Feb 2010
2 answers
715 views
Hello all, I'm writing my very first Telerik report. I am trying to hook up one of the parameters to a "Business Object" datasource.
My datasource is defined as:

Namespace DataObjects 
    Public Class DropDowns 
        Public Shared ReadOnly Property Intervals() As List(Of ListItem) 
            Get 
                Dim lic = New ListItemCollection() 
 
                lic.Add(New ListItem("Raw", "0")) 
                lic.Add(New ListItem("15 Minutes", "0.25")) 
                lic.Add(New ListItem("30 Minutes", "0.5")) 
                lic.Add(New ListItem("1 Hour", "1")) 
                lic.Add(New ListItem("6 Hours", "6")) 
                lic.Add(New ListItem("12 Hours", "12")) 
                lic.Add(New ListItem("1 Day", "24")) 
 
                Return (From li As ListItem In lic Select li).ToList 
            End Get 
        End Property 
    End Class 
End Namespace 

My report parameter is defined as (from the report codebehind):

        reportParameter1.Name = "DeviceId" 
        reportParameter1.Type = Telerik.Reporting.ReportParameterType.[Integer] 
        reportParameter1.UI.AllowBlank = False 
        reportParameter1.UI.AvailableValues.DataMember = "Intervals" 
        reportParameter1.UI.AvailableValues.DataSource = GetType(DataObjects.DropDowns) 
        reportParameter1.UI.AvailableValues.DisplayMember = "Fields.Text" 
        reportParameter1.UI.AvailableValues.ValueMember = "Fields.Value" 
        reportParameter1.UI.Visible = True 
        Me.ReportParameters.Add(reportParameter1) 

When i run the report in the browser, in the area where the report would normally render, it tells me: "The expression contains object 'Fields.Value' that is not defined in the current context." I have tried using Value, Fields.Value, Item.Value, ... and just can't figure out what to put for the DisplayMember and ValueMember to get them to pull the Text and Value properties of the ListItem objects respectively. I even tried leaving them blank, but then it tells me: "Parameter 'DeviceId' has defined AvailableValues, but no ValueMember is specified. Use 'Item' if binding to Array."

Can someone tell me what to put for the DisplayMember and ValueMember properties???
Thanks in advance! 
Aaron Abdis
Top achievements
Rank 1
 answered on 16 Feb 2010
3 answers
167 views
I have a report generated through the report wizard. I have set up three parameters, Service, Mod. Number and Status.

I have the filters working properly, but I would like for the user to have the selection to see Open, Closed or All in the status field.

The user can now select Open or Closed. If I set the MuliValue to true on the third parameter (status) and allow the user to "Select All", I get the following error on all selections:

An error has occured while processing Report: Cannot perform '=' operation on System.String and System.Collections.ArrayList.

Any help on this would be greatly appreciated.
Massimiliano Bassili
Top achievements
Rank 1
 answered on 16 Feb 2010
0 answers
252 views
Hi,
    I am generating cross-tab report for whole month. so based on status, i want to show colors. e.g. for 0-Green, 1-Red, 2-LightGreen, 3-Orange, 4-LightYellow, 5-LightPink. when i have given condition formating to first column, it wrote this many lines of code in to the designer. but i want to do it for 31 columns. what is the alternative for this? Also there is limitation of code is, my field will be changed at runtime. it is not fixed that, for txtD1, always field is Fields.D01.

please let me know. following is the code sample.

formattingRule1.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("=Fields.D01", Telerik.Reporting.Data.FilterOperator.Equal, "3")});
            formattingRule1.Style.BackgroundColor = System.Drawing.Color.Orange;
            formattingRule1.Style.Color = System.Drawing.Color.Transparent;
            formattingRule2.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("=Fields.D01", Telerik.Reporting.Data.FilterOperator.Equal, "1")});
            formattingRule2.Style.BackgroundColor = System.Drawing.Color.Red;
            formattingRule2.Style.Color = System.Drawing.Color.Transparent;
            formattingRule3.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("=Fields.D01", Telerik.Reporting.Data.FilterOperator.Equal, "0")});
            formattingRule3.Style.BackgroundColor = System.Drawing.Color.Green;
            formattingRule3.Style.Color = System.Drawing.Color.Transparent;
            formattingRule4.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("=Fields.D01", Telerik.Reporting.Data.FilterOperator.Equal, "2")});
            formattingRule4.Style.BackgroundColor = System.Drawing.Color.LightGreen;
            formattingRule4.Style.Color = System.Drawing.Color.Transparent;
            formattingRule5.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("=Fields.D01", Telerik.Reporting.Data.FilterOperator.Equal, "5")});
            formattingRule5.Style.BackgroundColor = System.Drawing.Color.LightPink;
            formattingRule5.Style.Color = System.Drawing.Color.Transparent;
            formattingRule6.Filters.AddRange(new Telerik.Reporting.Data.Filter[] {
            new Telerik.Reporting.Data.Filter("=Fields.D01", Telerik.Reporting.Data.FilterOperator.Equal, "4")});
            formattingRule6.Style.BackgroundColor = System.Drawing.Color.LightYellow;
            formattingRule6.Style.Color = System.Drawing.Color.Transparent;
            this.txtD1.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] {
            formattingRule1,
            formattingRule2,
            formattingRule3,
            formattingRule4,
            formattingRule5,
            formattingRule6});

-Thanks
Rajendra S(rajendra.soni@e-zest.in)
Allan Hill
Top achievements
Rank 1
 asked on 16 Feb 2010
3 answers
193 views
I'm dynamically building a report from a set of parameters in an xml file.  I have categories defined in one drop down list and the list of reports in a second drop down list.  Changes to ListBox1 should only update the values in ListBox2 and changes to ListBox2 should only add textbox controls to Panel1.  However, when I change the values in either box the ReportViewer refreshes the current report.  Even if I change the value in ListBox2 I have to wait for the old report to refresh before I can hit the run button for the second report.

Any ideas?

Thanks,

Paul

<

 

telerik:RadScriptManager ID="RadScriptManager1" Runat="server" LoadScriptsBeforeUI="true"></telerik:RadScriptManager>

 

 

 

<

 

telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

 

 

 

<AjaxSettings>

 

 

 

<telerik:AjaxSetting AjaxControlID="DropDownList1">
<UpdatedControls>

 

<telerik:AjaxUpdatedControl ControlID="DropDownList2" />

 

</UpdatedControls>

 

</telerik:AjaxSetting>

 

<telerik:AjaxSetting AjaxControlID="DropDownList2">

 

<UpdatedControls>

 

 

<telerik:AjaxUpdatedControl ControlID="Panel1" />

 

 

</UpdatedControls>

 

 

</telerik:AjaxSetting>

 

</AjaxSettings>

 </

 

telerik:RadAjaxManager>

 

 <

 

asp:XmlDataSource ID="dsCategory" runat="server" DataFile="~/TelerikReportsConfig.xml" XPath="ReportCategories/ReportCategory"></asp:XmlDataSource>

 

 

<

 

asp:Label ID="lblCategory" runat="server" Text="Category" Width="96px"></asp:Label>

 

 

<

 

asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="dsCategory" DataTextField="Name" DataValueField="ID" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"></asp:DropDownList>

 

 

<br />

 

 

<

 

asp:XmlDataSource ID="dsReports" runat="server" DataFile="~/TelerikReportsConfig.xml" XPath="ReportCategories/ReportCategory/Report"></asp:XmlDataSource>

 

 

<

 

asp:Label ID="lblReports" runat="server" Text="Report" Width="96px"></asp:Label>

 

 

<

 

asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="dsReports" DataTextField="Name" DataValueField="Report" AutoPostBack="True" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged"></asp:DropDownList>

 

 

 <br />

 

<br />

 

<

 

asp:Panel ID="Panel1" runat="server"></asp:Panel>

 

<br />

 

<br />

 

 

<

 

asp:Button ID="btnRun" runat="server" onclick="btnRun_Click" Text="Run Report" />

 

 

<

 

telerik:ReportViewer ID="ReportViewer1" runat="server" Visible="True" Width="100%" ></telerik:ReportViewer>

 

 

 

 

Iana Tsolova
Telerik team
 answered on 16 Feb 2010
1 answer
143 views
Hello,

Im using the reporting tool for making some industial graphs.

The graph that im looking for is something like Speed vs Time graph. Im not able to do the same with the reports. Can anyone help me in detail about wht needs to be done or point me to a detailed tutorial.

Thx a lot.
Steve
Telerik team
 answered on 15 Feb 2010
1 answer
92 views
Al salamo 3lycom

I want to use reports in silverlight so I need  Telerik.Reporting.Service.dll 
and I didint fint it .

any help please ?

Steve
Telerik team
 answered on 15 Feb 2010
7 answers
549 views
Hi

What is the best way to view Telerik reports inside a silverlight application, also i wish to pass parameters for the report from the silverlight gui ( dates etc. )

Regards,

Vassil Petev
Telerik team
 answered on 15 Feb 2010
1 answer
83 views
Hello, this going to be a very specific scenario that I can't find any documentation on.

Scenario:
Basically, I have all of the reports that we usually run in the ReportViewer saved in the database with the conditional formatting rules and columns saved there as well.  Currently, there has been a pull to begin emailing certain reports to users in excel format, with the same conditional formatting rules as the ReportViewer.

Question:
Is there a way to run a report using the telerik reporting and set up the same conditional formatting without actually visualizing it in a ReportViewer?  Once this is done saving the file to excel on the server.

Thank you for your time and help in advance.

If I need to specify anymore information on this topic please ask.

Chris McMahan
Steve
Telerik team
 answered on 15 Feb 2010
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?