Hi,
What type of contents/data are printing here? Say if your would like to print data which will be based on certain date, ID number, Names etc...you can use a combo box here to get there info..then use a select statement to get the value depending on your input.
Cheers!
freedom
Last Activity: Dec 1 '07, 07:49 AM
Joined: Apr 26 '07
Location:
-
-
Hi Veena,
I got it working!! Thanks for your help. I declarde a variable and set it as date then pass the value of the combo box to it. Got it working now. Thanks for your help
Cheers!!Leave a comment:
-
Hi Veena,
I forgot to tell you that my source here is a view and not a table. Also here is the sample data of the combo box
10/8/2007 12:00:00 AM
10/9/2007 12:00:00 AM
10/10/2007 12:00:00 AM
and so on.....
Thanks in advanceLeave a comment:
-
Hi Veena,
Im sorry I posted a wrong one. Here is the code. Does it has something to do with the setting up of date format?Thanks.
mySelectFormula = "{vTITO_Rpt.Wor kDate} In Date (2007, 10, 08) to DateTime (2007, 10, 09)"Leave a comment:
-
HI Veena,
I tried to see check it on the crystal report "show formula" then I tried to used this in my code using the below syntax, it worked well. However, as you can see it was not based on the input on the combo box. It was manually inputted on the selection expert. Thanks
mySelectFormula = "{vTITO_Rpt.Emp No} In Date (2007, 10, 08) to DateTime (2007, 10, 09)"Leave a comment:
-
Hi,
Yes, both combo boxes has data, I even tried to change the combo box to text box, inputting the date manuallu, but to no avail. Can we say that the code is ok?
ThanksLeave a comment:
-
Hi Veena,
Here is my code I used, I can't find what's seems to the error here, but everytime I used it, I encountered the error "The ) missing" . Thanks in advance
CrystalReportVi ewer1.ReportSou rce = New ReportName CrystalReportVi ewer1.ReportSou rce = ReportDocument
CrystalReportVi ewer1.Selection Formula = "{vTITO_Rpt.Wor kDate} In Date (" & Format(cmbxDate From.Text, "YYYY,MM,DD ")...Leave a comment:
-
The "m_report" here you use is the Crystal Report viewer, right? I'm using CR9, tried to use the .RecordSelectio nFormula, but it's not working. I tried to use the previous post you have here but still to no avail. What do I miss here? ThanksLast edited by Killer42; Nov 26 '07, 08:57 AM.Leave a comment:
-
Hi Veena,
I tried to used this in my record selection, however, I received an error, "The ) is missing" when I checked it, any part here that I missed? thnks.
VB code:
CrystalReportVi ewer1.Selection Formula = "{vTITO_Rpt.Wor kDate} In Date (" & Format(cmbxDate From.Text, "YYYY,MM,DD ") & ") To Date (" & Format(cmbxDate To.Text, "YYYY,MM,DD ") & ")"...Leave a comment:
-
I don't think you can do that, consider this, say you are using a CR9 with a data sourec of DATABASE1 (say SQL) then you load or call it using VB, during runtime, the data source for that particalur report is coming from DATABASE1 which means the fiield that you drag duirng the design of your report is based on the DATABASE1.
Cheers. Hope this will help.Leave a comment:
-
Hi, I noticed in your code that you have'nt set the correct connection string, and specifyinf a recordset that would call for the records. It may be better if you first try to chnge your connection string as in the format below, then open a recordset but first dclare it as nee ADODB. Take note, add a compnent for ADO I think use the ADO 2.8 dll.
THe int32 here is for double
Dim conn As New ADODB.Connectio n...Leave a comment:
-
try to check the connection string. Also, try also to packge it instead of just making an executable.Leave a comment:
-
I assume here that your are getting data from a database say a Access or SQL? If that is the case, you must first create a connection string for that, afterwards, you can use the below code
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Dim RSFile as ADODB.Recordset
Dim strQuery as string
Dim StrConnection as string
...Leave a comment:
-
Ah, I see, that's what Im missing, I acutally used that ".recordselecti onformula = Date & " combbox.text... .and it says a date-time is required here... I guess this is what Im missing. Thanks for your response. I check it out.Leave a comment:
-
Hi, here are some weblink that might help you, <Removed> usually intgrate CR to object programming language such VB6 or .Net and most of the programming and coding will be made on that PL. .<removed>Last edited by r035198x; Nov 23 '07, 09:50 AM. Reason: Links to other forums are not allowed. Please read the guidelinesLeave a comment:
-
Record Selection in Crystal Reports 9 using VB.net
How to use the record selection formula in CR9 programatically using vb.net? I have a combo box that displays the date. If I select date, I can generate a report based on the selected date. Thanks in advanceLast edited by Killer42; Nov 26 '07, 08:55 AM.
No activity results to display
Leave a comment: