report generation

Question

0.00/5 (No votes)

See more:

I have attached the code i used, here the error is showing near sqlhelper. i need some other alternative code. If any one can help me, please help.

C#

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Reporting.WebForms;

public partial class ReportViewerLocalMode : System.Web.UI.Page
{
    public string thisConnectionString = 
       ConfigurationManager.ConnectionStrings[
       "NorthwindConnectionString"].ConnectionString;

    /*I used the following statement to show if you have multiple 
      input parameters, declare the parameter with the number 
      of parameters in your application, ex. New SqlParameter[4]; */

    public SqlParameter[] SearchValue = new SqlParameter[1];

    protected void RunReportButton_Click(object sender, EventArgs e)
    {
        //ReportViewer1.Visible is set to false in design mode

        ReportViewer1.Visible = true;
        SqlConnection thisConnection = new SqlConnection(thisConnectionString);
        System.Data.DataSet thisDataSet = new System.Data.DataSet();       
        SearchValue[0] = new SqlParameter("@CategoryName", 
                         DropDownList1.SelectedValue);

        /* Put the stored procedure result into a dataset */
        thisDataSet = SqlHelper.ExecuteDataset(thisConnection, 
                      "ShowProductByCategory", SearchValue);

        /*or   thisDataSet = SqlHelper.ExecuteDataset(thisConnection, 
               "ShowProductByCategory", dropdownlist1.selectedvalue); 
               if you only have 1 input parameter  */

        /* Associate thisDataSet  (now loaded with the stored 
           procedure result) with the  ReportViewer datasource */
        ReportDataSource datasource = new 
          ReportDataSource("DataSetProducts_ShowProductByCategory", 
          thisDataSet.Tables[0]);

        ReportViewer1.LocalReport.DataSources.Clear();
        ReportViewer1.LocalReport.DataSources.Add(datasource);
        if (thisDataSet.Tables[0].Rows.Count == 0)
        {
            lblMessage.Text = "Sorry, no products under this category!";
        }

        ReportViewer1.LocalReport.Refresh();
    }
}

Edit TR: Two things :

Please use <pre> tags to make your code easier to read (use the 'code block' button on the toolbar)
Please be more specific. What don't you like about the code? What have you tried?

Posted 21-Apr-10 3:27am

ramyaaksh

Updated 21-Apr-10 3:51am

Tony Richards

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-04-21T04:28:00

Solution 1

ramyaaksh wrote:
here the error is showing near sqlhelper.

What is SqlHelper? Dont see anything defined in your code.

ramyaaksh wrote:
i need some other alternative code.

You need to create a SqlCommand, open connection, add query and parameteres to that command, execute it!

Posted 21-Apr-10 4:28am

Sandeep Mewara

Pranay Rana · Answer 2 · 2010-04-21T18:54:00

Following is code done by me to add report viewer control dynamically to display reports

C++

ReportViewer ReportViewer1 = new ReportViewer();
                if (ddlListofReports.SelectedValue != "11")
                {

                    ReportViewer1.ProcessingMode = ProcessingMode.Local;
                    ReportViewer1.ID = "ReportViewer1";
                    // Set default values
                    ReportViewer1.Font.Bold = false;
                    ReportViewer1.Font.Name = "Arial";
                    //ReportViewer1.ShowExportControls = false;
                    ReportViewer1.ShowBackButton = false;
                    ReportViewer1.SizeToReportContent = true;
                    ReportViewer1.BackColor = System.Drawing.Color.WhiteSmoke;
                    // Reset the control collection position
                    //coll.AddAt(oldIndex, ReportViewer1);
                    //coll.Remove(oldViewer);
                    ReportViewer1.LocalReport.DataSources.Clear();
                }
                #endregion reportviewer setting

C++

#region CampaignProgressReport
                if (ddlListofReports.SelectedValue == "0")
                {
                    _reportID = "CampaignProgressReport";
                    List<SnapshotReport> List = new SnapshotReport().GetCustomersForCountry(this.DropDownList1.SelectedValue, this.DropDownList2.SelectedValue, dcfromdate.Text);
                    ReportViewer1.LocalReport.ReportPath = "Admin\\ReportDesigns\\" + _reportID + ".rdlc";
                    if (List != null)
                    {
                        if (List.Count > 0)
                        {
                            ReportParameter ServiceName = new ReportParameter("ServiceName", this.DropDownList1.SelectedItem.Text);
                            ReportParameter[] p = { ServiceName };
                            ReportViewer1.LocalReport.SetParameters(p);
                            ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("SnapshotReport1", List));
                            isnull = false;
                        }
                    }
                }
                #endregion CampaignProgressReport

MIDL

divRptView.Controls.Add(ReportViewer1);
                       ReportViewer1.Height = 290 + (25 * 10);
                       ReportViewer1.Width = Unit.Percentage(91);
                       ReportViewer1.ShowRefreshButton = false;
                       ReportViewer1.Visible = true;
                       ReportViewer1.ShowPrintButton = true;
                       ReportViewer1.SizeToReportContent = true;
                       ReportViewer1.LocalReport.Refresh();

if you have any query feel free to contact

The Manoj Kumar · Answer 3 · 2010-04-21T20:03:00

Solution 3

Could you please explain your question. You can find similar problems already solved try Google :)

Posted 21-Apr-10 20:03pm

The Manoj Kumar