or
1 answer
293 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.
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
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
139 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
Thanks,
Bruce
Chris Gillies
Top achievements
Rank 1
Rank 1
answered
on
04 Jan 2010
4 answers
289 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
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
132 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
Rank 2
answered
on
29 Dec 2009
1 answer
54 views
rt!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I need the report for silverlight
I need the report for silverlight
Schlurk
Top achievements
Rank 2
Rank 2
answered
on
29 Dec 2009
3 answers
292 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
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
1 answer
108 views
Hi
At the moment I'm testing your report- tool with VB in Visual Studio 2008.
It seems to be a great tool but I have the following problem:
As we have a very detailed right- management on the system (for example each user can have diffrent settings which fields in a table he is allowed to see) we can not simply read the datas from the MS SQL Server.
Is there a possibility to send the data from VB to a report? Can you advise what would be the easiest way?
Thanks
At the moment I'm testing your report- tool with VB in Visual Studio 2008.
It seems to be a great tool but I have the following problem:
As we have a very detailed right- management on the system (for example each user can have diffrent settings which fields in a table he is allowed to see) we can not simply read the datas from the MS SQL Server.
Is there a possibility to send the data from VB to a report? Can you advise what would be the easiest way?
Thanks
Ivan
Telerik team
answered
on
29 Dec 2009
2 answers
249 views
My report need to show a few paragraphs, I have one textbox for each paragraph. But I did not find how to set the alignment to justify. There are left center right only. Or should I use another control, if so, which control?
thanks
-phelix
thanks
-phelix
Oleg Margolin
Top achievements
Rank 1
Rank 1
answered
on
28 Dec 2009
