Telerik Forums
Reporting Forum
0 answers
149 views
Hi

  We are using Telerik reporting to generate reports and we are facing this problem that one particular report which brings out around 8000 records is not getting exported to any format. When I try to export, it just giving out blank page in pdf ,excel etc. on webserver.
  This behaviour is very different when I try to reproduce it in my local development machine and it didnt even generate a report in the report viewer and ofcourse the pdf , excel are blank again.
We know this particular report and its code are working fine because it is generating report for other input parameters which are generating around 200 to 500 records. We are not getting any errors and it just simply not displaying any data, this is really frustrating.

We are making some complex calculations in the stored procedure for this report , the code for which is I am attaching below. When I execute this particular stored procedure it is generating 8000 records in around 2 mins and everything seems to be working fine at the database end. I even checked extending connection string time out period but its of no use.

USE [GBE_GBSDB]  
GO  
/****** Object:  StoredProcedure [dbo].[usp_Report_DistributorInvoiceSummary]    Script Date: 01/07/2010 11:08:57 ******/  
SET ANSI_NULLS ON 
GO  
SET QUOTED_IDENTIFIER ON 
GO  
ALTER procedure [dbo].[usp_Report_DistributorInvoiceSummary]  
@ManufacturerId int,  
@InvoiceId int,  
@StartDate datetime,  
@EndDate datetime  
AS     
BEGIN 
SELECT  max(dbo.CustomerSpend.InvoiceNumber) as InvoiceNumber,  
   convert(varchar(12),max(dbo.CustomerSpend.InvoiceDate),101) as [Date],  
   max(dbo.CustomerSpend.SellerProductNumber) as Item,  
   case when isnull(ltrim(rtrim(max(dbo.Product.PackSize))),'')=''   
   then max(PackSizeAlias.PackSize) else max(dbo.Product.PackSize) end as PackSize,  
   max(CustomerSpend.SellerMfgCustomerName) as Manufacturer,  
   max(CustomerSpend.SellerProductBrandedLabel) as DistributorBrand,  
   max(dbo.Product.ProductDescription) as [Description],  
   max(dbo.CustomerSpend.SellerMfgCustomerPN) as MFC,  
            max(dbo.SubmissionCouponSpendRelation.ActualCalculatedCases - CAST(isnull(SplitQty,'0') AS FLOAT)/ProductQtyPerCase) as CaseQty,  
   isnull(max(dbo.CustomerSpend.TotalItemPrice),0) as TotalCost,  
   MAX(dbo.CustomerSpend.SellerCustomerId) as AccountNum,  
   MAX(CustomerSpend.BuyerActualCustomerId) as RestaurantId,  
   MAX(CustomerSpend.SellerActualCustomerId) as DistributorId  
into  #tb  
FROM        dbo.SubmissionInvoice  
INNER JOIN dbo.Coupon  
ON   SubmissionInvoice.CouponId=Coupon.CouponId  
INNER JOIN   dbo.CouponGroupRelation   
 ON   dbo.Coupon.CouponId = dbo.CouponGroupRelation.CouponId  
INNER JOIN   dbo.CouponProductGroup  
 ON      dbo.CouponProductGroup.CouponProductGroupId = dbo.CouponGroupRelation.ProductGroupId  
INNER JOIN   dbo.ProductGroupRelation  
 ON      dbo.CouponProductGroup.CouponProductGroupId = dbo.ProductGroupRelation.ProductGroupId  
INNER JOIN   dbo.SubmissionCoupon   
 ON   dbo.SubmissionInvoice.SubmissionInvoiceId = dbo.SubmissionCoupon.InvoiceId  
inner join dbo.SubmissionCouponSpendRelation  
 ON      SubmissionCouponSpendRelation.SubmissionCouponId = dbo.SubmissionCoupon.CouponSubmissionId  
inner JOIN   dbo.CustomerSpend  
 ON  SubmissionCouponSpendRelation.CustomerSpendId = dbo.CustomerSpend.CustomerSpendId  
inner JOIN dbo.Product  
 ON  dbo.CustomerSpend.ActualProductId=dbo.Product.ProductId  
 and  dbo.Product.ProductId=ProductGroupRelation.ProductId  
