Telerik Forums
Reporting Forum
2 answers
147 views
I have searched through Telerik KB, Forums etc. and also Google. Yes, it is about the infamous "Operation could not be completed" error.

Most of the threads about the issue includes formatetc error too but in my case it is not true. I am just getting an "Operation could not be completed" error.

Here is the scenario:
  • Windows Vista with all updates
  • VS 2008
  • Telerik RadControls for ASP .NET AJAX Q3 2009 .Net 3.5
I have completed a web project within this environment. But I needed a reporting tool so I installed Telerik Reporting Q1 2009. I have developed a Class Library and tested my newly created reports. Everything was fine until I tried to add a ReporView into one of my web pages. I got "the" error.

To solve the problem (as suggested):
  • Re-Install Telerik Reporting
  • Reset Tool Box
  • Clean Asp .Net Cache
  • Restart VS/Computer
  • Add a couple of lines to web.config

Still the same.

Please, can anyone suggest something?
Kadir Kilicoglu
Top achievements
Rank 1
 answered on 22 Sep 2010
1 answer
287 views
I have a report with two charts on it.  The report has a particular datasource and the charts have a different datasource, but both charts use the same.  The Stored Procedure for the charts is called twice - once for each chart.  I was hoping to prevent this behavior.  Is there anyway to bind the 2nd charts datasource to the first chart?  I found this article:

http://www.telerik.com/community/forums/reporting/telerik-reporting/set-datasource-of-table-same-as-report-data-source.aspx

Which talks about sharing the Report's datasource.  I have not been able to figure out how to get two child objects (the charts) to share a datasource.  Any ideas out there?  Any tips greatly appreciated.

Thanks,

Sam
Peter
Telerik team
 answered on 22 Sep 2010
1 answer
330 views
Hi!  I've implemented a telerik report within a website.  The data for the report is being generated through a stored procedure in a MS SQL Server database which takes one parameter.  I have an aspx page with a Report Viewer control.  The dataset creation and databinding occurs in the code behind for the aspx page with the Report Viewer.  On another aspx page there is a button which loads the page with the Report Viewer.

The report loads without error and the data is present.  However the first time the report loads it takes several seconds before being displayed.  Any report displayed after that loads in less than a second.  Note - The value of the parameter for the stored procedure changes depending on what item the user decides to "view" so the data in the report varies depending on which item is selected.

Is there any way to speed up the initial loading of the report?

Thanks!
Steve
Telerik team
 answered on 22 Sep 2010
1 answer
79 views
version: Telerik_Reporting_Q2_2010_v4_1_10_714_dev.msi

I have a master report that links to a subreport similarly to what is done in the video: http://tv.telerik.com/watch/reporting/video/telerik-trainer-reporting-subreports

=======================================================
MasterReport

BlahID: {Fields.BlahId}
     ------------------------
     Subreport:

     Parameter Name   Parameter Value
     BlahId           =Fields.BlahId
=======================================================

=======================================================
Subreport

Report Parameters
   Members:
        BlahId Integer

DataSource: odsBlahDetail (object data source)
    This object returns data from a table with a WHERE clause that contains:
    
            WHERE BlahId=@BlahId
=======================================================

When I create the report without the subreport, everything works fine.  I get:

BlahID: 18
BlahID: 23
BlahID: 45
...

When I add the subreport in I get no report.  I ran some debugging and SQL profiler an determined that what is happening, is Telerik Reporting is in an infinite loop calling the subreport with the BlahID of 18 (the first one).

From what I can tell, I've set up my report the same as the above video, but since you don't post the source code for these videos, I can't definitively determine if I have...
Steve
Telerik team
 answered on 22 Sep 2010
2 answers
51 views
Hi guys this is my first post in this forum, and i have some problem ,

I'm working on project that involve a lot of reports and connecting it by sqlDatasource is not very efficient when changing the connection
because i have to change the connection  for each report.

my question is their any efficient way to connect to a stored procedure in one connection string for all reports something like a dataset in the DAL or BL and how?...

thanks in advance  
sahem
Top achievements
Rank 1
 answered on 21 Sep 2010
2 answers
100 views
Are there plans to support additional math functions like those available in System.Math class without creating custom user functions or is there an easier way to utilize these math functions in the expression builder?

Thanks
MD
Top achievements
Rank 1
 answered on 21 Sep 2010
3 answers
455 views

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 

smith spd
Top achievements
Rank 1
 answered on 21 Sep 2010
1 answer
108 views
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.
Peter
Telerik team
 answered on 21 Sep 2010
1 answer
114 views
How to insert table in report header
I want some thing like this
Peter
Telerik team
 answered on 21 Sep 2010
1 answer
428 views
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.
Peter
Telerik team
 answered on 21 Sep 2010
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?