Telerik Forums
Reporting Forum
1 answer
85 views
I have a report that includes a row/col table of data + a couple charts. I bind the data to the report via an ObjectDataSource.

The problem I'm facing is that some of the data needs to be HtmlEncoded prior to display in the ReportViewer but should not be encoded when exported to PDF/XLS/etc. How do I go about doing this? Is there something passed to the ObjectDataSource that will allow me to know what the target is for the returned data?
Steve
Telerik team
 answered on 01 Feb 2012
2 answers
246 views
Hi

my report has two sqlDataSources: first is bound to report as report data, the second is bound to multivalue parameter as data source (and selected value from this parameter is used as a filter). Now I need to set default value for that parameter using expression, but fields are available only from first (report bound) data source. Is it possible to address field from second data source in expression? If not, how to select default value from second expression programmatically?

Thank you in advance,

Jiri
Jiri
Top achievements
Rank 1
 answered on 31 Jan 2012
1 answer
204 views
Hi.. I'm using Telerik Reporting Q2 2011.

I have a problem with my Telerik reporting bar chart.  Everything works perfectly , however i need my chart to have different color for each bar.
I've set my chart LegendDisplayMode to itemLabels, make sure my series pallete is not set and write these codes

public WebCategoryBarChart()
      {
           //
           // Required for telerik Reporting designer support
           //
           InitializeComponent();
 
           this.chart1.Series[0].Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;
 
           Color[] barColors = new Color[8]{
               Color.Purple,
               Color.SteelBlue,
               Color.Aqua,
               Color.Yellow,
               Color.Navy,
               Color.Green,
               Color.Blue,
               Color.Red
           };
           int i = 0;
           foreach (ChartSeriesItem item in chart1.Series[0].Items)
           {
               item.Appearance.FillStyle.MainColor = barColors[i++];
           }
 
          
           //
           // TODO: Add any constructor code after InitializeComponent call
           //
       }

But still the default color of the bars is still there..

How should i go about this..?
Elian
Telerik team
 answered on 31 Jan 2012
1 answer
128 views
I wrote some code to create a report in a wizard like fashion.   Something changed in the architecture of the system and now I need to support a dynamic connection to a datasource.  In other words I don't know what database I'm connecting to at design time.  The only thing I can think of to do is to inherit the Report object into a new class that supports my dynamic connection and then serialize the whole thing.  I can't think of any other way to do it.  Any other ideas?  Is there a way to iterate the SqlDataSources in a report?

Thanks,
Darren
Elian
Telerik team
 answered on 31 Jan 2012
1 answer
57 views
Hi.

I have a datasource following this structure:

XNode1
    YNode11 
    YNode12 
    YNode13
XNode2
    YNode21
    YNode22
    YNode23
XNode3
    YNode31
    YNode32

I have created a report that contains a list to the node collection and then a list within that list to bind to the respective nodes' sub nodes.

However, the resulting report is like this

XNode1
    YNode31
    YNode32
XNode2
    YNode31
    YNode32
XNode3
    YNode31
    YNode32

YNode type is a string. XNode type is a class that provides a collection of strings via a iterator (yield return).
I am not using any grouping. This is a list within a list.

My instinct was that the inner list was not bound correctly. However, I cannot think of any way that would produce this behavior. If I dump the bound data object in LINQPad, it displays correctly (so I know the iterators are working).
YNode is displayed by a Textblock using "=Fields.Item".
Tormod
Top achievements
Rank 1
 answered on 31 Jan 2012
3 answers
171 views
I'm trying to connect to a SQL CE database to run a report.  Not trying to design it or anything.

When I connect to a normal database it works but when I connect to:

Data Source=c:\UserProfiles\admin\Datasets\DEMODATASET2011.sdf;Persist Security Info=True;

I get an error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

The CE database is working fine otherwise.

Does my connect string need to be different?

Thanks,
Darren
Darren
Top achievements
Rank 1
 answered on 30 Jan 2012
3 answers
152 views
Hi all,

I'm going to create a report on SQL CE 3.5 but telerik says:

The specified provider is not supported:
Microsoft.SqlServerCe.Client.3.5

Not sure why, and what can I do with that?

Thank you.

P.S.
VS 2010, Telerik 4.1.10.921
CEFRA
Top achievements
Rank 1
 answered on 30 Jan 2012
2 answers
302 views
I'm sure I'm missing something obvious here, but I'm trying to set the text on a HtmlTextBox on its ItemDataBound event.  I set the Value property, but the output does not change from the default text.  This works with a TextBox, so I'm not sure what is different with the HtmlTextBox.


private void htmlTextBox1_ItemDataBound(object sender, EventArgs e)
        {
            Telerik.Reporting.Processing.HtmlTextBox txtBox = (Telerik.Reporting.Processing.HtmlTextBox)sender;
 
            txtBox.Value = "Updated";
        }


Yet the HtmlTextBox outputs the default value.

Thanks for any help / clarification.
Paul
Top achievements
Rank 1
 answered on 30 Jan 2012
0 answers
122 views
Is there a way I could use a telerik reporting window to display a web pag? I have a series of charts that are rendered with the HighCharts javascript library and would like to display them in a report like way with paging. Is this possible?
Michael
Top achievements
Rank 1
 asked on 30 Jan 2012
1 answer
675 views
In my 2 page report I want first page orientation as portrait and second page in landscape. Page size can also be different. How can I achieve it?
Steve
Telerik team
 answered on 30 Jan 2012
Top users last month
Miljana
Top achievements
Rank 2
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Bronze
Cynthia
Top achievements
Rank 1
John
Top achievements
Rank 1
Iron
Mozart
Top achievements
Rank 1
Iron
Veteran
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?