left join  (select  ProductPackSizeAlias.ProductId,  
       MAX(ProductPackSizeAlias.PackSize) as PackSize  
    from  ProductPackSizeAlias  group by ProductId  
    ) as PackSizeAlias  
on    Product.ProductId=PackSizeAlias.ProductId  
WHERE  (DATEDIFF(S, dbo.Coupon.StartDate, CustomerSpend.InvoiceDate) >= 0)   
AND   (DATEDIFF(S, dbo.Coupon.EndDate,CustomerSpend.InvoiceDate) <= 0)    
and   CouponTypeId=1   
and   CustomerSpend.SrcMfgActualCustomerId=@ManufacturerId  
and   SubmissionInvoice.SubmissionInvoiceId=@InvoiceId  
group by CustomerSpend.CustomerSpendId,Coupon.CouponId   
select  #tb.*,  
   Restaurant.CustomerName as CustomerName,  
   Distributor.CustomerName as DistributorName,  
   Distributor.CustomerLogoBinary as DistributorLogo,  
   CL_C.Address1 as Address1_c,  
   CL_C.Address2 as Address2_c,  
   CL_C.City AS City_c,   
   USState_C.USStateName as state_c,  
   CL_C.Zipcode AS Zipcode_c,  
   CL_C.PrimaryPhoneNumber AS Phone_c,  
   CL_D.Address1 as Address1_D,  
   CL_D.Address2 as Address2_D,  
   CL_D.City AS City_D,   
   USState_D.USStateName as state_D,  
   CL_D.Zipcode AS Zipcode_D,  
   CL_D.PrimaryPhoneNumber AS Phone_D   
from  #tb  
left join Customer as Restaurant  
on   #tb.RestaurantId=Restaurant.CustomerId  
left join Customer as Distributor  
on   #tb.DistributorId=Distributor.CustomerId  
left join (select * from CustomerLocation where CustomerLocation.CustomerLocationId in (select MAX(CustomerLocation.CustomerLocationId) from CustomerLocation group by CustomerLocation.CustomerId)  
   )as CL_C  
ON   CL_C.CustomerId=#tb.RestaurantId  
left join USState as USState_C  
on   CL_C.USStateId=USState_C.USStateId  
left join (select * from CustomerLocation where CustomerLocation.CustomerLocationId in (select MAX(CustomerLocation.CustomerLocationId) from CustomerLocation group by CustomerLocation.CustomerId)  
   )as CL_D  
ON   CL_D.CustomerId=#tb.DistributorId  
left join USState as USState_D  
on   CL_D.USStateId=USState_D.USStateId  
END 
GO  
 
We really appreciate if some one from telerik team can help on this ASAP.

Thanks,
Kumar Pindiprolu.
kumar pindiprolu
Top achievements
Rank 1
 asked on 17 Jan 2010
2 answers
222 views
I am in the process of converting an Access database application to a web application and now am down to the reports.  I have been able to create my report class and set up parameters for the user to specify at run time which will work for the simpler reports but some of the selection criteria and the supporting information they want to see may be too complicated for that method.  What I would really like to do is create my own reporting dashboard where they can select the report and specify the criteria then run the report.  I've been able to bind a report to a dataset returned from my reporting DAL but only with static criteria I pass in.  How can the report class read the criteria specified in a dashboard on my .aspx page to be passed to the DAL?

Tim
Tim
Top achievements
Rank 1
 answered on 15 Jan 2010
1 answer
74 views
Hi - I am evaluating using telerikreporting in a silverlight app.  I have looked at lots of docs and samples, and need help to get a general understanding.  I have a VS2008 solution that contains three projects:

- a project containing my report classes (here I design the reports)
- the silverlight application project
- the silverlight web project

... I publish it all to the webserver, and hit the app in a web browser and can see the report viewer, and report, everything is good.

... what I want to do next is to better control the report from the silverlight app.  For exmaple in my silverlight app there are two date picker controls.  The user hits these to set the start and end date.  This is used to narrow search results for records the report will display.  When the user is ready, they press the report button that opens a telerikreportviewer containing the report.

But my report shows the dataset from the query I created when authoring the report.  But of course I want the query to be limited by the users's specified date range.

Is this a pattern I can accomplish using telerikreporting and silverlight - or can the query only be set when the report is first authored?














