Reporting Editor goes in strange way.

3 posts, 1 answers
  1. shadow
    shadow avatar
    58 posts
    Member since:
    Jun 2008

    Posted 12 May 2010 Link to this post

    Hi,

    Telerik, I am in greate trouble, I have faced this problem so many times. 
    During last 5 days, it is coming so often, and every time I have no other option but to create the report again.

    I have attatched the detailed image of error, please check this and suggest how we can solve this problem.

    We are using "Reporting Q1 2010" version.

    Also please tell us how we can bind the sub report, here I am posting my code but this is not doing any thing,
    Infact during this process I have been facing the reported error this time. I have created this report almost 6 times
    and every time during the sub report binding I came up with this error.

    <Format Code Block>

            private void AsapBillingTransactions_NeedDataSource(object sender, EventArgs e)
            {
                DataSet ds_SubReport = new DataSet();

                command = new SqlCommand();
                command.CommandType = CommandType.StoredProcedure;
                command.Connection = connection;
                command.CommandText = "sp_ASAPBilling1";
                command.Parameters.Add(new SqlParameter("@OrgID", OrgID));
                command.Parameters.Add(new SqlParameter("@FromDate", FromDate));
                command.Parameters.Add(new SqlParameter("@ToDate", ToDate));

                adapter = new SqlDataAdapter(command);
                adapter.Fill(ds_SubReport);

                this.subReport1.ReportSource.DataSource = ds_SubReport;

            }
      

    <Format Code Block>


    Certainly found more errors.
    One of reports in my project is working well, I am able to preview the report in my reporting project, but creating dll of reports project, when I use it with my web application, it is giving error, I have also attatched the image with error named"ConnectionStringError".


  2. shadow
    shadow avatar
    58 posts
    Member since:
    Jun 2008

    Posted 12 May 2010 Link to this post

    This is image for second error
  3. DevCraft banner
  4. Answer
    Steve
    Admin
    Steve avatar
    10941 posts

    Posted 13 May 2010 Link to this post

    Hi Farid,

    We believe the error message is pretty clear, but we'll paraphrase: "In case you use a connection string from the application configuration file (of the class library), make sure the name is correct and the same connection string settings are present in the configuration file of your application (your web site) as well."

    In other words if you have saved a connectionString in your class library and it is e.g.:

    <connectionStrings>
            <add name="Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString"
                connectionString="Server=(local);Database=AdventureWorks;Integrated Security=SSPI;"
                providerName="System.Data.SqlClient" />
        </connectionStrings>

    you should copy it to the web.config (in case of a website) or app.config (in case of a windows forms) as well, in order to be able to connect to your database at runtime.
    Also when you're programmatically binding a report or subreport in a report event, you should set the datasource to the processing counterpart and not the definition report item. More info about this is available in the following articles:

    Greetings,
    Steve
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Back to Top