now I am creating Crystal report in Visual Studio 2005.
I want to create like that below:
Document1.aspx and ViewReport.aspx file.
When I clicked the link in Document1.aspx then,
it will carry query string value and go to ViewReport.aspx.
ViewReport.aspx will show report corresponding query string value.
yesterday I tried to display Crystal Report with parameter pass in visual studio 2005,
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.
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
then, in ViewReport.aspx.cs, I coded like below,
string id = Convert.ToString(Request.QueryString["id"]); //take query string value
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();
SqlDataAdapter da = new SqlDataAdapter(strSQL, sqlCon);
SqlCommandBuilder cmdBldr = new SqlCommandBuilder(da);
CrystalReportViewer1.ReportSource = rptDoc;
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#).
Make sure the application user has sufficient permissions to access all the various resources involved, including:
Read and Write access to the Application folder, sub-folders, and files.
Read and Write access to the Temporary folder and all related sub-folders.
Read and Write access to Microsoft .NET Framework folder and related sub-folders.
Read and Write access to the folder containing the report file to be displayed.
Also, make sure the user credentials supplied when creating the Crystal Report has permission to access the application and the database.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
i would like to prepare R&D. regarding my R&D i need to make a print preview page that will not contain the scroll bar if the div control had a scroll.. it is possible when override the style sheet but we have to prepare another css for print preview... i hope you overcome this problem and will send the correct code for me.... remember i need to remove the scroll from the div control.. if we are override only override overflow property means we will get a alligment problem.. we have to avoid all the problems.. please help me... please send a mail to email@example.com
hi, excuse me,
I created formview.
this formview contain checkbox value, showing true or false of sql Bit datatype.
please tell me,
how to display boolean value using checkbox on formview.
how to update boolean value using sql update statement in C#.
In a C# web form 2010 application I have a detailsview control that is tied to a linq datasource. In the detailsview control I am suppose to have 4 dropdownlist controls where the user selects no or yes. The default value is no if nothing is selected. The dropdown list controls are not setup to update the database. The dropdown list controls is to indicate if certain 'preloaded' date fields are incorrect. The 'preloaded dates' can be incorrect if the customer submits their paperwork that is past the due date. (The preloaded dates are dates that certain paperwork is required for tthe customer.)
When the user clicks 'yes' in the appropriate dropdown list control, another row in the detailsview control is suppose to show up for the user to enter the date that is entered by the user. The user does not want to be allowed to enter a 'corrected' date unless they click a dropdownlist box.
My plan is to have the 4 date fields that can be modified, have their 'insertinvisible property' set to true. When the appropriate dropdownlist box is clicked for 'yes', I would change the insertinvisible property for the appropriate date to false on the click event of the dropdown list.
Based upon what I have just stated, I have the following questions:
1. Can I have a dropdownlist control used that is not attached to the database? If so, can you show me an example of how to accomplish this task? I assume I would put the dropdownlist control in the itemtemplate versus the edititemtemplate since I am not updating the database, correct?
2. I have tried to used the 'insertvisible' property on a couple of 'test' rows in the database. However the test rows show up regardless of what I set the insertvisible property to. Thus do you know of any other way to use a visible property here? If so, what is the property and how would I reference that prpoerty?
I have gridview with 3 check (checkBox1,checkBox2,checkBox3).
When user check checkBox3 -> checkBox1,checkBox2 should be enable ane opposite when user un-check checkBox3 ->checkBox1,checkBox2 should be disable. how can I do this?
I need to have two different menu items. One for the top and one for the left. I was trying to connect web.sitemap to top and web1.sitemap to left menu.
Both menus getting data from web.sitemap file. Although, I have SiteMapDataSource1 for top menu, and SiteMapDataSource2 for left menu.