TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Irfan Khan
NA
1
1.3k
I am Facing Problem with Formula Selection in Crystal report
May 27 2013 12:37 PM
Hello eveyrone
I am working on a project in visual studio 2012 with sqlserver backend.
I am creating a Report which is working fine with selecting all the data from the database table, but when i want to select records based on invoice no it generates an error in the Formula.
the error is "A NUMBER IS REQUIRED HERE......"
The Code I am Using is
Pending_order_Report por = new Pending_order_Report();
rptsales rpt = new rptsales();
suntechagribusinessDataSet ds1 = new suntechagribusinessDataSet();
salesTableAdapter.Fill(ds1.sales);
sale_detailsTableAdapter.Fill(ds1.sale_details);
rpt.SetDataSource(ds1);
por.crystalReportViewer1.ReportSource = rpt;
por.crystalReportViewer1.SelectionFormula = "ToNumber({sales.invoice_no})='" + Convert.ToInt32( listView1.SelectedItems[0].SubItems[1].Text) + "'";
por.Show();
Pending_Order_report is the form on which i place the Crystal report viewer, invoice number is a column in sale table in the database.
The Above I place on a context menu on the Listview. the Formula Line select listview subitems[1] which is Invoice Number but it generates an error that A NUMBER IS REQUIRED HERE..
Any help will be Appreciated..
Thanks in Advance
Reply
Answers (
0
)
OOPS OBJECT
Question on Multilevel inheritance