Hi, I have encountered an issue using Telerik Reports v6.1.12.820. When in the report designer in VS2010 and you open the expression builder, if you cancel it before "Loading..." completes in the lower left panel VS2010 crashes.

Application: devenv.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.InvalidOperationException Stack: at System.Windows.Forms.Control.MarshaledInvoke(System.Windows.Forms.Control, System.Delegate, System.Object[], Boolean) at System.Windows.Forms.Control.BeginInvoke(System.Delegate, System.Object[]) at Telerik.Reporting.Design.Common.ExpressionBuilder.ExpressionBuilderDialog.OnLoadCategoriesComplete(System.IAsyncResult) at System.Runtime.Remoting.Messaging.AsyncResult.SyncProcessMessage(System.Runtime.Remoting.Messaging.IMessage) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessageSink) at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.DoAsyncCall() at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.ThreadPoolCallBack(System.Object) at System.Threading.QueueUserWorkItemCallback.WaitCallback_Context(System.Object) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() at System.Threading.ThreadPoolWorkQueue.Dispatch() at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

-Tony

Since Telerik Reporting does not handle XML data very well, I am trying to create a simple solution. I have some XML being returned as part of my data source. I also have a function that takes an XML String and a XPATH query String. I then loop through the nodes returned from the XPATH query and build an HTML table.
  For some reason the HTML TextBox is converting my HTML Table at runtime to a simple DIV element. Is there any way around this?


Thanks very much for your help.

Hi friends,

I am having an issue where if I configure the datasource for my report, it wokrs fine, but if I try to run the table wizard and to select that table source it throws an err as below:

<Err dailog box being prompted when trying to select the datasource form the Insert Table Wizard.png>

However,

1. At the time of configuring the database, I passed some 'desgin time parameter values' to the parameters and executed with the telerik datasource wizard, as a result 62 rows were returned as expected.
2. The stored procedure seemed to be working flawless in the SQL MS 2008R2
3. Other reporting tool works fine with the same, but tekerik does not

Here is an err shown in the telerik:

Below are some of the recent activities being observed in the SQL profiler:

------------------------------------------------------------------------------------------------

exec [<DBNAME>].[sys].[sp_procedure_params_100_managed] @procedure_name=N'<STORED_PROCEDURE_NAME',@procedure_schema=N'<SCHEMA_NAME>'

exec <SCHEMA>.<STORED_PROCEDURE_NAME> @<PARAMETER_VALUE_LIST> // this executed fine in SQL MS 2008R2 and I got 62 rows in the Telerik DataSource confguration manager, too. The parameter values were all exactly same as I had passed and were seemed to follow the constraints.

exec sp_reset_connection

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

--RPC:Completed
exec [<DATABASE>].[sys].[sp_procedure_params_100_managed] @procedure_name=N'<SP_NAME>',@procedure_schema=N'<SCHEMA_NAME>'

Works fine local get the above error on the server anyone have a solution to this? Thanks

Hi,

I am using Telerik report Q1 2012.
I put a textbox(fields is "dg1_desc") in a tableGroup, which is in a crosstable. As in the attachment file, now there are too many columns are displayed in the same row and i want to separate them in multiple rows. e.g.  4 columns per row. How to achieve that?
 Please advice! Thanks a lot!


here is my code:

