Telerik Forums
Reporting Forum
1 answer
138 views
Hello All,

We're thinking about switching to Telerik reporting for some of our new products, but we have a basic requirement. We have to be able to allow the customers to dynamically change and save off report templates run time. Does Telerik reporting support this? If I have say a report that involves 10 columns in 4 tables, can I allow the customer to add a few columns, maybe a table, change some ordering, and then save that off? Obviously there is coding infrastructure around this web page and the like, but I wasn't sure how flexible telerik reports are. Also, if anyone can point me towards sample code similar to what I've mentioned that would be great.

Thanks a bunch,
Ryan
Steve
Telerik team
 answered on 04 Mar 2010
0 answers
59 views
I am having an issue when trying to create a report, I am using the report wizard. The wizard itself works fine but after the report is generated I am getting over 80 or so build error and no report is shown. I attached a screen shot of one of the errors to which takes me to the .Designer.vb code.

What seems to be happening is the classes might not being named correctly. I had to add the 1 at the end of both class names below.

Partial

 

Public Class CMSC_WEB2DataSet1

 


 

Partial Public Class CMSC_WEB2DataSetTableAdapter1

 

This took all but 2 errors away.

The errors I cannot seem to figure out deals with the line below. The error is with - ds.GetSchemaSerializable.

<

Global.System.Diagnostics.DebuggerNonUserCodeAttribute()> _

 

Public

 

Shared Function GetTypedDataSetSchema

 

Dim dsSchema As Global.System.Xml.Schema.XmlSchema = ((ds.GetSchemaSerializable)) **Error

 



<

Global.System.Diagnostics.DebuggerNonUserCodeAttribute()> _

 

 

 

Public

 

Shared Function GetTypedTableSchema

 

 

Dim

 

dsSchema As Global.System.Xml.Schema.XmlSchema = ((ds.GetSchemaSerializable)) ** Error

 



Would anyone have an idea as to why this might be happening?
Why the report is not naming the class correctly?
Could I be doing something wrong?

thanks
Dwayne Starkey
Top achievements
Rank 1
 asked on 03 Mar 2010
2 answers
148 views

Hello,
I'm fairly new to Telerik Reporting.  I am more familiar to ActiveReports by DataDynamics.  Their software package has an event called Detail_Format that allows you access to the detail section of each individual item in the subreport.  Is there a way to do this in Telerik SubReports?

I have attachd an image to help explain my issue.
There is 1 MainReport and 1 ColorReport (subreport).  I set the datasoure for the SubReport object (List<>) and all the data shows up int eh COlorReport properly. 

I want to now change the color of the Shape object in the detail section of ColorReport based on individual data in the datasource.  When I add a breakpoint in the method SubReport_ItemDataBinding, the subReport has all the items from the datasource list. 

It seems to me that SubReport in MainReport should have the full list, but ColorReport should only know about one data item at a time.

Could you please explain how to do this?
Thanks!
Sarah

Sarah
Top achievements
Rank 1
 answered on 03 Mar 2010
1 answer
110 views
Hi;
How can I generate a chart based on crosstab table? Like Pivot Chart from Pivot Table.

Thanks
Steve
Telerik team
 answered on 03 Mar 2010
1 answer
87 views
Hi;
I have a report using crosstab and it works perfectly.
However, I want now to have it display a list of records where total is zero (just like what a left join in SQL do when it displays zero sales for one sales person for a specific product! like in http://www.w3schools.com/sql/sql_join_left.asp)

Is they anyway to do so.

Thanks
Steve
Telerik team
 answered on 03 Mar 2010
1 answer
95 views
Hi Team

I'm currently working on a report using Telerik's reporting for silverlight. Everything works find,  ReportsParameter are being sent in RenderBegin event method and the report is being rendered the way it has to be.

If possible, how could I set programmatically the settings of the printer:
- I want to print in A5 format.
- I want to select a printer from the available printers on client side.
In other words: I want to access printer's preferences.

In the forum, I saw capabilities for asp.net, what about Silverlight?

So far, I've used ReportViewerModel to "model.PrintReportCommand.Execute(null) to execute automatically the print command when the report is displayed. The Printer's dialog is being displayed and that's what I need to avoid.

Regards
Ed




Massimiliano Bassili
Top achievements
Rank 1
 answered on 03 Mar 2010
1 answer
98 views
Tags Supported HtmlTextBox.
I am developing for the System User, the ability to create custom reports (letter), from within the html, but the HtmlTextBox not support images, you can add support for the img tag in HtmlTextoBox?
Steve
Telerik team
 answered on 03 Mar 2010
1 answer
152 views
We have a sub-report that when rendered will span multiple pages;  the render format is PDF.  For each page, we would like to render a group header and footer (separate from the page header and footer).  To do so, we have created a group within the sub-report without a grouping criteria and set the PrintOnEveryPage property of the GroupHeaderSection to true.  However, we are facing several issues.

1) When we set the PrintOnEveryPage property of both the GroupHeaderSection and the GroupFooterSection to true, the application hangs on the call to the Telerik.Reporting.Processing.ReportProcessor.Render method.  The hang always occurs if the PrintOnEveryPage property is set to true for the GroupFooterSection, regardless of the setting for the GroupHeaderSection.
2) When set the PrintOnEveryPage property of JUST the GroupHeaderSection, the Render method returns and the report is rendered and the header is rendered on every page, however, the details portion overlaps the header, partially obscuring it.