jtby
Top achievements
Rank 1
 answered on 15 Jan 2010
2 answers
156 views
when I publish my app to IIS and run from internet explorer my silverlight report viewer crashes due to:

ReportServiceUri

 

="../reportservice.svc"

... but runs fine from VS2008 on the same server.  In this case VS2008 and IIS are all on the same server.  I am using a report that has no dataconnections, only a single textbox in the header, to rule out data conection string problemes.  reportservice.svc exists in the correct location when I publish my app, everything looks good acccording KB article regarding publishing reporting apps, not sure what else to look at.  Any ideas? 






 

jtby
Top achievements
Rank 1
 answered on 15 Jan 2010
11 answers
901 views
Hello,

I'm having difficulty with populating the new HtmlTextBox-item with data from a databasefield. Whatever I seem to do, I'm getting errors when then report is rendered. 
What I''m having in designtime in the code window of the HtmlTextBox (as I do in normal Textboxes) is this: = Fields.Verslag.
What I'm getting after rendering is an error (in the HtmlTextBox) which says: An error has occured while processing HtmlTextBox 'HtmlTextBox1': The 'BR' start tag on line 1 does not match the end tag of 'html'. Line 1, position 2069.
However, when I copy and paste the data from the field in the code window manually , the rendering is correct.
What am I doing wrong, I'm trying for hours now.

regards, Geert 
Steve
Telerik team
 answered on 14 Jan 2010
1 answer
120 views
I dont know how to explain this problem, as I am also passed whole day scrathcing me head what am I missing....
To be very simple, I am receiving this error whenever I tries to view my report. I tried to use technique like in 'telerik examples', that is single page dynamically loads any report on the basis of repor name in query string...then I tried other things like this:

if

 

(!IsPostBack)

 

{

ReportCollection.Event.

EventReport report1 = new ReportCollection.Event.EventReport();

 

ReportViewer1.Report = report1;

}
I didnt work too......I read all the threads over here on this issue, and did try all the suggested solutions....but nothing is happening.
Please let me know about it.....I am getting late to deliver website to my client.

I am using Windows 7 under Administrator privileges.

Steve
Telerik team
 answered on 14 Jan 2010
3 answers
157 views
Hi,

I have created a class library to get the records from database. I have given a project reference to  report class library. Its working when the website was running. But the preview is not showing the output. It showing the error as "Could load the file or assembly.....".

I have already saw some example. But they either using the code that retrieves the record from database in report library itself or using dataset.

So kindly tell me the solution and is there any alternative for this requirement?

Regards,
Katte.

Steve
Telerik team
 answered on 14 Jan 2010
2 answers
262 views
I have a Windows Forms App and I am getting the error TIF rendering format is not available when trying to use the RenderReport method of the ReportProcessor class.

Here is my code:
ReportProcessor reportProcessor = new ReportProcessor(); 
RenderingResult report = reportProcessor.RenderReport(strFileType, reportBook, null); 
using (fs = new FileStream(fileLocation, FileMode.Create)) 
{ 
    fs.Write(report.DocumentBytes, 0, report.DocumentBytes.Length); 
} 
 

strFileType is set to tif
reportBook is a report book that contains 2 reports

I have both Telerik.Reporting and Telerik.RepotViewer.WinForms referenced in my app

Am I doing something wrong?


Shonda
Top achievements
Rank 1
 answered on 14 Jan 2010
0 answers
161 views
I have created some reports using Telerik.

But no matter how i format my fields any decimal values i want to display are rounded to whole numbers.

example i want to display 0.83 but it keeps getting rounded to 1.00

Please help
H
Top achievements
Rank 1
 asked on 14 Jan 2010
2 answers
493 views
I have a "Master" report with a subreport in its Detail section.  While in the report designer for the "Master" report if I position the subreport control against the left margin of the Details section then the report displays as expected.  However, when I "Indent" the subreport control the other controls in the detail section display properly however the subreport appears on the next page.  By the way, the "Master" report was created using the report wizard and the "Left Aligned" report layout was selected.

Is this a bug or am I missing something?  I have attached screenshots to help.
Darren Shafer
Top achievements
Rank 1
 answered on 13 Jan 2010
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?