Questions on Reporting Forum | Telerik Forums

or

13,623 questions

1 answer

115 views

Teleric ReportViewer

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

General Discussions

answered on 29 Dec 2009

1 answer

45 views

does telerikreport support silverlight??

rt!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I need the report for silverlight

General Discussions

answered on 29 Dec 2009

3 answers

279 views

ReportProcessor.Render Obsolete

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

General Discussions

answered on 29 Dec 2009

1 answer

121 views

Table Problem

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

General Discussions

answered on 29 Dec 2009

1 answer

94 views

send data from vb to report

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

General Discussions

answered on 29 Dec 2009

2 answers

234 views

TextBox TextAlign Justify

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

General Discussions

answered on 28 Dec 2009

1 answer

106 views

Using .NET Code

Hello,

Being new to reporting, I was wondering if the Telerik Reports offer the ability to add code to the report definition, similar to the code window in SSRS... I'm looking for something above the common expressions feature that allows you to embed code in for helper methods, additional processing, whatever...

Thanks.

General Discussions

answered on 28 Dec 2009

2 answers

145 views

SubReport Multi-Column or something like it

Hello,

I aware that the multi-column setting does not work for a sub report but I'm looking for ideas on other possible implementations that would achieve a similar result. My report has some general details on a user and then lists 30+ items below for that user. The sub report of items is just a list of the names, no extra detail is required. So without another column there's a lot of empty space and a rather long list of names.

Is there any way I could generate some sort of list or table of all the names without using the multi-column setting? Perhaps programatically using a html textbox?

Cheers,
Damien

General Discussions

answered on 28 Dec 2009

6 answers

297 views

Chart Y Axis labels problem When AutoWrapText=True

Hi,

Is there any possibility of setting the width of axis label when AutoWrapText=true? Text moving to next line even though there is space in first line. Please find attached files. Please suggest me how can I achieve like attached file.

Regards.

B.Sridhar

General Discussions

answered on 28 Dec 2009

1 answer

234 views

Multiple Tabs in a Report

Hi,
I'm new to reporting with Telerik.
I want to generate a report like the way an excel sheet looks like... I mean a report with Tabs (multiple sheets).
Each tab holding a new page displaying a new report for the parameters passed just once.

Is there a way to generate a report which has tabs in it.
Please let me know if you have any suggestions about this.

Thanks
Sowji

General Discussions

answered on 23 Dec 2009

Top users last month