Search results for query: *

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...

refer to faq222-2067 posted on the 20th of June 02. I still maintain that I need to know how to pass the value of a parameter to crystal reports. I have a stored procedure in sql server 7.0 and created a parameter collection to create the required parameter in Visual Basic 6.0 environment, but...

Thanks all for your response. I'm okay for now, my users are working.

Thanks jebenson, I've sucessfully installed now but my back end is MSSQL SERVER 7.0 and now it's telling me "database dll not found" Pls does it mean I have to install sql on the clients machine? I'm a novice.

jebenson thanks for your response. I've downloaded the inno setup tool and i've used it to compile the application but i can't find the setup files anywhere. I probably haven't looked well enough but I'm sorry they need it in the next few minutes. Please help!

Hi all, Please I need fast help on how to install a Visual Basic 6.0 application developed on windows 2000 server on a windows NT workstation. I used Package & Development Wizard to prepare the application for deployment but on the workstation it's not installing it's saying one or more files...