Telerik Forums
Reporting Forum
3 answers
132 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
215 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
299 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
88 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
145 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
293 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
1 answer
143 views
Hi to all,

I am new to Generate  TelericReports.  I want to display Report for Selected Item in Dropdownlist  programmatic ally.
My dropdownlist  items are 'ProductName, CategoryName,Manufacturer. When I select  Product(dropdownlist Item) it should display product related  report.  I created a store procedure like this .. 

if(@Filter='ProductName')
SELECT d.ProductID as 'Product ID',S.ProductName as 'Product Name',Count(d.ProductID) as Sold from S2Commerce_StoreOrders o
inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
--inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
inner join S2Commerce_Products s on s.ProductID=d.ProductID  where  convert(varchar(10),OrderDate,101) >= @fromdate and  convert(varchar(10),OrderDate,101) <= @todate  group by d.ProductId,S.ProductName
else if(@Filter='CategoryName')                                    
SELECT S.CategoryID as 'Category ID' ,C.CategoryName as 'Category Name',Count(s.ProductID) as Sold  from S2Commerce_StoreOrders o
 inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
 --inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
 inner join S2Commerce_ProductCategories s on s.ProductID=d.ProductID
 inner join S2Commerce_Category c on c.CategoryID=s.CategoryID where  convert(varchar(10),OrderDate,101) >= @fromdate and  convert(varchar(10),OrderDate,101) <= @todate group by  S.CategoryID,C.CategoryName
else if(@Filter='Manufacturer')  
SELECT  s.ManufacturerID as 'Manufacturer ID',m.ManufacturerName,count(s.ManufacturerID) as Sold from S2Commerce_StoreOrders o
 inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
 --inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
 inner join S2Commerce_Products s on s.ProductID=d.ProductID
 inner join S2Commerce_Manufacturer m on m.ManufacturerID=s.ManufacturerID where   convert(varchar(10),OrderDate,101) >= @fromdate and  convert(varchar(10),OrderDate,101) <= @todate  group by s.ManufacturerID,m.ManufacturerName
else if(@Filter='Day') 
SELECT convert(varchar(10),OrderDate,101) as 'Day',count(o.OrderID) as #Orders,sum(d.UnitCost * d.Quantity) as TotalAmount,sum(ShippingTotal)  as TotalShipping,sum(DiscountAmount) as DiscountAmount,sum(TaxAmount) as TotalTax from S2Commerce_StoreOrders o
 inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
 --inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
 inner join S2Commerce_Products s on s.ProductID=d.ProductID where   convert(varchar(10),OrderDate,101) >= @fromdate and  convert(varchar(10),OrderDate,101) <= @todate  group by convert(varchar(10),OrderDate,101)
else if(@Filter='Month') 
SELECT DateAdd(Month, DateDiff(Month, 0, OrderDate), 0)  as 'Month',count(o.OrderID) as #Orders,sum(d.UnitCost * d.Quantity) as TotalAmount,sum(ShippingTotal)  as TotalShipping,sum(DiscountAmount) as DiscountAmount,sum(TaxAmount) as TotalTax from S2Commerce_StoreOrders o
 inner join S2Commerce_StoreOrderDetails d on d.OrderID=o. OrderID
 --inner join S2Commerce_PayHist p on p.OrderID=o.OrderID
 inner join S2Commerce_Products s on s.ProductID=d.ProductID where   convert(varchar(10),OrderDate,101) >= @fromdate and  convert(varchar(10),OrderDate,101) <= @todate  group by  DateAdd(Month, DateDiff(Month, 0, OrderDate), 0) 

Regards,
Venkateswararao


Schlurk
Top achievements
Rank 2
 answered on 29 Dec 2009
1 answer
61 views
rt!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I need the report for silverlight
Schlurk
Top achievements
Rank 2
 answered on 29 Dec 2009
3 answers
298 views
Hi, I just upgraded to 2009 Q2 and now I am getting obsolete message on:

reportBytes = Telerik.Reporting.Processing.ReportProcessor.Render(FileType, Report, Nothing, mimeType, FileType, encoding)

Tells me it's no longer a static function.. but if I  create an instance of the ReportProcessor:

 

Dim

RP As New Telerik.Reporting.Processing.ReportProcessor

 

reportBytes = RP.Render(FileType, Report, Nothing, mimeType, FileType, encoding)

I get syntax error:

"Access of shared member, constant member, enum member or nested type through an instance; Qualifying expression will not be evaluated."

How should I use this now?

Thanks

Ivan
Telerik team
 answered on 29 Dec 2009
1 answer
134 views
Hi,

I want to create a very simple report using a table and business object databinding. All I want is to have borders around the header and details, as can be seen from attached.

When I create a table, using the wizard, and put into the Detail section the header row of the table is repeated per detail line in my datasource. Without a table the report is fine, except for the borders.

Where should I put the table? The Detail section, Report Header? Any sample projects that you can send? I could not find anything in the demos section.

Thanks
Ivan
Telerik team
 answered on 29 Dec 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?