Note that the sub-report itself contains 3 sub-reports as we display 3 sets of data on the same page (for comparative reasons). 

We are using Q2 2008 version of Telerik Reporting.  Has anyone else experienced the same issue?

regards,

DS
Massimiliano Bassili
Top achievements
Rank 1
 answered on 03 Mar 2010
1 answer
444 views
Hi! I have a problem, i would like to databind a PIE in a report, my code for binding a pie chart manually is like SAMPLE A, but i would like to assign YValue from a database, like the SAMPLE B, where i databind a bar chart from a database...

SAMPLE A
private void chart1_NeedDataSource(object sender, EventArgs e)  
        {  
            chart1.Width = Unit.Pixel(300);  
            chart1.Height = Unit.Pixel(300);  
            ChartSeries s = new ChartSeries();  
            s.Name = "NameOfSerie";  
            s.Type = ChartSeriesType.Pie;  
            for (int i = 1; i < 6; i++)  
            {  
                ChartSeriesItem item = new ChartSeriesItem();  
                item.YValue =i* 3.5;  
                item.Label.TextBlock.Text = "A" + i.ToString();  
                s.Items.Add(item);               
            }  
            s.Appearance.LegendDisplayMode =ChartSeriesLegendDisplayMode.Nothing;  
            chart1.Series.Add(s);  
        } 

SAMPLE B
private void chart1_NeedDataSource(object sender, EventArgs e)  
        {  
            string sql =  @"SELECT TOP 10 Production.Product.ListPrice, Production.Product.Name, Production.Product.ProductID FROM Production.Product";  
            string connectionString ="Data Source=localhost;Initial Catalog=AdventureWorks;Integrated Security=True";  
            SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString);  
            DataSet dataSet = new DataSet();  
            adapter.Fill(dataSet);  
            ChartSeries series = new ChartSeries();  
            series.DataYColumn = "ProductID";  
            series.DataLabelsColumn = "Name";  
            chart1.SeriesOrientation=ChartSeriesOrientation.Horizontal;  
            chart1.Width =Unit.Pixel(300);  
            chart1.Height = Unit.Pixel(300);  
            chart1.Series.Add(series);  
            (sender as Telerik.Reporting.Processing.Chart).DataSource = dataSet.Tables[0].DefaultView;   
        } 


I would like to fill a pie chart from a database, instead of a bucle...I mean...Something similar to SAMPLE B, where you can assign a DataYColumn, a field from the datasource...


Thanks for your time and i hope to find some help here...
Peter
Telerik team
 answered on 03 Mar 2010
2 answers
132 views
I know this issue has been addressed a few times, but I'm having issues still with my attempt. I'm trying to avoid using the wizard for my dataset and do everything programatically.

Here's what I have in the report code-behind:
Public Sub New()  
        InitializeComponent()  
         Try  
 
            Dim connMAS As SqlConnection = New SqlConnection()  
 
            Dim cmd As SqlCommand  
            Dim commLoadPortalUserInfo As SqlCommand = connMAS.CreateCommand()  
            connMAS.ConnectionString = Convert.ToString("some connection string")  
 
            connMAS.Open()  
            cmd = connMAS.CreateCommand()  
 
            cmd.CommandText = "storedprocedurename" 
            cmd.CommandType = CommandType.StoredProcedure  
 
            cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar)  
            cmd.Parameters("@CompanyID").Value = Me.ReportParameters("CompanyID").Value  
 
            Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)  
            Dim ds As DataSet = New DataSet  
 
            da.Fill(ds)  
            Me.DataSource = ds 
 
            connMAS.Close()  
              
        Catch ex As System.Exception              
            System.Diagnostics.Debug.WriteLine(ex.Message)  
        End Try  
    End Sub 
And here's what I have on my ASPX page calling the report:
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load  
        If (Not Page.IsPostBack) Then  
            ReportViewer1.Report = New RosterReport()  
            ReportViewer1.Report.ReportParameters(0).Value = "Value" 
              
            ReportViewer1.RefreshReport()  
        End If  
 
    End Sub  
End Class 
And the parameter value never makes it to the report, so I get a blank one. If I execute the report and statically replace the Me.Parameter.Value with a static string value, everything works perfectly.

I've also tried many other variations of the code above and even tried creating a new instantce of my RosterReport and then binding it to the reportviewer to no avail.

Edit: It seems like the initial report is getting instantiated, but a version of the report with the parameter values assigned is never created. I thought that was the purpose of "refresh report"

Any help would be greatly appreciated.

John Cobb
Top achievements
Rank 1
 answered on 02 Mar 2010
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?