// 
            // crosstab1
            // 
            this.crosstab1.Body.Columns.Add(new Telerik.Reporting.TableBodyColumn(Telerik.Reporting.Drawing.Unit.Cm(2.9260406494140625D)));
            this.crosstab1.Body.Rows.Add(new Telerik.Reporting.TableBodyRow(Telerik.Reporting.Drawing.Unit.Cm(0.59999996423721313D)));
            this.crosstab1.Body.SetCellContent(0, 0, this.textBox25);
            tableGroup4.Name = "dg2_desc1";
            tableGroup3.ChildGroups.Add(tableGroup4);
            tableGroup3.Name = "Group1";
            tableGroup3.ReportItem = this.tb_dg1;
            tableGroup2.ChildGroups.Add(tableGroup3);
            tableGroup2.Name = "Group2";
            tableGroup1.ChildGroups.Add(tableGroup2);
            tableGroup1.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.dg1_desc")});
            tableGroup1.Name = "ColumnGroup";
            this.crosstab1.ColumnGroups.Add(tableGroup1);
            this.crosstab1.Corner.SetCellContent(0, 1, this.textBox15);
            this.crosstab1.Corner.SetCellContent(0, 2, this.textBox16);
            this.crosstab1.Corner.SetCellContent(0, 3, this.textBox17);
            this.crosstab1.Corner.SetCellContent(0, 4, this.textBox18);
            this.crosstab1.Corner.SetCellContent(0, 5, this.textBox19);
            this.crosstab1.Corner.SetCellContent(0, 6, this.textBox20);
            this.crosstab1.Corner.SetCellContent(0, 7, this.textBox21);
            this.crosstab1.Corner.SetCellContent(0, 8, this.textBox22);
            this.crosstab1.Corner.SetCellContent(0, 9, this.textBox23);
            this.crosstab1.Corner.SetCellContent(0, 10, this.textBox24);
            this.crosstab1.Corner.SetCellContent(0, 0, this.lb_RPT_H_51);
            this.crosstab1.DataSource = null;
            this.crosstab1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {
            this.textBox25,
            this.tb_dg1,
            this.textBox15,
            this.textBox16,
            this.textBox17,
            this.textBox18,
            this.textBox19,
            this.textBox20,
            this.textBox21,
            this.textBox22,
            this.textBox23,
            this.textBox24,
            this.lb_RPT_H_51,
            this.textBox3,
            this.tb_org1,
            this.tb_org2,
            this.tb_org3,
            this.tb_org4,
            this.tb_org5,
            this.tb_org6,
            this.tb_org7,
            this.tb_org8,
            this.tb_org9,
            this.tb_org10});
            this.crosstab1.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Cm(0D), Telerik.Reporting.Drawing.Unit.Cm(0D));
            this.crosstab1.Name = "crosstab1";
            tableGroup15.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org10")});
            tableGroup15.Name = "org101";
            tableGroup15.ReportItem = this.tb_org10;
            tableGroup15.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org10", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup14.ChildGroups.Add(tableGroup15);
            tableGroup14.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org9")});
            tableGroup14.Name = "org91";
            tableGroup14.ReportItem = this.tb_org9;
            tableGroup14.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org9", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup13.ChildGroups.Add(tableGroup14);
            tableGroup13.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org8")});
            tableGroup13.Name = "org81";
            tableGroup13.ReportItem = this.tb_org8;
            tableGroup13.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org8", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup12.ChildGroups.Add(tableGroup13);
            tableGroup12.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org7")});
            tableGroup12.Name = "org71";
            tableGroup12.ReportItem = this.tb_org7;
            tableGroup12.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org7", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup11.ChildGroups.Add(tableGroup12);
            tableGroup11.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org6")});
            tableGroup11.Name = "org61";
            tableGroup11.ReportItem = this.tb_org6;
            tableGroup11.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org6", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup10.ChildGroups.Add(tableGroup11);
            tableGroup10.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org5")});
            tableGroup10.Name = "org51";
            tableGroup10.ReportItem = this.tb_org5;
            tableGroup10.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org5", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup9.ChildGroups.Add(tableGroup10);
            tableGroup9.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org4")});
            tableGroup9.Name = "org41";
            tableGroup9.ReportItem = this.tb_org4;
            tableGroup9.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org4", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup8.ChildGroups.Add(tableGroup9);
            tableGroup8.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org3")});
            tableGroup8.Name = "org31";
            tableGroup8.ReportItem = this.tb_org3;
            tableGroup8.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org3", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup7.ChildGroups.Add(tableGroup8);
            tableGroup7.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org2")});
            tableGroup7.Name = "org21";
            tableGroup7.ReportItem = this.tb_org2;
            tableGroup7.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org2", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup6.ChildGroups.Add(tableGroup7);
            tableGroup6.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.org1")});
            tableGroup6.Name = "org11";
            tableGroup6.ReportItem = this.tb_org1;
            tableGroup6.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.org1", Telerik.Reporting.Data.SortDirection.Asc)});
            tableGroup5.ChildGroups.Add(tableGroup6);
            tableGroup5.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] {
            new Telerik.Reporting.Data.Grouping("=Fields.year_no")});
            tableGroup5.Name = "year_no1";
            tableGroup5.ReportItem = this.textBox3;
            tableGroup5.Sortings.AddRange(new Telerik.Reporting.Data.Sorting[] {
            new Telerik.Reporting.Data.Sorting("=Fields.year_no", Telerik.Reporting.Data.SortDirection.Asc)});
            this.crosstab1.RowGroups.Add(tableGroup5);
            this.crosstab1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(28.526042938232422D), Telerik.Reporting.Drawing.Unit.Cm(1.2000000476837158D));
            this.crosstab1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.None;
            this.crosstab1.StyleName = "Normal.TableNormal";

