Recent content by prettyangel

Thanks jebenson I've done that now.

I have a stored procedure that accepts 2 input parameters. I designed a report and specified default values for this from crystal reports and it works well, but now I want users to be able to specify values at run time from VB6 environment but all I get is an empty report, I don't know what the...

I have a stored procedure that accepts 2 input parameters. I designed a report and specified default values for this from crystal reports and it works well, but now I want users to be able to specify values at run time from VB6 environment but all I get is an empty report, I don't know what the...

MisterMo, It's still the same error I'm getting, though the value is correct.

MisterMo, Thanks for your response but did you try replicating this on your own system? Because I'm still getting the same error message.

Thanks MisterMo, It failed. Crystal reports said "Not enough arguments have been given to this function" {Tablename.date} = Date(2005/12/22) but when it is in this format it displays result correctly. {Tablename.date} = Date(2005, 12, 22)

Thanks MisterMo for your response. Yes all my reports are integrated with VB and yes all my reports are working. In fact I've been able to view reports based on other sort criterias I'm only having problems with Date Criteria.

MisterMo, I've tried it to no avail, I'm stuck. I keep getting the same error message. Or could the error be due to the fact that the crystal report control on my vb is version 8 while the report file was designed with version 7?

MisterMo this is what I saw in debug view The date below is displayed exactly as it is in the database. "22-Sep-05" meanwhile crystal reports will take Date(2005, 09, 05) directly from design view. But my problem now is how to pass it from vb end. Formatting it to look like Date(2005, 09, 05)...

Thanks MisterMo, I removed the single quotes and it still gave me the same error. when I put the same selection formula directly on crystal reports design view I got the desired result but I noticed that it formatted the date as "YYYY, MM, DD" BUT EVEN WHEN I TRIED this in VB I still got the...

Thanks MisterMo for your response. I tried your suggestion and I got this error message ------------------------------------------------------------ Error in formula <Record_selection>. ' ' The remaining text does not appear to be part of the formula...

Thanks Ian for your response I must apologize for giving half information. Actually, the combobox is being populated by a table in my ms sql 7 database and the field data type is datetime. So I want users to specify report to be viewed based on date selected in the combo box. Thanks for your...

Hi All, I'm using crystal reports version 7.0 I passed a selection formula to crystal reports from visual basic 6 but it's telling me "error in formula record selection" The vb code is below ----------------------------------------------------------- Report.SelectionFormula = "{Tablename.date}...

Thanks BobRodes and MzKitty for your responses. Do give me time to get back to you.

Thanks BobRhodes for your response. I don't want to use a function to get my output. I want to input my line of codes directly behind the click event of a command button. secondly, I need help getting the output parameters value as well as plugging that value into crystal reports 7.0 using...