Wrox Programmer Forums
|
BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9
This is the forum to discuss the Wrox book Professional ASP.NET 3.5: In C# and VB by Bill Evjen, Scott Hanselman, Devin Rader; ISBN: 9780470187579
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 8th, 2011, 08:11 AM
Registered User
 
Join Date: Feb 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default The report you requested requires further information.

I m using push method,whats wrong in this code,why it ask for The report you requested requires further information.thanks in advance [/B]


using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Web.Services;
using System.Collections.Generic;
using CrystalDecisions.Shared;
using CrystalDecisions.CrystalReports.Engine;

public partial class CrystalReportProformaInvoice : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrin gs["Connection"].ConnectionString);
SqlCommand cmdPrintReportInformation = new SqlCommand();
ReportDocument MyReport = new ReportDocument();
string server = @"EOTREENA\SQLEXPRESS";
string database = "Inventory";
string user = "UserInventory";
string password = "admin";

public static string strProformaInvoiceID;
protected void Page_Load(object sender, EventArgs e)
{
strProformaInvoiceID = Session["ProformaInvoiceID"].ToString();
cmdPrintReportInformation = new SqlCommand("SP_PrintReport_SD_ProformaInvoiceInfor mation_View", con);
cmdPrintReportInformation.CommandType = CommandType.StoredProcedure;
cmdPrintReportInformation.Parameters.AddWithValue( "@ProformaInvoiceID", strProformaInvoiceID);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmdPrintReportInformation);
DataSet1 ds = new DataSet1();
da.Fill(ds, "ProformaInvoice");
MyReport.Load(Server.MapPath("ProformaInvoiceCryst alReport.rpt"));
MyReport.SetDataSource(ds.Tables["ProformaInvoice"]);
SetConnectionInfo(server, database, user, password);
CrystalReportViewer1.ReportSource = MyReport;
CrystalReportViewer1.DataBind();
con.Close();
}
public void SetConnectionInfo(string server, string database, string user, string password)
{
TableLogOnInfo logOnInfo = new TableLogOnInfo();
logOnInfo = MyReport.Database.Tables[0].LogOnInfo;
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo = logOnInfo.ConnectionInfo;
connectionInfo.DatabaseName = database;
connectionInfo.ServerName = server;
connectionInfo.UserID = user;
connectionInfo.Password = password;
MyReport.Database.Tables[0].ApplyLogOnInfo(logOnInfo);
}
}





Similar Threads
Thread Thread Starter Forum Replies Last Post
VS2005 and CR2008 : The report you requeted requires futher information Vilariño Crystal Reports 1 July 24th, 2010 12:45 AM
Report you requested requires further information cathiec Crystal Reports 5 August 6th, 2009 02:32 AM
Process must exit before requested information Abhinavnaresh ASP.NET 2.0 Professional 0 April 9th, 2008 08:49 AM
The report you requested requires further informat ganiyadav Crystal Reports 0 July 31st, 2007 04:01 AM
The report you requested requires further informat BreathShadow ASP.NET 2.0 Basics 0 April 13th, 2007 01:56 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.