Telerik Forums
Reporting Forum
2 answers
237 views
Hello,

In general I am very please with telerik; however, it seems like VB.NET is an afterthought in regards to samples...

The following is the code supplied for VB.NET to connect a chart to a datasource and seems useless as far as correct code....not that it can't be modified but just a bit annoying.

This is from ms-help://telerik.reporting.3.2/Reporting/BuildingDatabindDatabase.html

Imports System  
Imports Telerik.Reporting.Chart  
 
Public Partial Class Report1  
 Inherits Report  
 Public Sub New()  
  """ <summary>  
  """ Required for telerik Reporting designer support  
  """ </summary>  
  InitializeComponent()  
 
    End Sub 
 Private Sub chart1_NeedDataSource(sender As Object, e As System.EventArgs)  
 " create a datasource  
   Dim sqlDataSource As New SqlDataSource()  
   sqlDataSource.ID = "myDataSource" 
   sqlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString  
   sqlDataSource.SelectCommand = "SELECT CategoryName, SUM(ProductSales) AS TotalSales FROM [Product Sales for 1997] GROUP BY CategoryName" 
 Dim procChart As Telerik.Reporting.Processing.Chart = DirectCast(sender, Telerik.Reporting.Processing.Chart)  
 procChart.DataSource = "myDataSource" 
" Set the column for data and data labels:
 " Each bar will show "TotalSales", each label along  
 " X-axis will show "CategoryName.  
 chart1.Series(0).DataYColumn = "TotalSales'
 chart1.PlotArea.XAxis.DataLabelsColumn = 'CategoryName'
 " assign appearance related properties  
 chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300  
 chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.BlueViolet  
 chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(30)  
 
End Sub 
End Sub 
 End Class 


John
John S.
Top achievements
Rank 1
 answered on 05 Jan 2010
2 answers
124 views
I am trying to follow the video tutorial for using parameterized queries here, but the tutorial seems to revolve around using a SqlDataAdapter which the video shows as showing up in the Telerik Reporting menu in the toolbox, but in my Telerik Reporting Q3 2009 there is no SqlDataAdapter.

How do I get this to show up?

Help! I'm under a time crunch!!
James
Top achievements
Rank 1
 answered on 05 Jan 2010
3 answers
102 views
Hello,

Has anyone connected to Reporting Q2 2009 using Enterprise Library 4.1 DAAB?

I've reviewed the Code Examples and Videos, 22Reporting ConnectingToData however I was unable to find a way.

Are there any short online examples of this type of data connection?

Many thanks
Steve
Telerik team
 answered on 05 Jan 2010
2 answers
144 views
How di i get a report when we select only one report parameter i.e., remaining report parameters are not to be selected
Nagesh Mynedi
Top achievements
Rank 1
 answered on 05 Jan 2010
3 answers
112 views
Dear Support Please attach a example of Sample  Reporting
using Database .(Siverlight)

Thanks and Regards,
Krishna Surapaneni
Steve
Telerik team
 answered on 04 Jan 2010
2 answers
190 views
I recently downloaded the trial of the reporting component, and have created a report project in my solution with a couple of reports. Upon running the web site I get the "failed to map path" error, which upon searching I see is a security issue - http://www.telerik.com/community/forums/reporting/telerik-reporting/failed-to-map-the-path.aspx. Are you actually saying that to run your report viewer I have to run as an Administrator, when we should actively be encouraging users to run without elevated rights? Do I, and the rest of the developers, now have to Run as Admin every time, sometimes forgetting, then having to close VS and reopen it?

In the replies to the other thread you state that it's the WebConfigurationManager causing the error and that you can't touch that, which is true, but not helpful. The error is because you loop through the handlers to ensure that Telerik.ReportView.axd is present and it's that and only that, that requires elevated permissions as far as I can see. there really any reason to check that the handler is present? You could easily document the requirements for the handler; I have to add the handler anyway, so why check for its presence? There may be a very good reason why you need to check, and I'd love to hear it, but all I can see is that you throw an exception when initialising the viewer if the handler isn't configured.

I love the reporting framework you've built, but this is causing me to think again about using it.

Dave
Dave
Top achievements
Rank 1
 answered on 04 Jan 2010
1 answer
258 views
Hi Telerik Team,

                 I have a portal which has the functionality to print the details displayed in the UI. I want to implement the same functionality of printing the data in the UI using the Telerik Reporting. I was able to implement the same by creating a report using the Report Wizard and then viewing the same using ReportViewer and then was able to print the data.

                   My question here is "How do i create a report on the fly through the code which includes the designing of the report based on the multiple parameters passed to the report and also display the data from a database?" . I have gone through the Self paced training material provided in the Telerik site but was not able to implement the same.

          My portal is already up and running and i just want to incorporate Telerik Reporting into the portal and implement the Reporting functionality and then print the report. The Report parameters will wary from page to page of the portal and the Report should be available across all the pages of the portal.
 
            Please provide me with some inputs on how to implement the same.

Thanks,
Raja Sekhar.
Steve
Telerik team
 answered on 04 Jan 2010
1 answer
81 views
Dear Sir/Madam,

Using the latest release of Telerik Reporting (3.2.9.1211), the direct print functionality from the Silverlight ReportViewer results in Page Not Found (404) when using DateTime ReportParameters, which only can be seen when using a sniffer tool, like HttpWatch. I've several parameters defined, after removing the DateTime parameters the Adobe print dialog is shown.

The version of the Silverlight Controls which I use is 2009.3.1127.1030.

Hopefully this can be solved in the next release.


Regards,

Wietse Kok
The Netherlands
Steve
Telerik team
 answered on 04 Jan 2010
1 answer
109 views
I've recently purchased the Telerik radtools software, which I like very much, and now I'm considering using the report tools.  This might be a biased forum but how does the Telerik Reporting software compare to Crystal?  I seem to run into frequesnt problems with Crystal on my web applications and have never really liked using it.  Should I abandon Crystal and get Telerik?  What are the benefits of switching?

Thanks,
Bruce
Chris Gillies
Top achievements
Rank 1
 answered on 04 Jan 2010
4 answers
270 views
Hi,

I'm about ready to switch from Crystal Reports to Telerik Reporting. I know some features are not supported but my change is more aimed at simplified operations and distribution and Telerik Reporting greatly appeals me.

It does appeal me, but man, i have to say, some things are just not right... Let me explain how i see the designer after working with it for 2 days now.

First, data integration is not easy. I have a bunch of DataSets already built but i was never able to run the report by simply assigning the dataset to the report. I even looked at the training videos and although it works in the videos, it never worked for me. Why? I could never figure out. Thats not the worst problem, i could easily add programmatic code to the report and test it that way and it works fine.

The worst problem is the sluggish designer and it's features...

1) My god, you guys need to drastically improve it. I have been designing 1 report in 2 days while with crystal reports, i could design a super complex report with tons of fields in a matter of hours. I'm afraid my machine will crash and burn and it's not a hardware problem, i'm running a practically brand new 4 gig o ram / Core 2 Duo 2.4 Ghz machine with Windows XP. Having 30 fields on the form and a few lines makes the designer slow down dramatically to the point that dragging fields stop working and i have to click and reclick several times to be able to drag...

2) Integration of shapes is atrocious... If youve used CR before, you know how the canvas concept work, drag a line from one section to the other and it still works. With Telerik's report designer (although i understand why, it's a programmatic issue), i cannot span a control in two sections, thus creating grid like layout becomes a PAIN.

Maybe the inclusion of a few controls to help drawing gridlike reports such as invoices could help a lot... Also, a few tutorials on the aspect of placement of the different controls could help. I've had a lot of problems to place my controls and align grid lines together without causing gaps or overlapping elements. In fact, my invoice now features overlapping elements since i have no choice at all or the invoice cannot be migrated from CR to TR.

3) Missing features

3.1) Capability to strech a section to fill the rest of the page. (only for windows output, web can't support this yet because CSS is not respected correctly) For example, in my invoice, i'd like to strech a group footer section to fill the rest of the page. It would look much nicer to my client than having the invoice stop at the middle of the page if i have only 2 lines in their invoice...

3.2) Many group headers... In CR, i can have several detail/group section (headers and footers). It would be great to be able to have access to several of these. Now you probably wonder why, it's because of 3.1. In a document you may wish to allow one section to span from top to bottom to fill gaps but you may want some items to stick at the bottom of the gap filling and this gap filling could be applied to the first group footer and the second group footer could contain the page tail for the group.

3.3) Support for PageNumber and PageTotal anywhere in the document not just headers and footers.

For the rest, great work, i love telerik controls and it will not prevent me from switching to telerik at all. We just decided to abandon Infragistics and Crystal Report due to their poor service and i hope we will get great service from Telerik.

Thanks
Steve
Telerik team
 answered on 04 Jan 2010
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?