Thanks, But i knows answers but , i want it in proper wording, i dnt wnt to miss this chance, thts why asking

"The Difficult i can do it now... The Impossible will take a little longer."

Hello freinds, i hav to go for an interview can anyone Please help me, Please tell me following question's answer.:^) 1) What is the difference between windows services & web services 2) What is visual programming 3) Difference between release mode compilation & debug mode compilation. 4) What is VSS, wht r its benefit. 5) Wht r autoreset event & manual reset events. 6) where is the constructor of windows form that we add in vb project located.

"The Difficult i can do it now... The Impossible will take a little longer."

hi, i m calling crystal report frm my vb.net(winforms) form. my report contains 1 subreport & both main & sub report contains the parameter, on which record selection depends. it is ok with my code to pass value to main report. but tell me please how to pass parameter value to subreport? i m passing parameter values by following code-? Dim myReport1 As New CRptTimesheetPerEmp Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues() Dim crParameterDiscreteValue As New ParameterDiscreteValue() crParameterDiscreteValue.Value = frmTimeSheetRpt1.cmbEmpId.Text crParameterFieldDefinitions = myReport1.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item(0) crParameterValues = crParameterFieldDefinition.CurrentValues crParameterValues.Clear() crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) CrystRptVEmpTimeSheet.ReportSource = myReport1

"The Difficult i can do it now... The Impossible will take a little longer."

good morning freinds, i m designing crystal report in.net framework i.e. bundeled version. i am preparing payslip, for that i wnt to place watermark image on page. whn i insert picture by right clicking on the report then it is inserting my backgruound image but lines present on my report go backward & also not shown whn i run the project. i rightclick on image & send it backward but it lines will not cum in front. & there is no option of line to bring it forward . please anyone tell me how should i place background image on my report. thanks for any help in advance.

"The Difficult i can do it now... The Impossible will take a little longer."

Hello frends, I have to prepare salary slip so want salary slip format. Please Anyone give me Salary slip sample. Thanks for any help in advance. -Regards Priya.

"The Difficult i can do it now... The Impossible will take a little longer."

Hello, i m using vb.net (winforms) & i have written class called employee. & make object of employee on my form & accessing all the properties of emp like id, name,sal etc. i shuld access all the values...so i wrotee property for each like Public ReadOnly Property BasicSal() As Integer Get Return BS1 End Get it is good whn property values are less but as i wnt to access all salary info like HRA, Basic Sal....etc total 20 fields. So i decided to use Array....I fill all values in array in my employee class's function itself. Th problem is i wnt to access this array of all values on my forms.How to do it plz tell me. Thanks for any help in advance. --Regards priya

"The Difficult i can do it now... The Impossible will take a little longer."

Hello everyone, i m using vb.net 2005 (winforms). when i wnt to go to next day i use datetime.adddays(numberofdays) function. but now i wnt to go back by one day , how to do it? what function is present for this Please tell me. i saw "Subtract function" in help but didnt get it. tell me any another function or if datetime.subtract() function can be used for subtracting one day frm our date then please guide me how to use it. Thanks for any help in advance. --regards Priya

"The Difficult i can do it now... The Impossible will take a little longer."

Helloo Friends, I want to make my Datagridview column as numeric only. How can we restrict user from entering other characters than numbers. If we wnt to do this in case of textbox we will write code into textbox's keypress event. So in case of datagridview How can we make numeric column? I m developing application in VB.net(WinFroms)-2005 Thanks fro any help in Advance

"The Difficult i can do it now... The Impossible will take a little longer."

gud morning frends, Will anyone tell me what is the difference between Datagrid & datagridview in VB.nNet. Thanks for any help in advance -Regards Priyanka. I AM NOT THE BEST BUT I AM NOT LIKE REST ;)

Thanks for help. But Cant we take stored proedure's result into crystal report? Will u tell me please How should i Try with database manager property. -Regards Priya.

"The Difficult i can do it now... The Impossible will take a little longer."

Hallo frends, I want to take result from stored procedure into my Crystal report but cnt see strored procs into my database expert of Crystal Report. I m using vb.net & mysql 5.0 & using ODBC for connection on report which includes DSN that i made already on my machine. But though i m check on "Show Stored procedure" under database exper->options->DataExplorer. But not showing any stored proc yet only tables. How should i call my stored proc in crystal RPt. Please Tell me soon. Thanks. -Regards Priya.

"The Difficult i can do it now... The Impossible will take a little longer."

I m using vb.net 2005 & crystal report(bundeled version which comes with .net). & using Dsn of mysql 5.0 driver for connection on my report to access data. I wnt to add result from procedure to my report. Procedure is ready & giving result in mysql but as i go into database Expert of Report in my application, i cant see the procedure there. Only add commant & tables of my database shown but how to add procedure to my report . Anyone please help me. Thanx. -- modified at 1:48 Tuesday 20th February, 2007

"The Difficult i can do it now... The Impossible will take a little longer."

Good morning freinds, i m trying to create following procedure in mysql5.0 but getting error abt check syntax in sql statement on 2nd column i.e. at sum(Tuesday). Monday & Tuesday are two columns of which i wnt to display sum of all records of Monday & tuesday so i wrote following procedure but Error??:sigh: As I tried already, i selected sum of other 2 columns at a time in one select stmt, but it is also giving error at 2nd column. In simple query i can select sum of more than one columns but why not in procedure? Anybody please help me following is the my procedure.----> DELIMITER $$ DROP PROCEDURE IF EXISTS `timesheet`.`sp_select` $$ CREATE PROCEDURE `sp_select`() BEGIN DECLARE mon,tue double; SELECT sum(Monday) into mon , sum(Tuesday) as tue FROM timesheet_nonbillables; SELECT mon,tue; END $$ DELIMITER ; What should i change in it to run properly. Please Reply Soon.:sigh: Thanx. -Regards Priya.

"The Difficult i can do it now... The Impossible will take a little longer."

Hi, I have 1 subreport on my main crystal Report. I want to calculate Total of fields. one field from 1st main report & 2nd field from my subreport . Will Anyone Tell me how to do it. i m using vb.net &crystal rpt. -thanks

priya

Is it working fine now or not?

priya

Hii, I m doing right now somewhat same like you. So i insert one more section in footer & have place my subreport there. Now it looks fine but I dnt whether this is a good way. ...for time being it is ok. If you get some other idea please let me know. My mail id ->priya_p233@yahoomail.com bye.

priya

Thanks Ankur. It works.

priya

Hello, Anyone please tell me How To hide Field on Crystal Report? Thanx.

priya

You write the code in procedure Private Sub MyDatagrid1_RowHeaderMouseDoubleClick(...) ''write code of filling mainform Here ''u can refer to select items of datagrid by Mainform1.textbox1=MyDatagrid1.item(0,e.rowindex).value Mainform1.textbox2=MyDatagrid1.item(1,e.rowindex).value ..... . . ''Like this fill all items of mainform end sub As user clicks on rowheader of datagrid's specific cell ur code will be generated if again any doubt , do ask. I wnt to ask that , Is all of controls on mainform are textboxes?

priya

hi, i wnt to write code that shuld be executed when user clicks on checkbox that is present as datagrid columne. where should i write the code.

priya