15,905,914 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Bhushan Mehetre (Top 15 by date)
Bhushan Mehetre
17-May-19 5:36am
View
Debugger is getting stopped it comes to line of code where assigning dt(Datatset) to crystal report object.
Bhushan Mehetre
17-May-19 2:14am
View
Thanks for the reply.
I am developing this windows application using c#.
I tried to debuge the code to find the error but have no luck because application is crashing without exception on the line below.
NewINv.SetDataSource(dt);
I have a form with report viewer to which I am assigning the crystal report object.
The sequence is some what like I am choosing the invoice no and click on view button. Then rystal report open fine. but when I try to view invoice for another invoice
released application .exe/debugger(I tried both) get crashed without any error. To find the crash reason I check the windows log event and I have 2 entries there for the same crash.
Both are mentioned on my first comment.
Below is the code where my application is crashing.
private void ViewInvoice0(Int32 invoiceId, Int32 v1, int ReportNo, String startYear, String endYear)
{
try
{
if (ReportNo == 0)
{
GSTSnehdeep.Invoice.NewInvoice NewINv = new GSTSnehdeep.Invoice.NewInvoice();//Crystal report file object
DataSet dt = DAL.GenerateInvoiceDAL.getNewSalesInvoiceDetail(invoiceId, v1, startYear, endYear);
NewINv.SetDataSource(dt);//Assigning the datasource to crystal report object //application crashing here 2nd time
crv_salesInvoice.ReportSource = NewINv;//Assigning crystal report to viewer
crv_salesInvoice.Zoom(80);
crv_salesInvoice.ToolPanelView = CrystalDecisions.Windows.Forms.ToolPanelViewType.None;
NewINv.SetParameterValue("ReportNumber", "1");
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString(), DAL.GSTSNDPConstant.CompanyName.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
Please let me know if you need anything extra.
Bhushan Mehetre
9-Dec-15 1:56am
View
Can you refine your question. like with the help of situation/condition
Bhushan Mehetre
14-Aug-14 2:53am
View
Is there any relation on this two drop down list... ??
Bhushan Mehetre
7-Aug-14 2:20am
View
Is your text box in table ?
If it is then, you should check that u have not applied align center.
Bhushan Mehetre
29-Jul-14 9:48am
View
No this is not the case...
Actual working of the report is like, On main report in table I will get one table that is contains columns "Owner Name", "Address", "Contact", "Email", "Active".
Down to this table there is a sub report which contains the columns like "Car No", "Rent Agreement Id", "Engine No", "Car Condition", "Car Make".
At the time of load only main report is loaded. subreport is empty thats why it is subpressed. On click of column "Owner Name" from the main report. It get the id of owner and pass it to the subreport and subreport dataset is filled on the basis of owner id. After successfull fill it shows the subreport with data.
Bhushan Mehetre
29-Jul-14 9:32am
View
Thanks for your reply...
But for details question please read this question...
http://www.codeproject.com/Questions/801882/Subreport-is-not-loading-in-website-csharp-asp-net?arn=0
Bhushan Mehetre
29-Jul-14 9:30am
View
Thanks for your reply but
Please see this
http://www.codeproject.com/Questions/801882/Subreport-is-not-loading-in-website-csharp-asp-net?arn=0
Bhushan Mehetre
29-Jul-14 9:23am
View
Here is the code of loading report
try
{
rptv.ProcessingMode = ProcessingMode.Local;
rptv.LocalReport.ReportPath = Server.MapPath("~/SSRS Reports/SRE Main.rdlc");
DataSet ds = fillCarOwnersDetals("SubReport");
ReportDataSource rds = new ReportDataSource("CarOwnerList", ds.Tables[0]);
rptv.LocalReport.DataSources.Clear();
rptv.LocalReport.DataSources.Add(rds);
}
catch (Exception ee)
{
lblStatus.Text = ee.Message.ToString();
}
fillCarOwnersDetals() is the function which fills the data into the dataset.
SubreportProcessing handler code
e.DataSources.Add(new ReportDataSource("OwnersCar", fillsubReportDataset(Convert.ToInt16(e.Parameters[0].Values[0].ToString())).Tables[0]));
Bhushan Mehetre
10-Jul-14 1:32am
View
then use case and add one more parameter to the method to identify functionality....
Bhushan Mehetre
7-Jul-14 2:09am
View
Yes you have to, in case the server is located on different location.
Sorry For the Late Reply.
The main part in connection string are server location and database name.
server name is like "192.168.2.154\SQLExpress" for the live and for local you will have ".\SQLExpress" or anything else. So as per your desire database destination you have to change web config.
It will same apply for the database name. It is best practice to keep the both name same.
Bhushan Mehetre
4-Jul-14 2:42am
View
Could you explain the situation ...
Bhushan Mehetre
3-Jul-14 5:33am
View
As your questions say's you are doing commercial website. So you have to put your database on live server.
When we purchase hosting for site normally they provide access to create 1 or 2 database server or they have plan for database. so you will choose Microsoft sql server databse hosting for database.
When you get access you have to just replicate the local database to the server.
and change the connection string in web config.
Bhushan Mehetre
3-Jul-14 2:58am
View
Can u elaborate the situation...
Bhushan Mehetre
3-Jul-14 2:19am
View
protected void Button1_Click1(object sender, EventArgs e)
{
string Asset_Type = "";
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox chkUpdate = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1");
if (chkUpdate != null)
{
if (chkUpdate.Checked)
{
///find the asset type id and append it to the string
///Asset_Type+= <asset_type id="">+",";
}
}
}
char chkcoma=Asset_Type[Asset_Type.Length-1];
if (chkcoma==',')
Asset_Type = Asset_Type.Remove(Asset_Type.Length - 1, 1);
///Now pass Asset_Typeto procedure and get vendor name
}
Show More