when i finished my project and published it then when i begin to report,it shows: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.IO.FileNotFoundException: Could not load file or assembly 'CrystalDecisions.Windows.Forms, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. i use VS2008 and crystal report 2008,i do not know how to do ?

string from, to; from = frm.dtp1(); to = frm.dtp2(); sql = "select convert(varchar(10),tim,120) as dates,sum(mone) as totals,count(ID) as totalman from pat where (datepart(mm,tim) like '__' or datepart(mm,tim) like '_') and convert(varchar(10),tim,120) between '" + from + "' and '" + to + "' group by convert(varchar(10),tim,120)"; like that,i use this SQL do my report,then write Sum ({DataTable1.totalman}) and Sum ({DataTable1.totals}) on my crystal report.then run my project the totalman should be 62,but it shows on report is 62.00,why?i think it should't like that?

Now ihave do this

select a from table_a where aa=123

select b from table_a where aa=32

select sum(aa) as c from table_a where aa=44

select sum(bb) as d from table_a where aa=88

i want to select them just use one SQL.not use union,because i want to show them like this : a b c d 1 2 32 32 23 43 54 564 32 43 64 45 show four fields,not one,it's difficulty for me,i have done all day long,everyone who can teach me ?very apprciate!!

Now ihave do this

select a from table_a where aa=123

select b from table_a where aa=32 select sum(aa) as c from table_a where aa=44 select sum(bb) as d from table_a where aa=88 i want to select them just use one SQL.not use union,because i want to show them like this : a b c d 1 2 32 32 23 43 54 564 32 43 64 45 show four fields,not one,it's difficulty for me,i have done all day long,everyone who can teach me ?very apprciate!!

when you do this,it only union those fields,can not make sum(amount) show as an Independent field.how could we do?

Now i have form1 and form2 datetimepicker1 and datetimepicker2 is in form1 i want to use datetimepicker1 and datetimepicker2 on form2 from form1,set datetimepicker1'modifiers and datetimepicker2'MOdifiers to public on form1, i wrote my code on form1 like this string from, to; from = this.dateTimePicker1.Value.ToString("yyyy-MM-dd"); to = this.dateTimePicker2.Value.ToString("yyyy-MM-dd"); it can work very well then wrote my code on form2 like this Form1 frm=new Form1(); string from, to; from = frm.dateTimePicker1.Value.ToString("yyyy-MM-dd"); to = frm.dateTimePicker2.Value.ToString("yyyy-MM-dd"); when i run my code ,from=2010-01-09,to=2010-01-09 on form2 but when i select dateTimePicker1=2010-01-05, dateTimePicker2=2010-01-09 on form1, then run my code ,it shows from=2010-01-05,to=2010-01-09 on form1,but it also shows from=2010-01-09,to=2010-01-09 on form2,it do not change anymore on form2,i think it may be read from the most beginning. i want to get the changed dateTimePicker.Value,how could i do thanks everyone?

Now i have form1 and form2 datetimepicker1 and datetimepicker2 is in form1 i want to use datetimepicker1 and datetimepicker2 on form2 from form1,set datetimepicker1'modifiers and datetimepicker2'MOdifiers to public on form1, i wrote my code on form1 like this string from, to; from = this.dateTimePicker1.Value.ToString("yyyy-MM-dd"); to = this.dateTimePicker2.Value.ToString("yyyy-MM-dd"); it can work very well then wrote my code on form2 like this Form1 frm=new Form1(); string from, to; from = frm.dateTimePicker1.Value.ToString("yyyy-MM-dd"); to = frm.dateTimePicker2.Value.ToString("yyyy-MM-dd"); when i run my code ,from=2010-01-09,to=2010-01-09 on form2 but when i select dateTimePicker1=2010-01-05, dateTimePicker2=2010-01-09 on form1, then run my code ,it shows from=2010-01-05,to=2010-01-09 on form1,but it also shows from=2010-01-09,to=2010-01-09 on form2,it do not change anymore on form2,i think it may be read from the most beginning. i want to get the changed dateTimePicker.Value,how could i do thanks everyone?

