Questions on Reporting Forum

1 answer

380 views

Change textbox dynamically on databinding

I'm sure this is an easy fix...but it has defeated me so far.

I am trying to set the text in a textbox dynamically at runtime according to what the current datarow items contain. I have been trying to create a simple test to get the syntax worked out but have been having no luck. I have been unable to locate the answer in the forums either.

My report consists of a main report which contains a sub-report. The sub-report is where the tbtest textbox is located. I am using SQL Datasources for both the main and sub reports.

The following code is located in the sub-report codebehind (VB):

    
                Private Sub detail_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles detail.ItemDataBound 
        
                    'Get the detail section object from sender 
        
                    Dim section As Telerik.Reporting.Processing.DetailSection = DirectCast(sender, Telerik.Reporting.Processing.DetailSection) 
        
                    'From the section object get the current DataRow 
        
                    Dim row As System.Data.DataRow = DirectCast(section.DataObject.RawData, System.Data.DataRow) 
        
                    If (row("Hospital") <> Nothing) AndAlso (row("Surgeon") <> Nothing) Then 
        
                        Dim testTextbox As Telerik.Reporting.Processing.TextBox = DirectCast(section.ChildElements.Find("tbtest", True)(0), Telerik.Reporting.Processing.TextBox) 
        
                        testTextbox.Value = "Hospital and Surgeon exist" 
        
                    End If 
        
                End Sub

When I try to run the report I get the following error:
An error has occured while processing DetailSection 'detail':
Unable to cast object of type 'DataObject' to type 'System.Data.DataRow'.

Any help would be appreciated. Thanks.

General Discussions

answered on 17 Jun 2010

0 answers

98 views

Adding a new Barcode format to Telerik control

We currently use barcode format FREE3OF9 but it doesn't look like that is avalible in the Telerik barcode control. Is there away to add that to the control if I have Font file?

General Discussions

asked on 16 Jun 2010

1 answer

112 views

Initial Reporting Configuration for Web Server

Hi,

I am new to the tool, and need some help.

My application environment is ASP.NET 2.0 for a website.

Adding files to the bin folder:

- I have placed 3 dlls in the folder (Telerik.Reporting.dll, Telerik.ReportViewer.WebForms.dll, and LandWatchReport.dll

- The last listed file is generated in the bin of the class project that produced a report that I could run on the local machine.

Creating References

- Question: While I can create a reference to the LandWatchReport.dll, I am unable to Add Reference to the Telerik dlls - the add dialogue works, they just don't show up being added. Is this a problem?

- Question: The support website shows a References Node in the Visual Studio instance. I do not know how to reveal the References Node in the Solution Explorer.

Creating Initial Report View

- I created a new web form and inserted the report viewer object.

- Now, it is unclear how I point the report viewer to the dll associated with the LandWatchReport.dll.

- It is unclear how I make reference to a report name within that dll. (it make reference to identifying assemblies, but I don't have assemblies)

I will have more questions, but hopefully someone can indulge me on these rather basic topics to get going.

Thanks.

General Discussions

answered on 16 Jun 2010

4 answers

260 views

Convert WebPage to PDF

Hi Telerik Team,

Is there any possibility to convert a web page to PDF using Reporting tools?

Thanks in advance

General Discussions

answered on 16 Jun 2010

2 answers

133 views

Getting ObjectDataSource data object

Hi all,

I have a report with an objectdatasource bound to its datasource. I know the type of the object used into this objectdatasource. I would like to get this object from the report's code behind to execute some tasks but I can't find it anywhere nor how to do this.

Can you please help me ?

Thanks

Regards,

Steeve

General Discussions

answered on 16 Jun 2010

0 answers

108 views

printing problem in server

Hi,

I am facing printing problem in server.I wrote this code

                    using (System.Windows.Forms.PrintDialog printDlg = new System.Windows.Forms.PrintDialog())         
            {         
            printDlg.AllowSomePages = true;         
            printDlg.AllowCurrentPage = false;         
            printDlg.UseEXDialog = true;         
                     
            if (System.Windows.Forms.DialogResult.OK == printDlg.ShowDialog())         
            {         
            Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();         
            reportProcessor.PrintReport(report, printDlg.PrinterSettings);         
            }         
            }         

this code working in local system like developer system, printing is good.But it's not working on server please it's very argent how to solve this problem.

thanks and regards
shanker.B

General Discussions

asked on 16 Jun 2010

1 answer

118 views

Summarizing Group Data (Newbie question!)

I'm just learning Telerik and am fairly new with C# and VS as well, so my apologizes for how simple a question this must be.

I have two tables: Order_Header and Order_Details. Every order has a single entry in Order_Header and multiple entries in Order_Details (one for each product purchased).

Order_Header: [OrderID], [OrderDate], [OrderNumber], [Taxes], [ShippingCost], [OrderTotal], [GST], [PST], [HST]
Order_Details: [DetailID], [OrderID] (ref Order_header), [ProductID], [Quantity], [SellingPrice]

My report is grouped by [Order_Header].[OrderNumber] (unique to each individual order).

The Group Header shows [Order_Header].[OrderNumber], [Order_Header].[ShippingCost], .[GST], .[PST], .[HST]

The report details shows [Order_Details].[ProductID], [Order_Details].[Quantity], [Order_Details].[SellingPrice]

Ideally the report footer will summarize Quantity, Selling Price, ShippingCost, GST, PST, HST

My challenge is this: If i do SUM(ShippingCost) in the report footer, it sums it once per every item in Order_Details, rather than once per Order_Header. Is there a solution to this? Sum by group or somesuch? I'm also not above accumulating a variable in the codebehind if someone is kind enough to explain how.

Thanks!

P.S. Windows 7, Visual Studio 2008, Telerik Reporting Q1 2010, and Chrome/Firefox/Opera/Safari/IE for browser

General Discussions

answered on 15 Jun 2010

1 answer

125 views

Reporting Parameters but default to all

I'm new to Telerik Reporting and I have a report that using parameters and it works great. Now I need to figure out or find an example of how to default the report to show all the data and allow users to filter down the data by using the parameters. I have 3 paramters but I don't want to force the users to use all 3 parameters. Any help would be much appreciated.

General Discussions

answered on 15 Jun 2010

1 answer

128 views

Run time Sorting

Hello,

A table created in a report has a sorting property. When I click on the smart link button, the screen opens up where I can choose different columns of the table and their direction(ASC or DESC).

My question is can I access these 2 properties(Expression and Direction) at run time.
When I write in my code "table1.Sorting." it doesn't give me any and expression or direction field.
Please suggest,

Thanks

General Discussions

answered on 15 Jun 2010

1 answer

241 views

Using Telerik Reporting in a WebSite

I am new to Telerik and trying to create a report to use in a ASP.Net Website using VS 2008. After "Add New Item" > "Telerik Report Q1 2010", and then Run the wizard to pull data from a SQL database, and set up the report in the Designer tab, I can not see any results in the Preview or Html Preview. Note for some reason the report wants to be in the App_Code folder, not sure if that means anything or why it wants to be in that folder. I also tried to make a page with a report viewer on it to see if it can desplay the results, and found that the report view can't even find an associated report in the project. Any help you could give would be great.

General Discussions

answered on 15 Jun 2010