Telerik Forums
Reporting Forum
1 answer
73 views
Does anyone knows if the reporting component give users the ability to adjust the cells when render on a winform?

Take this sample for instance:-
http://demos.telerik.com/reporting/examples/crosstab/defaultcs.aspx

I would like to manually adjust one of the Grand Total. Assume this is render on a winform.
Is this possible?
Steve
Telerik team
 answered on 06 May 2009
1 answer
137 views
I have a datatable that I am using to populate a pie chart.  It has two columns Fund and Amount.  I want the labels to populate with the Fund name AND the #%...i.e. "American Funds 10%"

The problem I am having is retrieving the Fund name from the data row.  My chart uses a table adapter as the datasource.

private void chart1_NeedDataSource(object sender, EventArgs e) 
        { 
            Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart; 
            chart.DataSource = this.richPlayDBDataSetTableAdapter1.GetData(Convert.ToString(chart.Report.Parameters["SSN"])); 
                         
             
            DataRowView row = (DataRowView)chart.DataItem; 
             
            Telerik.Reporting.Chart defChart = (Telerik.Reporting.Chart)chart.ItemDefinition; 
            defChart.Series[0].DefaultLabelValue = string.Format("{0} #%", row["Fund"]); 
        } 

I keep getting "Object reference not set to an instance of an object" error.  The above code works perfectly if I substitute row["fund"] for just a normal string. How can I capture the actual row value?

Rich



Steve
Telerik team
 answered on 06 May 2009
2 answers
136 views
There is an excellent example in the Help files on how to display a report as PDF directly to browser.

Is there an example on how to do the same thing as a JPEG image?

I see the examples on how to save the image to disk and I thought I knew how to render the byte array as an image. But so far I haven't been successful.

Steve
Telerik team
 answered on 06 May 2009
5 answers
264 views
I need a chartitemdatabound event handler to change how my labels are displayed for a pie chart.  The following code I saw in another forum is throwing an error.

this.chart1.ItemDataBound += new EventHandler<ChartItemDataBoundEventArgs>(chart1_ItemDataBound);

Cannot implicitly convert type 'System.EventHandler<Telerik.Reporting.Charting.ChartItemDataBoundEventArgs>' to 'System.EventHandler' 

Am I missing a using directive or something obvious?

Rich




Steve
Telerik team
 answered on 05 May 2009
1 answer
260 views
Hi,,
I can not able to add datarows in to the table, I am assign dataset programatically,
Below is mycode extract, Please give me advice.

Partial Public Class DAReport
    Inherits Telerik.Reporting.Report
    Public Sub New(ByVal InvoiceID as integer)
        InitializeComponent()
        ShowInfo(InvoiceID)
    End Sub

Sub ShowInfo(ByVal InvoiceID as integer)
 Dim oView As System.Data.DataView = Nothing
 Dim strQuery As String = "select * from invoice_lineItems where invid="& InvoiceID
 Table1.DataSource = getDataSet(strQuery, "invoice_lineItems")
 Table1.DataMember = "da_invoice_lineitems"
End Sub

  

Public Function getDataSet(ByVal strQuery As String, ByVal strTbl As String) As System.Data.DataSet

        Dim ds As System.Data.DataSet = New DataSet
        Try
            Dim da As New MySqlDataAdapter
            Dim bind As New BindingSource
            Dim strConn As String = ConfigurationManager.AppSettings("ConnectionString")
            Dim objConn As MySqlConnection = New MySqlConnection(strConn)
            objConn.Open()
            da = New MySqlDataAdapter(strQuery, objConn)
            da.FillSchema(ds, SchemaType.Source, strTbl)
            da.Fill(ds, strTbl)
            objConn.Close()
            Return ds
        Catch ex As Exception
            Return ds
        End Try
    End Function
End Class


Regards
Raju
Steve
Telerik team
 answered on 05 May 2009
1 answer
120 views
I have a simple report set up that groups the records, and in the group footer I have an aggregate total displayed.  When exporting to CSV, this aggregate is exported, but I'd rather the CSV export include only the grouped field and the data in the detail section.  Is this possible?

Josh
Steve
Telerik team
 answered on 05 May 2009
5 answers
468 views
I have a question concerning sub reports.  What I want the report to do is this...  loop through a set of records, if a value in the record is 'Summary', then I want it to display my Summary subreport.  If the value is 'DataEntry', then I want it to display my DataEntry subreport.  There could be any number of records in my original set, so the final report could be Summary, DataEntry, DataEntry, Summary, DataEntry, or it could be just DataEntry.  You get the point.  I'm thinking that to do this, I should have one Master Report and then programically add sub reports depending on the value in the record.  I have the looping done, no sweat, it's the adding of the subreports that I can't seem to grasp.  Any ideas, thoughts, or suggestions?
Steve
Telerik team
 answered on 04 May 2009
1 answer
136 views
I copied over the Terik Reporting DLL's for for a web implementation.  It works great, however when I tried to use SQL Server Reporting Services (on the same box), I am getting the following error:

Could not load file or assembly 'Telerik.Reporting, Version=3.0.9.311, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies. The system cannot find the file specified.

Does anyone know why this is happening?  I'm especially confussed because Telerik Reports and SQL Server Reporting Services are two completely different applications.

Please help, Frank
 
Steve
Telerik team
 answered on 04 May 2009
1 answer
101 views
Hi,

I installed telerik reporting in my system and i am using visual studio 2005. When i start "new project in windows application", i can able to see all the reporting toolbox with all reporting controls but when i start "new website"  i can able to see only report viewer.

Basically i want to develop report for the website. Frankly speaking i don't have any idea developing reporting using telerik reporting. I developed using Business intelligence for sql reporting services.

Please tell how to start with telerik reporting. 

And also i want to place a button in my web page, when i click on the the button i want to display a report.

Hope my problem will be solved as soon as possible. 

Thanks.

Best Regards
Arshad
Vassil Petev
Telerik team
 answered on 04 May 2009
1 answer
164 views
I've made the necessary changes to devenv.exe.config to get our design time ability to preview reports working.  Yeah!  This makes it much faster to get reports designed rather than change/compile/run.  We use Subsonic so I had to add sections to the dev config that told it where to find the subsonic "stuff".

However I have a question (looking for ideas) on setting the datasource at design time versus production.

To get design-time preview working, I added code after the InitializeComponent() method to hit a business object and return a dataset which I assign to the report datasource.  This call just hits the business object method with some dummy data - enough to give the preview something to work with.

But in production this call won't do.  For production I comment out this assignment, and do it in the real code (web page presenter logic) that is instantiating the report viewer, prompting for real values, and showing the report.  So for production (or stage - basically whenever NOT previewing at design-time) I comment out the assignment in the report .cs file after the InitializeComponent(), because the datasource assignment happens elsewhere.

Is there a better way to do this?  I don't want to have to remember to comment out the datasource assignment and if I do, I assume the datasource assignment is happening twice which I don't want either.

I can't just put the production datasource assignment logic directly into the report .cs file because it's part of another business module (using MS MVP pattern) with lots of other stuff going on that I don't want to have in my report library module.

Any ideas?

Thx
Steve
Telerik team
 answered on 04 May 2009
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?