I have a multi-select Visible report parameter with AllowBlank set to True. When the user de-selects all values in the multi-select, they get a validation error indicating that the parameter is required. Why is this?

Note, if I select AllowNull for the parameter, I get a "NULL" checkbox next to the parameter in the UI, which looks completely ridiculous. I don't want to set it to NULL, I just want to not select any values...

How can I fix this?

We have a report with a chart works fine loading it from the class and setting the data source at run time and load it in the report control works fine. The same report we are serializing(Telerik.Reporting.XmlSerialization.ReportXmlSerializer)

and storing it in the database and deserializing it and then setting the data source at run time but when we load it in the report control it says have no or empty data series. 

Hey All,

I have a text field that I need to format as a date.  Sometimes this field is null, in which case, I can just display an empty value.

I'd like to be able to do this:

=IIf(IsNull(ESR_UDF116, "") = "", "", IIf(Len(ESR_UDF116)=8, Substr(ESR_UDF116,4,2) + "/" + Substr(ESR_UDF116,6,2) + "/" + Substr(ESR_UDF116,0,4),""))

The logic being, if the value is null, then return an empty string.  If the value is not null, then do the formatting.  My formatting hinges on the value being 8 characters long, so I have another embedded IIf that checks the Len of the field.  And that is the problem.

Per the documentation, the functions are evaluated completely *first* and the results passed to the functions.  In this case, when my field is Null, the Len function throws an error and hoses up my report.

It seems logical to me that the functions would be evaluted in precendent order so that the Len call would *never be made* if the field value is Null.

Has anyone ever achieved this desired result?

For a null, show nothing, for a non-null, show a formatted result that involves evaluating on the field itself.

how to bind datasource from C# to the report and load report file .trdx?
please give me an example..
thank you

Hi Telerik,
Please help me how to achieve this:

I have a stored procedure (MS SQL 2008) which is accepting some parameters and returns series of ids of for example invoices. I need to print every invoice on a new paper. I can create  one report for one invoice, but I don't know, how to cycle throug the ids to print all invoices. Or may be, I can create one long for example MS Excell document containing a page breaks to print every inoivce on a new paper. 

Thank you for any help. 

Tom

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";
            //