Hello Telerik Team,

I am getting the error."An error has occured while processing textbox:The expression contains undefined
function call FormType()".

I have a report..where in i used a user function called "FormType".
My datasource  for teh report is sharepoint list.

I am passing a parameter to the user function in the code.My user functions retrieves three values(one each time based on the conditions)But when i select the user function..in the edit expression dialog box..
i am not writing any parameter inside the user function as i am not sure what to write there.

I have gone through http://www.telerik.com/support/kb/reporting/designing-reports/the-expression-contains-undefined-function-call-myuserfunction-error.aspx
and thought i might fall in 2nd cateogry..but unable to find a solution for that

Please help me.

Here is the code.

InitializeComponent();
            string strType;
            SPSite oSite = new SPSite("spsiteurl");
            SPWeb oWeb = oSite.OpenWeb();
            string[] parameters = { "10", "100", "1000" };

            Telerik.Reporting.ReportParameter param1 = new Telerik.Reporting.ReportParameter();
            param1.Name = "ItemID";
            param1.Type = Telerik.Reporting.ReportParameterType.Integer;
            param1.AllowBlank = false;
            param1.AllowNull = true;
            param1.Text = "ItemID";
            param1.Visible = true;
           

            this.ReportParameters.Add(param1);

            SPQuery qry = new SPQuery();
            SPList oList = oWeb.Lists["customlist"];
          

            string camlQuery = CreateCAMLQuery(parameters);

            qry.Query = camlQuery;

            SPListItemCollection listItemsCollection = oList.GetItems(qry);

            StringBuilder sb1 = new StringBuilder();
           
                  for (int i = 0; i < parameters.Length; i++)
                {
                    foreach (SPListItem item in listItemsCollection)
                    {
                        if (parameters[i] != "")
                        {
                            sb1 = new StringBuilder();
                            if (parameters[i] == item["ItemID"].ToString())
                            {
                                sb1.Append(parameters[i].ToString() + "-" + item["FormType"].ToString() + ",");
                                strType = FormType(sb1.ToString());
                                break;
                            }
                        }
                    }

                  
                  
                }
 DataTable listItemsTable = oList.GetItems(qry).GetDataTable();
            this.DataSource = listItemsTable;

  }

        private static string CreateCAMLQuery(string[] parameters)
        {
            StringBuilder sb = new StringBuilder();
            for (int i = 0; i < parameters.Length; i++)
            {
                if (i >= 2 && !sb.ToString().EndsWith(@"</Or>"))
                {
                    sb.Insert(0, "<Or>");
                    sb.Insert(sb.Length, "</Or>");
                }

                sb.Append("<Eq>");
                sb.Append("<FieldRef Name='ItemID'/>");
                sb.AppendFormat("<Value Type='Choice'>" + parameters[i] + "</Value>", i);
                sb.Append("</Eq>");

                if (i >= 2 && !sb.ToString().EndsWith(@"</Or>"))
                {
                    sb.Insert(0, "<Or>");
                    sb.Insert(sb.Length, "</Or>");
                }

            }

            sb.Insert(0, "<Where>");
            sb.Append("</Where>");

            return sb.ToString();
        }

 public static string FormType(string strFormType)
        {
         
           string[] FormTypeValues = strFormType.Split(",".ToCharArray());
           string[] values = FormTypeValues[0].Split("-".ToCharArray());
           string ItemId = values[0];
           string formT = values[1];
           switch (formT)
           {
               case "PM":

                   formT = "Parking";
                   strFormType = formT;
                   break;

               case "PCO":

                   formT = "Nonparking";
                   strFormType = formT;
                   break;
           }

           return strFormType;
        }

I appreciate your support
Thank you,

Smith 

Any Idea of when this will release? I am waiting on a fix for the ADO.Net multiple value problem and need an idea to determine if I should design a work around.

How to insert table in report header
I want some thing like this

I have created a few reports with DateTime parameters. Everything work ok with the designer. Now I have a report with a long parameter. All other parameter settings are the same as with the DateTime parameter reports. When I preview the report in the designer it says I need to supply a parameter just like to other reports. I enter the parameter but the preview button is disabled and wont print. I tried re-creating the report and the same thing happens. I go back to the other reports and the preview enter parameter works. Why is the preview button disabled? If I supply a default value for the parameter all works ok.

Hi there

We have just started looking at Telerik Reporting and have a couple of questions.....

With our current rep generator we can specify multiple data sources for an individual report so we can have varying data whether the data is related or not.

We are aware that Telerik does not contain this functionality at present but does offer something similar with sub reports.

I have been trying to find an example of simply adding sub reports to a master report but cannot find anything related to this.

We are not looking for Master-Detail setup as the data will not always be related.

Can someone point us at a simple example of how to have multiple data sources (sub reports) within a report.

Thanks ina advance

Hello,

We have had a couple of issues relating to font and our Generated Reports. Unfortunately, these issues crop up with the users of our website, and we have not been able to duplicate them locally as we do not have the same equipment as our users. Furthermore, These issues do not appear on our computers; When we receive the files, they render normally.

1. A few months ago we came across an issue in one of our projects where, in the default PDF viewer on Mac (Preview), certain blocks of text would not show up. The fix we initially came up with was to change the font-face to a different common font (Arial to Trebuchet). This seems to work well in most cases, but from time to time, we find that a field is still empty.
2. We received an example of one of our reports from a user today, and it looks as though some form of arbitrary text substitution has occurred. Interestingly this only appears to have happened on fields that use the Arial (default) font face. The text on the report is unreadable, and doesn't appear to have any relation to the original data (eg "CREDITOR" became "BQDCHSNQ").

Has anyone heard of or experienced these issues? Is there a fix available, or at least a reliable way to change this so it doesn't crop up anymore? I should also mention that we have disabled FontEmbedding on a number of these reports as well, so that we could keep the file sizes to a minimum.

Any information would be greatly appreciated. Thanks.

hi, i have created a report with version 2009 Q3, now i have upgraded to version 2010 Q2, but i can't open the design of the reports. How to solve this issues? Thank.

Hi

I want to connect my data source from at run time by passing connection string at run time to genarte the report.
also I want to execute the select query at run time by passing it at run time .

So could I achieve it .
Also I want to insert the required fields after processing for every record in detail section at run time on which event should i do that.

In the C# 2008 Demo example thier is "View Report" Hyperlink that link to another report but I am unable to find its linking code and also no help regarding it is mentioned.


Kindly Help .

Regards
Achin Jain

Is there an estimated release date for this yet?