Questions on Reporting Forum

1 answer

98 views

Hello,

I need to design a report that is flexible. The report can have a maximum of 12 columns and a minimum of 1 column. At any point in time the report should be able to render any number of columns between 1 and 12 depending on what comes from the database.

How can I create this type of report? Can it be done?

Please, I really need help on this. At the very least please let me known if it can be done.

General Discussions

answered on 18 Jan 2010

6 answers

955 views

Could not load assembly 'Telerik.Charting, verion=1.0.2.0'

This is really weird.

I am using the latest RadControls and Reporting 1.0 SP1.
On my dev PC I do not receive the error.
When I move the files to production I get the error:

Could not load file or assembly 'Telerik.Charting, Version=1.0.2.0, Culture=neutral, PublicKeyToken=d14f3dcc8e3e8763' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'Telerik.Charting, Version=1.0.2.0, Culture=neutral, PublicKeyToken=d14f3dcc8e3e8763' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the 
current web request. Information regarding the origin and location of the 
exception can be identified using the exception stack trace below.

Assembly Load Trace: The following information can be helpful to determine why the assembly 'Telerik.Charting, Version=1.0.2.0, Culture=neutral, PublicKeyToken=d14f3dcc8e3e8763' could not be loaded.

=== Pre-bind state information ===
LOG: User = NT AUTHORITY\NETWORK SERVICE
LOG: DisplayName = Telerik.Charting, Version=1.0.2.0, Culture=neutral, PublicKeyToken=d14f3dcc8e3e8763
 (Fully-specified)
LOG: Appbase = file:///D:/Inetpub/wwwroot/
LOG: Initial PrivatePath = D:\Inetpub\wwwroot\bin
Calling assembly : Telerik.Reporting, Version=1.1.0.0, Culture=neutral, PublicKeyToken=a9d7983dfcc261be.
===

I don't have Telerik.Charting.dll that came with Reporting in my bin folder as it causes duplicate namespace errors with pages that use RadChart.dll

Any clues as to how to resolve this? (I've cleared the bin/gac on both machines and mirrored the contents, still no go).

Thanks,
Jason

General Discussions

answered on 18 Jan 2010

2 answers

317 views

Binding object properties in Detail section from a generic collection

Hello,

I've been trying to create a mock sample data set to use on a report in design-time; basically, it's a simple class that with a public static function that returns an object with a property that contains a List generic collection containing additional objects.

When binding this object in the NeedDataSource event handler, it works when binding to the object itself; however, I implemented a SubReport in the master report to list the objects contained in the List collection. Here's where the problem gets blurry.

I implemented a NeedDataSource on the report (contained in the master report as a subreport) that assigns the List collection of objects to the report. I then use the binding syntax to bind to the object's properties, but the expression does not return a value, rather it's blank. The number of displayed table cells matches the number of objects in the List collection, but no values of fields are displayed.

Example: object in List contains the "Ime" property; neither =Ime or =Fields.Ime displays the value. Also, using just any binding expression doesn't result in an error (like =Foo).

General Discussions

answered on 18 Jan 2010

0 answers

121 views

Telerik Reporting Problems.

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.

General Discussions

asked on 17 Jan 2010

2 answers

168 views

Reporting Dashboard

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

General Discussions

answered on 15 Jan 2010

1 answer

40 views

simple question

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?

General Discussions

answered on 15 Jan 2010

2 answers

99 views

problem publishing silverlight app

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?

General Discussions

answered on 15 Jan 2010

11 answers

753 views

HtmlTextBox

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

General Discussions

answered on 14 Jan 2010

1 answer

84 views

Failed to map the path '/'. ???

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.

General Discussions

answered on 14 Jan 2010

3 answers

107 views

Issue in preview

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.

General Discussions

answered on 14 Jan 2010