show reports (using stored procedure)

Posted Date: 08 May 2008 Resource Type: Code Snippets Category: Crystal Reports

Posted By: mahua dutta Member Level: Gold
Rating:

Points: 10

//import CrystalDecisions.Shared;
//...............we take a crystalreport viewer and a crystalreport source in the webform and inthe property of crstalreportsource there is report option we click thet and then in filename we have to write the crystalreport name such as "crystalreport1" etc//
///.............
protected void Page_Load(object sender, EventArgs e)
{
ConnectionInfo cn = new ConnectionInfo();

cn.ServerName = "Net1/SQLEXPRESS";
cn.UserID = "sa";
cn.Password = "ats";
cn.DatabaseName = "employee";
CrystalReportViewer1.ReportSource = CrystalReportSource1;
string s1 = Request.QueryString["allias"].ToString();
foreach (TableLogOnInfo Tinfo in CrystalReportViewer1.LogOnInfo)
{
Tinfo.ConnectionInfo = cn;
}

ParameterField param = CrystalReportViewer1.ParameterFieldInfo[0];
ParameterDiscreteValue value = new ParameterDiscreteValue();
value.Value = s1;
param.CurrentValues.Add(value);
}
///................

Responses

Author: chaithanya 01 Jul 2008

Member Level: Silver Points : 1

Nice post which shows reports through stored procedure.

Author: G.R 04 Jul 2008

Member Level: Diamond Points : 0

really nice continue for sharing ur knowledge

Author: Basu 09 Jul 2008

Member Level: Bronze Points : 0

Really it is good one ..
keep on uploading new resources..

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to pass parameters to crystal report at runtime.
	Previous Resource: Load Crystal Reports from File
	Return to Discussion Resource Index
	Post New Resource
	Category: Crystal Reports

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design Scripts

fax server