I'm having trouble using SHFileOperation to move files between two directories. The problem occurs when the source folder contains a subfolder that is not found in the destination folder. I would like the application to create the subfolder in the destination folder without confirmation from the...
I don't think you're going to be able to ignore table2 and table3 based on the parameter entered if you build the query in Crystal Reports. Of course this is easily done using a stored procedure. Have you considered doing that? I'm not sure if that is an option for you. Depending on the database...
It sounds like you are getting the cross product of the two tables. That happens if you don't provide join criteria. With the report open, check the Visual Linking Expert in the Database menu. The two tables should appear with an arrow connecting the two. If the arrow is not there, you'll need...
Can anyone tell what is wrong with the following:
strCurrentPath = "Sellers/Test/"
Response.Write Replace(strCurrentPath, "/", "\")
The results are not what I expected...
Sellers/Test/
Does the slash character have any special meaning? TIA
How about creating a calculated field based on the datediff in minutes between the recordcreatedate and a constant (say today's date, 12AM) and divided by 15?
Interval = DateDiff(n, DateConstant, RecordCreateDate)/15
This will return an expression of the time of day a record was created in 15...
I'm assuming that there you are looking for the number of days between orders placed by the same customer, otherwise the answer is likely 0 since they probably have lots of orders daily.
To do this, you need to set up a report that groups by customer and sorts by date. Next check out Crystal...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.