// 
            // tb_dg1
            // 
            this.tb_dg1.Name = "tb_dg1";
            this.tb_dg1.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Cm(2.9260413646698D), Telerik.Reporting.Drawing.Unit.Cm(0.60000002384185791D));
            this.tb_dg1.Style.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(131)))), ((int)(((byte)(169)))));
            this.tb_dg1.Style.BorderColor.Default = System.Drawing.SystemColors.ActiveBorder;
            this.tb_dg1.Style.Color = System.Drawing.Color.White;
            this.tb_dg1.Style.Font.Name = "Arial";
            this.tb_dg1.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(9D);
            this.tb_dg1.Style.Padding.Bottom = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
            this.tb_dg1.Style.Padding.Left = Telerik.Reporting.Drawing.Unit.Cm(0.20000000298023224D);
            this.tb_dg1.Style.Padding.Right = Telerik.Reporting.Drawing.Unit.Cm(0.20000000298023224D);
            this.tb_dg1.Style.Padding.Top = Telerik.Reporting.Drawing.Unit.Cm(0.10000000149011612D);
            this.tb_dg1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Center;
            this.tb_dg1.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle;
            this.tb_dg1.StyleName = "Normal.TableGroup";
            this.tb_dg1.Value = "=Fields.dg1_desc";
            // 

I am using HTMLTextbox. And it is bind to and column which is having character length more than 8000. I am getting error. See in attachment. How can I fix it.

Hello,

I'm trying to use the trial version of the Reporting product.

I would like to use my existing Ria service with ADO Entity DataModel and the DomainService. I have read through the forums extensively before bothering you.

I did see many references to:

http://blogs.telerik.com/telerikreportingteam/posts/10-10-22/using-telerik-reporting-with-wcf-ria-services.aspx

But still can't figure it out from that.

Do you have some sample project that shows how to do this please?

Thank you in advance!

Scott

I just came across the standalone one. I have just migrated in the Telerik reporting. I and I was wondering after seeing the VS2k10 version and the standalone one a bit different. And even separate So please help me to understand this.

Thanks,
-Aarsh

Just thought I would share a quick observation when running the report designer in Windows 8.  See the screen capture attached below.  The window icons for closing, minimizing, etc. are not visible.  I am sure you guys are working on these sort of things.  Thanks!

Hi,

This is my first foray into the Telerik Reports so please excuse my lack of knowledge.  I am attempting to develop a report where the user can enter a start date and an end date.  I am connecting to a SQL 2008 Data Source and running SQL similar to this:

SELECT     COUNT(*) AS ProductCount, ProductDescription, StateCode
FROM         ProductSales
WHERE     (SaleDate > @StartDate) AND (SaleDate <= @EndDate)
GROUP BY  ProductDescription, StateCode
ORDER BY StateCode, ProductDescription 

When I step through the designer wizard I can connect to the data source without a problem, can add the sql without a problem, define the parameters without an issue, can set the parameters and view the results of the SQL and finish/create the report.

So I have a report with the above SQL contained in it.  OK...now I need to set the parameters so I go into the designer, select the report and edit the properties.  In the ReportParameters it has No ReportParameters so I go and add 2...

Name: StartDate 
AllowBlank = false
Visible = true
Type = DateTime

Name: EndDate 
AllowBlank = false
Visible = true
Type = DateTime

Then I save the file and build the project.  All goes well and when I preview the report indeed the StartDate and EndDate inputs are there.  I select the same (or any other) dates that I chose when I ran the wizard above and click the preview button.  The report is generated but no data is returned.  It is like the report totally ignores the parameters.  

If I code into the SQL the dates the report works fine.  I think I am doing something wrong with the parameters in the SQL...there they are @StartDate etc. and in the parameters editor I enter StartDate (can't enter the @StartDate as it is invalid).

In a nutshell I can see the data in the wizard or if I hard code the dates but once I get to the designer I cannot see them.  Any thoughts on what I am missing?  Your assistance is appreciated!

Thanks in advance,

Kelvin