Telerik Forums
Reporting Forum
2 answers
143 views
I have a report that based on a very complex dataset.  If I run the select statement in the SQL manager on the hosting site I get the details needed to fill the report (which is working on my development machine also).

The report name is TSFinalPrint.vb and the vb code looks like this:

 

Try

 

 

Me.TSfinalprintDataSetTableAdapter1.Fill(Me.TSfinalprintDataSet.TSfinalprintDataSetTable)

 

 

Catch ex As System.Exception

 

 

'An error has occurred while filling the data set. Please check the exception for more information.

 

System.Diagnostics.Debug.WriteLine(ex.Message)

 

End Try

The TSfinalprintDataSet.xsd
shows the connection as TSfinalconnection(Mysettings) with the correct values (other features are using the same connection string and are working),  It shows the adapter as TSfinalprintDataSetTableAdapter and the dataset table as TSFinalprintDataSetTable.  Note that in the TSFinalPrint.vb InitializeComponent section it lists TSfinalprintDataSetTableAdapter1.  Is this correct?

The Web application runs fine and displays the report in the viewer but the form is empty.

I have gone over many of the videos and documentation and am not able to resolve this problem. 

If anyone can offer some assistance I would be thankful.

Cliff

 

Clifford Lane
Top achievements
Rank 1
 answered on 02 Sep 2009
1 answer
537 views

Hi,

I am having heaps of trouble converting an old report to one based on the new Table control.

On the old report I could create 'column' that incremented a number based on criteria of a DataItem. This used to be run against the detail.ItemDataBinding event. See example below:

    Private Sub detail_ItemDataBinding(ByVal sender As Object, ByVal e As System.EventArgs) Handles detail.ItemDataBinding  
        Dim detail As Processing.DetailSection = CType(sender, Processing.DetailSection)  
        Dim dataItem As DataRowView = CType(detail.DataItem, DataRowView)  
        'new project id  
        If m_CurrentProjectID <> dataItem("ProjectID") Then  
            'reset project total  
            If m_CurrentProjectID <> -1 Then IncrementInvoiceNo()  
 
            m_CurrentProjectID = dataItem("ProjectID")  
            m_CurrentClientID = dataItem("ClientID")  
            '  m_totalInvoiceCost += dataItem("TotalAmount")  
 
        ElseIf m_CurrentClientID <> dataItem("ClientID") Then  
            'reset client total  
            If m_CurrentClientID <> "" Then IncrementInvoiceNo()  
 
            m_CurrentClientID = dataItem("ClientID")  
            ' m_totalInvoiceCost += dataItem("TotalAmount")  
        End If  
 
        m_totalInvoiceCost += dataItem("TotalAmount")  
    End Sub 

  Now though, I am binding my data against a Prossessing.Table . i.e.

 Me.Table1.DataSource = l_dt.DefaultView 

Can I still get to the DataItems using the latest version of Reporting in a similar way to above using the Processing.Table ItemDataBound or ItemDataBinding events?

Cheers,

Damo.
Hrisi
Telerik team
 answered on 01 Sep 2009
1 answer
80 views
Is there a limit on the length of the select command text for the TableAdapter?

Is there an easy way to bind the report to a Stored Procedure without passing any parameteres (i am using vb)?
Svetoslav
Telerik team
 answered on 01 Sep 2009
1 answer
214 views
One can put their report parameters into a particaular sequence in the ReportParameter Collection Editor.  Then the report parameters are displayed in that sequence left to right in multiple rows.  But that appears to be the end of control over the parameters other than setting one or more to (in)Visible.  If you make one of the parameters not Visible, then subsequent parameters are moved up in sequence.  Food for thought as enhancements:

1. Allow parameters to be frozen in position even if one or more are made not Visible.  Thus, retaining their relative placement if that placement is important to useablity.

2. Allow programmable control of the tab sequence of the parameters.  In the case where my logical, useable tab sequence might be 1, 3, 2, 4.

Thanks,
Dan
Svetoslav
Telerik team
 answered on 01 Sep 2009
2 answers
49 views
Is it possible to use classes that were created in my web application to retrieve data for a report?  For example I have a class in the bin directory of my website called "MyClass" and there is a function in there called "MyDataset" which retrieves the exact data I want to have displayed in my report.  Do I have to copy the code from "MyClass.MyDataset" to the report project to use the code, or is there a way to reference the existing code that I have already created.  I cannot simply reference the app_code dll because it would create ambiguous namespaces when I reference the ReportLibrary in my Web app.

Thanks for the help.

Thomas Salt
Top achievements
Rank 1
 answered on 31 Aug 2009
1 answer
228 views
Attempting to create a new report using the wizard.  I select "Create new Data Source", then I select "Business Object".  Then I get to the prompt where you can choose the object to bind to.  My assembly is not listed.  It states that if you object does not appear, cancel the wizard and rebuild the project that contains your object.  Have tried that and it does not work.  That assembly is still not listed.  The assembly I am creating the report in contains a valid reference to the assembly with the business object.

Same problem occurs when I try to set the DataSource via the properties of the report.  The assembly is not listed.

I created an entirely new test solution with the same architecture and the assembly with the business object in it does appear in the wizard.  I just cannot get it to appear in the solution I need it work in.

Using:
Visual Studio 2008 Professional Version 0.0.21022.8 RTM
.NET Framework Version 2.5 SP1
Telerik Reporting Q2 2009

Any help would be appreciated.

Thanks.
Mike Booth
Top achievements
Rank 1
 answered on 31 Aug 2009
1 answer
110 views
Hi,
I am using telerik reporting and I already created a report .It works fine my problem is I added extra sections to it and I used report book to combine the reports into a single report.It wont work for some reason it will either return me the first page or the second page which is the extra sections I added .My question is there a way I can work around without using the report book because  I tried combining everything into a single report and it wont recognize when I use multiple stored procs so I had to divide them into two projects and use the report book.
I know it supports more than one stored proc because I am using 4 stored procs in my second report and it returns data so i dont understand why it wont recognise when i combine it  into a single report.Is there a work around or am I doing something wrong.
Please advise.
Thanks
Svetoslav
Telerik team
 answered on 31 Aug 2009
1 answer
166 views
Hi, i 've just installed the new tiral Telerk reporting 2009 Q2,after installing the package. There is no Telerik menu on Visual studio menu, no telerik reporting tab on toolbox, even right-click on the web site solution, the telerik templets can not be found too.
so could you please give me some advice?
My Computer is Winxp ,32-bit,english version,Visual web develop 2008.SQL express editon 2008, DotNet framework2.0,3.0,3.5 are all installed.
Hrisi
Telerik team
 answered on 31 Aug 2009
1 answer
238 views
I am using the Telerik reportViewer to generate some reports I also use the print function that comes with the viewer.  I just want to know if there is a way to get the response of the print dialog that pops when the print button is pressed.  I need to know if the user pressed the 'ok' button or the 'cancel' button in order to execute some code depending on the user selection.

Thanks for the response

Jonathan Melendez
Svetoslav
Telerik team
 answered on 31 Aug 2009
1 answer
109 views
I have a web that I have deployed and it is working fine.

I am attempting to add a telerik report to the web.  I added a class library to the web site and created the report as is described in the best practices.  The project solution now has two projects - one for the site and one for the class library.

The report displays fine in the preview so I am now tring to deploy it to the discountasp.net host.  To move to the host I have to use COPY WEB SITE.  But this option does not include the class libray for the report so I am not able to upload it.

I must not have the class that includes the defined correctly.

Can someone point me in the right direction?


Svetoslav
Telerik team
 answered on 31 Aug 2009
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
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?