Hi all,

One of the requirements for converting our existing reports is that they be backwards compatible.  We currently have an assortment of reports that include xsl reports and crystal reports.  Both use xml data as their datasource.  I have looked at several examples in the forums that convert xml to built in classes for report design and how to convert the xml to a dataset at runtime.  None of the examples showed how to do this with multiple level xml shown in the attached example.  Can you help me with converting the attached example for use in a report.  And, is there a simple way to do this?  I have hundreds of reports to convert.

Thank You for your help

Here is the xml example:

<creditreport ReportCategory="2" ReportType="2" ReportTitle="Credit Summary Report" ExposureDate="Most Recent" Associate="All Business Associates" CreditExposureProfile="All Contracts" PhysicalExposure="Length of Contract" FinancialExposure="Length of Contract" Note="Note Field" CreatedDate="12/12/2005 10:23:30 AM">
 <associate SellerID="29" AssociateID="EA0452AB-873A-485F-A81A-6174EB65D4E2" AssociateName="Bill's Test" ExposureDate="12/6/2005">
  <profile BeginningBalance=".00" BuyerCreditLimit="No Credit" EstimatedValue=".00" AvailableCredit="No Credit" />
  </associate>
 <associate SellerID="29" AssociateID="F8C42696-9F6C-4876-B7FF-BE673313DE30" AssociateName="BP" ExposureDate="12/6/2005">
  <profile BeginningBalance="100000.00" AssociateID="F8C42696-9F6C-4876-B7FF-BE673313DE30" CreditProfileID="52D0EC5D-857B-4560-9A8B-BDF496FABEB1" ProfileName="1,000,000 LC" BuyerCreditLimit="1000000" EstimatedValue="2273096.11" AvailableCredit="-1273096.11" />
  <profile BeginningBalance="200000.00" AssociateID="F8C42696-9F6C-4876-B7FF-BE673313DE30" CreditProfileID="CD4612B0-A30D-4D49-A972-CEDD52695318" ProfileName="Default Contracts" BuyerCreditLimit="5000000" EstimatedValue="1174770.40" AvailableCredit="3825229.60" />
  </associate>
 <associate SellerID="29" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" AssociateName="Duke" ExposureDate="12/6/2005">
  <profile BeginningBalance="300000.00" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" CreditProfileID="6DAB56EB-6D39-4F1B-A654-D9E651D536EA" ProfileName="Default" BuyerCreditLimit="500000" EstimatedValue="30307948.20" AvailableCredit="-29807948.20" />
  <profile BeginningBalance="400000.00" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" CreditProfileID="9C559583-291F-411A-8E09-C0F7DF1ADFB5" ProfileName="No Credit" BuyerCreditLimit="No Credit" EstimatedValue="-246830681.93" AvailableCredit="No Credit" />
  <profile BeginningBalance="500000.00" AssociateID="2E63F5E4-5DF2-4609-9046-0CC25B33AC49" CreditProfileID="BF9A2D43-E227-4488-A016-2787001EFE71" ProfileName="Unlimited" BuyerCreditLimit="Unlimited" EstimatedValue="2640000.00" AvailableCredit="Unlimited" />
  </associate>
  </creditreport>

When using a HtmlTextBox I am unable to utilize an Expression to call a User Function that returns a string. I get the following error:

Name cannot begin with the '-' character, hexadecimal value 0x2D. Line 1, position 8.

Now if I use a built in function like Trim, which also returns a string, it works fine... if I replace the HtmlTextBox with a regular Textbox it also works fine... so what is it about the HtmlTextBox that I'm missing...

Hi we are using both charting objects Telerik.Chart and Telerik.Reporting.Chart in the Asp.net Ajax controls chart we use the prePaint method to hide the top and bottom YAxis Labels on our bubble chart via this method:
THis method does not appear to be available in the Reporting chart though. Anyone know a workaround?

Hi, telerik team,
I drag table control with 3 column  to a report and set the NeedDataSource event as:
 private void MonthTable_NeedDataSource(object sender, EventArgs e)
        {
           (sender as Telerik.Reporting.Processing.Table).DataSource = GetDataSource();

        }

         DataTable GetDataSource()
        {
            DataTable tablelocal = new DataTable();
            tablelocal.Columns.Add("Value", System.Type.GetType("System.Int32"));
            tablelocal.Columns.Add("LabelA", System.Type.GetType("System.String"));
            tablelocal.Columns.Add("LabelB", System.Type.GetType("System.String"));
            
            tablelocal.Rows.Add(new object[] { 5, "Item 1", "A" });
            tablelocal.Rows.Add(new object[] { 4, "Item 2", "B" });
            tablelocal.Rows.Add(new object[] { 3, "Item 3", "C" });
            tablelocal.Rows.Add(new object[] { 2, "Item 4", "D" });
            tablelocal.Rows.Add(new object[] { 1, "Item 5", "E" });
            return tablelocal;
        }
       
The generated report is only a empty spreadsheet  with 3 column and 5 rows(not include the head).
Do you have any advice so that I can see the real table data in the spreadsheet?

Thanks a lot!

Qixiong

Trying to get columns to line up in Telerik report (Q2 - 2009.) The report was auto-generated by the wizard and the width was increased. I cannot figure out how to get the columns to line up properly. They are rendering all out of whack. I've attached a screenshot to demonstrate.

Hi

Is it possible to use icons / image buttons in place of the drop down list on the web report viewer.

I thought I saw something on this a few months ago, but cant find any inf o now.

Andy

Hi,

I am using Barcode control from Telerik reporting. I placed some texts and one barcode per detail. Generation of the report leads to out of memory exception and the application growed up to >1GB in memory :-( When I replaced the Barcode, the behavior become normal.

The data source I use has cca 2000 records and there were 6 records per page. Also, I used "Code128" as a symbology.

What do you suggest to do, when I need to print out a lot of labels with barcodes?

TIA
Jaroslav Bucek

Hello,
as I know at this time the page numbering is not working in Excel export.

I've a Textbox like with this expression "=PageNumber + ' / ' + PageCount" and when I export to Excel I've the text "1/1" on every page.

I'd like to keep the page numbering in other format so I don't want to remove it from my report.

Do you have a solution to remove it from Excel and keeping it in other format ?

It would be helpfull to have a parameter (in rendering parameters) to tell telerik reporting to ignore or not display or not render the field with PageCount or PageNumber when exporting to Excel.

Regards
Gilles

I am new to Telerik and have been given the task to produce a report that contains 60000 rows with approx 20 columns per.  The dataset comes from a single query from a single table.  The preview/report viewer chokes and eventually stops after 10-12 minutes.  After I add parameters/filter, I can successfully display 4000 rows, and I have not tried to display any amounts inbetween.  Is there an approxmate cut-off for the amount of data Telerik will handle?  I ask this so I can plan my next course of action, since I need to render the full report.

Is there a good way to handle larger sets of data in Telerik?  My superior says the entire 60,000 row report has to be able to be displayed in one report.  Any ideas to handle such a request?

Thanks