Now i have form1 and form2 datetimepicker1 and datetimepicker2 is in form1 i want to use datetimepicker1 and datetimepicker2 on form2 from form1,set datetimepicker1'modifiers and datetimepicker2'MOdifiers to public on form1, i wrote my code on form1 like this string from, to; from = this.dateTimePicker1.Value.ToString("yyyy-MM-dd"); to = this.dateTimePicker2.Value.ToString("yyyy-MM-dd"); it can work very well then wrote my code on form2 like this Form1 frm=new Form1(); string from, to; from = frm.dateTimePicker1.Value.ToString("yyyy-MM-dd"); to = frm.dateTimePicker2.Value.ToString("yyyy-MM-dd"); when i run my code ,from=2010-01-09,to=2010-01-09 on form2 but when i select dateTimePicker1=2010-01-05, dateTimePicker2=2010-01-09 on form1, then run my code ,it shows from=2010-01-05,to=2010-01-09 on form1,but it also shows from=2010-01-09,to=2010-01-09 on form2,it do not change anymore on form2,i think it may be read from the most beginning. i want to get the changed dateTimePicker.Value,how could i do thanks everyone?

modified on Sunday, January 10, 2010 1:38 AM

thanks very much! i can't login "

hello,everyone: i'm a beginner of C#,i use crystal report do report. Now,in my project,i use Dategridview to show datebase,the serach Condition is two DataTimerPicker.now,i just want the dates which is searched to report,but everytime when i do the report,it'll report all the dates in my datebase,but i just want report some of them,no all!i know Crystal Report can do this job very good,but i do not know how to make my code,so please everyone show me some method or give some others to teach me!Very appriate! Student miss YY

modified on Wednesday, January 6, 2010 9:51 PM

where can i download the crystal report?i download some ,but it do not work!thanks everyone!

SqlConnection thisConnection = new SqlConnection( @"Server=(local);Integrated Security=True;" + "Database=northwind"); NOW the server is "local",but when i Install my Program on pc1,install DATABASE on pc2,how can i use date from pc2? i can not change server everytime,i think it can read from a comboBox?how can i do?

not that,i use button1 and other buttons,it also do not work

private void button5_Click(object sender, EventArgs e) { Form2 frm2 = new Form2(); frm2.Show(); } when i run the code ,click button5,not any happened to me,Form1 still Form1,Form2 still not show?it just as have never happened? what's the reason?thanks every to help me !

string mm = dateTimePicker1.Value.ToShortDateString().ToString(); string nn = dateTimePicker2.Value.ToShortDateString().ToString(); SqlCommand SCD = new SqlCommand("select * from table_inf where tim>=@mm and tim<=@nn", Conn); SCD.Parameters.AddWithValue("@mm", mm); SCD.Parameters.AddWithValue("@nn", nn); sqlDataAdapter1.SelectCommand = SCD; sqlDataAdapter1.Fill(DT); Conn.Open(); dataGridView1.DataSource = DT; when i chosen dateTimePicker1 on today and chosen dateTimePicker2 on today too,it can't select Today'data....when you want to select today'data,you must change dateTimePicker2 on tomorrow,it's trouble! How can i chosen dateTimePicker1 on today and chosen dateTimePicker2 on today also can chosen Today's Data! i try to change "tim" to "convert(varchar(12),tim,105)",but it also do not work for me. i don't know how to change my Code ,thanks to everyone! i,m poor in english,sorry i use DATA sql2000 i have put this problem on here twice,thanks to everyone

thanks,that's it i' ll do it

DateTime mm = dateTimePicker1.Value; DateTime nn = dateTimePicker2.Value; SqlCommand SCD = new SqlCommand("select * from table_inf where tim>= @mm and tim<=@nn", Conn); SCD.Parameters.AddWithValue("@mm", mm); SCD.Parameters.AddWithValue("@nn", nn); sqlDataAdapter1.SelectCommand = SCD; sqlDataAdapter1.Fill(DT); Conn.Open(); dataGridView1.DataSource = DT; when i chosen dateTimePicker1 on today and chosen dateTimePicker2 on today too,it can't select Today'data....when you want to select today'data,you must change dateTimePicker2 on tomorrow,it's trouble! How can i chosen dateTimePicker1 on today and chosen dateTimePicker2 on today also can chosen Today's Data! i don't know how to change my Code ,thanks to everyone! i,m poor in english,sorry i use DATA sql2000

where can i DownLoad something from our Website? i can't find it? for exeample :softeware,Tutorial

modified on Monday, December 7, 2009 11:32 PM

Now i'm studing to do report,but no good books about CryStal Report tolearn,as a beginner,teacher ask me do my report work,because of limited time,please give me the Tutorial,or video Tutorial,thanks everyone!!

int mm =int.Parse(dateTimePicker1.Value.ToString("dd")); int nn =int.Parse(dateTimePicker1.Value.ToString("dd")); SqlCommand SCD = new SqlCommand("select * from table_inf where time>=mm and time<=nn", Conn); i use data Sql2000,Field time's Property is datetime what's wrong with it? how can i change it thank you everyone!!