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

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?

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?

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
 

Hi,

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

Hii Team ,
I have master report which pass parameter to a subreport sometimes the subreport don't have data in it
i need to make the subreport area and headers hidden when no data represented in the subreport
i tried this 

Telerik.Reporting.Processing.

SubReport subReport;

subReport = (Telerik.Reporting.Processing.

SubReport)sender;

if (subReport.InnerReport.Items.Count == 0)

subReport.Visible =

false;

but it not working i need to know what should i do to make it hidden when no data

We have a web application (vs2008) running the latest versions.

At run-time the report viewer works fine.  Its datasource is set to a businessobject method that returns a dataset.

However at design-time we cannot get things working.  At preview we get an error about it not being able to find a section of the application config file.

The business object uses SubSonic which has info in the web.config file.  The previewer is not finding this info.

Is there a "trick" to making this same config info available to the report designer so that we can preview?

Thx

I have a couple of questions on styling reports in Telerik Reporting Q1 2009.

First, is there a way to style a table control so that all the rows and cells have a border? Or do I have to define a style for this and then apply it to my header / row cells?

Is it possible to apply a style selector to a table control? How about the table control header or rows, specifically?

Hi,

  I´ve some dificult to resolv one problem, the cenarius is:

  - I´ve a common header report
  - Detail section, and footer

  On my detail I have some controls anfter I want a sub report to detailing same records and after I have more controls.

  The problem is that the sub report lost the datasource, and on databinding occurs the error.

  My Source:

   Fisrt Report


My SubReport


Someone can help me?

Thanks