Click here to Skip to main content
15,881,281 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: AJAX ENABLED WEBSITE IN VS 2010 Pin
Member 322226428-Nov-11 0:05
Member 322226428-Nov-11 0:05 
QuestionWeb Service input validation in WSDL Pin
umairmoghal23-Nov-11 21:53
umairmoghal23-Nov-11 21:53 
AnswerRe: Web Service input validation in WSDL Pin
jkirkerx24-Nov-11 8:56
professionaljkirkerx24-Nov-11 8:56 
Questionshowing crystal report with query string parameter Pin
sk_ko23-Nov-11 16:11
sk_ko23-Nov-11 16:11 
AnswerRe: showing crystal report with query string parameter Pin
thatraja23-Nov-11 17:03
professionalthatraja23-Nov-11 17:03 
GeneralRe: showing crystal report with query string parameter Pin
sk_ko23-Nov-11 17:22
sk_ko23-Nov-11 17:22 
AnswerRe: showing crystal report with query string parameter Pin
thatraja23-Nov-11 19:20
professionalthatraja23-Nov-11 19:20 
GeneralRe: showing crystal report with query string parameter Pin
sk_ko24-Nov-11 14:56
sk_ko24-Nov-11 14:56 
yesterday I tried to display Crystal Report with parameter pass in visual studio 2005,
web application.
thank thatraja.
the link you provided is helpful.
But my problem is not solved yet.
I tried like this tutorial you provided.
But the report automatically request to input parameter in Textbox, when I click "ViewReport" link.
when I typed integer parameter in this textbox, the report show correct result.

I described my problem in detail below.
Let's say two documents.

1. Document1.aspx
2. ViewReport.aspx

First I put hyperlink in Formview of Document1.aspx.
I take ID value using QueryString to another page (ViewReport.aspx), Like below,
using hyperlink tag

href="ViewReport.aspx?id=<%#Eval("id")%>"

then, in ViewReport.aspx.cs, I coded like below,

string id = Convert.ToString(Request.QueryString["id"]); //take query string value
string connStr;
string strSQL;
ReportDocument cryRpt = new ReportDocument();
strSQL = "SELECT * FROM requests WHERE id=" + id; //make sql statement with parameter
ReportDocument rptDoc = new ReportDocument();
connStr = ConfigurationManager.ConnectionStrings["IThelpdeskConnectionString"].ConnectionString;
SqlConnection sqlCon = new SqlConnection(connStr);
DataSet ds = new DataSet();
sqlCon.Open();
SqlDataAdapter da = new SqlDataAdapter(strSQL, sqlCon);
SqlCommandBuilder cmdBldr = new SqlCommandBuilder(da);
da.Fill(ds, "requests");
rptDoc.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rptDoc;
CrystalReportViewer1.RefreshReport();

the Error shows on Line.... rptDoc.SetDataSource(ds);
Invalid file path error
Exception Details: CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: Invalid report file path.

I don't know how to solve this error.
Anyboxy, pls help me.
I am using VS 2005 professional, web application (C#).
AnswerRe: showing crystal report with query string parameter Pin
thatraja24-Nov-11 15:05
professionalthatraja24-Nov-11 15:05 
GeneralRe: showing crystal report with query string parameter Pin
sk_ko24-Nov-11 15:44
sk_ko24-Nov-11 15:44 
AnswerRe: showing crystal report with query string parameter Pin
thatraja24-Nov-11 18:19
professionalthatraja24-Nov-11 18:19 
QuestionHow to fill several comboboxes with for loop? Pin
symeramon23-Nov-11 4:01
symeramon23-Nov-11 4:01 
AnswerRe: How to fill several comboboxes with for loop? Pin
Satheesh154623-Nov-11 6:22
Satheesh154623-Nov-11 6:22 
GeneralRe: How to fill several comboboxes with for loop? Pin
Richard MacCutchan23-Nov-11 10:55
mveRichard MacCutchan23-Nov-11 10:55 
QuestionServer Error in '/book' Application. Pin
keyur satyadev23-Nov-11 2:13
keyur satyadev23-Nov-11 2:13 
AnswerRe: Server Error in '/book' Application. Pin
thatraja23-Nov-11 17:09
professionalthatraja23-Nov-11 17:09 
Questionany one can tell query or SP how to insert image in sql server Pin
sheemap23-Nov-11 1:15
sheemap23-Nov-11 1:15 
AnswerRe: any one can tell query or SP how to insert image in sql server Pin
Simon_Whale23-Nov-11 3:12
Simon_Whale23-Nov-11 3:12 
AnswerRe: any one can tell query or SP how to insert image in sql server Pin
thatraja23-Nov-11 17:12
professionalthatraja23-Nov-11 17:12 
Questionhow to print the aspx page without scroll.. Pin
Gopinath007222-Nov-11 22:41
Gopinath007222-Nov-11 22:41 
Questioncheckbox databind Pin
sk_ko22-Nov-11 20:04
sk_ko22-Nov-11 20:04 
AnswerRe: checkbox databind Pin
thatraja24-Nov-11 19:12
professionalthatraja24-Nov-11 19:12 
Questiondetailsview with dropdown list Pin
sc steinhayse22-Nov-11 14:41
sc steinhayse22-Nov-11 14:41 
QuestionJava script for gridview Pin
byka21-Nov-11 4:56
byka21-Nov-11 4:56 
AnswerRe: Java script for gridview Pin
Morgs Morgan22-Nov-11 21:59
Morgs Morgan22-Nov-11 21:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.