Click here to Skip to main content
15,911,715 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Filter in crystal report Pin
εїзεїзεїз15-Feb-10 23:48
εїзεїзεїз15-Feb-10 23:48 
GeneralRe: Filter in crystal report Pin
akosidandan15-Feb-10 23:56
akosidandan15-Feb-10 23:56 
GeneralRe: Filter in crystal report Pin
εїзεїзεїз16-Feb-10 0:28
εїзεїзεїз16-Feb-10 0:28 
GeneralRe: Filter in crystal report Pin
akosidandan16-Feb-10 0:44
akosidandan16-Feb-10 0:44 
GeneralRe: Filter in crystal report Pin
εїзεїзεїз16-Feb-10 1:20
εїзεїзεїз16-Feb-10 1:20 
GeneralRe: Filter in crystal report Pin
akosidandan16-Feb-10 2:55
akosidandan16-Feb-10 2:55 
GeneralRe: Filter in crystal report Pin
εїзεїзεїз16-Feb-10 3:49
εїзεїзεїз16-Feb-10 3:49 
GeneralRe: Filter in crystal report Pin
akosidandan16-Feb-10 13:14
akosidandan16-Feb-10 13:14 
Hello again Sir,

Sorry for keep asking this again but I still confuse sir on the use of
formula in crystal report

I have tried these commands but still I have error and it says
"Remaining text does not appear to be a part of the formula"

form3.CrystalReport1.Formula(0)= "Select * From studRecords Where DateEnrolled>=  #" & DTPicker1.Value & "#  and    DateEnrolled<= #" & DTPicker2.Value & "#  "  
form3.Crystalreport1.Formulas(0) = "filteringDate=Date(" & Year(DTPicker1.Value ) & "," & Month(DTPicker1.Value ) & "," & Day(DTPicker1.Value ) & ")" "




If you would mine sir could you give me a sample formula on how to filter the date using
the date picker I have use as the same I filter in my datagrid
Here are some details:
CrystalReport1 - the name of my crystal report
form3 - where my crystal form is 
DTpicker1 - datepicker I use to filter( from this Date)
DTpikcer2 - datepicker I use to filter( to this Date)
filteringDate - the name of my formula




Thanks you so much again for immediate reponse and entertaining my question




Thanks,


dfan23
QuestionInheriting Eventhandler in VB.NET from C# class library Pin
Mdnss15-Feb-10 21:32
Mdnss15-Feb-10 21:32 
AnswerRe: Inheriting Eventhandler in VB.NET from C# class library Pin
Steven J Jowett15-Feb-10 22:13
Steven J Jowett15-Feb-10 22:13 
QuestionRe: Inheriting Eventhandler in VB.NET from C# class library Pin
Mdnss15-Feb-10 22:22
Mdnss15-Feb-10 22:22 
AnswerRe: Inheriting Eventhandler in VB.NET from C# class library Pin
Steven J Jowett15-Feb-10 22:31
Steven J Jowett15-Feb-10 22:31 
QuestionRe: Inheriting Eventhandler in VB.NET from C# class library [modified] Pin
Mdnss15-Feb-10 22:38
Mdnss15-Feb-10 22:38 
AnswerRe: Inheriting Eventhandler in VB.NET from C# class library Pin
Steven J Jowett15-Feb-10 23:17
Steven J Jowett15-Feb-10 23:17 
GeneralRe: Inheriting Eventhandler in VB.NET from C# class library Pin
Mdnss15-Feb-10 23:35
Mdnss15-Feb-10 23:35 
AnswerRe: Inheriting Eventhandler in VB.NET from C# class library Pin
rhuiden16-Feb-10 8:49
rhuiden16-Feb-10 8:49 
QuestionHow to fire specfied hot key on Form Keydown? Pin
mdrizwan_115-Feb-10 19:18
mdrizwan_115-Feb-10 19:18 
AnswerRe: How to fire specfied hot key on Form Keydown? Pin
εїзεїзεїз15-Feb-10 23:44
εїзεїзεїз15-Feb-10 23:44 
GeneralRe: How to fire specfied hot key on Form Keydown? Pin
TheComputerMan16-Feb-10 17:25
TheComputerMan16-Feb-10 17:25 
QuestionLINQ Query for Sum [with null values Column from Datatable] ? Pin
Paramu197315-Feb-10 2:46
Paramu197315-Feb-10 2:46 
AnswerRe: LINQ Query for Sum [with null values Column from Datatable] ? Pin
nlarson1115-Feb-10 3:49
nlarson1115-Feb-10 3:49 
Questionneed project Pin
md aazharuddin15-Feb-10 1:23
md aazharuddin15-Feb-10 1:23 
AnswerRe: need project [modified] Pin
TheComputerMan15-Feb-10 2:20
TheComputerMan15-Feb-10 2:20 
GeneralRe: need project Pin
DaveAuld15-Feb-10 4:51
professionalDaveAuld15-Feb-10 4:51 
AnswerRe: need project Pin
Ashfield15-Feb-10 3:19
Ashfield15-Feb-10 3:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.