473,379 Members | 1,539 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

How to solve error "the specified value type is different to the current value type"

hi,
i have used sql2000 stored procedure with 2 date parameters to create crystal report 8.5. when i am sending date parameters from vb6 and calling the report, its giving error "the specified value type is different to the current value type"
here is the code:
With CrystalReport1
.Connect = gconConnection
.ReportFileName = App.Path & "\Receipt Reversal.rpt"
.DiscardSavedData = True
.Destination = crptToWindow
.WindowShowExportBtn = True
.WindowAllowDrillDown = True
.StoredProcParam(0) = "@DateFrom;" & "01/01/2010 00:00:01AM"
.StoredProcParam(1) = "@DateTo;" & "01/20/2010 11:59:59PM"
.Destination = crptToWindow
.WindowState = crptMaximized
.Action = 1
End With

but its giving error like specified value type is not matching with current value type. i changed date format but still getting same. am using crystal reoprt component in vb6 to call crystal report. any help will be appreciated.
Jun 27 '10 #1
5 4689
vb5prgrmr
305 Expert 100+
CR may be expecting the date values to be surrounded by delimeters like access does (#), or sql will accept single ticks (') around a date. See CR's help files on dates to check...



Good Luck
Jun 27 '10 #2
hi thks for reply but i tried single quotes also, hash sign also, but still not working. searched on net yet no result. still waiting to get it resolved.
Jun 28 '10 #3
vb5prgrmr
305 Expert 100+
Did you check CR's help files? They have examples in the help files...



Good Luck
Jun 28 '10 #4
@vb5prgrmr
yup i checked help files also but i didn't get information abt date parameters
Jun 29 '10 #5
vb5prgrmr
305 Expert 100+
Hmmm... Well hopefully someone can come along here and set you strait as it has been awhile since I used CR for anything...



Good Luck
Jun 30 '10 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: dice | last post by:
I have built a .NET based service that uses a number of related 3rd party dlls. If I compile my code into a dll and use this in a test app all is well - however if I compile my code as a service...
2
by: CLEAR-RCIC | last post by:
Hello All, I wrote a .dll that programatically maps two network drives and copies files from one drive to the other. The .dll works fine when using an .exe to call the .dll. When I call the...
3
by: Daniel | last post by:
If my System.IO.StreamWriter Write method throws "The specified network name is no longer available." and I try to Dispose or Close it in the finaly clause the close or dispose method just throws...
3
by: Big Dave | last post by:
Hello All, I was wondering wether anyone could help me solve what is probably a very easy issue. I keep getting this damn "The administrative limit for this request was exceeded" whenever I try to...
0
by: LordHog | last post by:
Hello all, I would like to use the new SerialPort class in Visual C++ 2005 Express edition, but I am having problems adding my event handler to the DataReceived event. In the header file I have...
0
by: Kevin Buchan | last post by:
I have some code to query Active Directory group membership, based on an LDAP path. This works beautifully in my test exectuable, but when I try to move the class I built into an ASP.Net web...
1
by: Brad | last post by:
I'm trying to use Active Directory to retrieve information for a user...for display purposes.. I am not using windows authentication or impersonation....I am using a fixed user id and password for...
2
by: omer681 | last post by:
i have IIS 5. When i enter to a .asp page in the server, its not loaded and an error named "The specified module could not be found" is appear, and replace everything other. help please?
12
by: dkurth | last post by:
Hi, I'm running PHP 5.2.3 on Windows 2000 Server with IIS 5. I'm trying to get cUrl working, so in my php.ini file, I have this line: extension_dir ="F:\PHP\ext" And later, I have: ...
4
by: joesri | last post by:
i have received an "Unable to load dll ".dll". The Specified module could not be found " while running ASP.NET Web Page. I have placed dll and supported dll in wwwroot\bin directory,but it is not...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.