Search results for query: *

Hi, You have to use a cursor to do what you want to do it. If you don't know the code to a cursor then please reply I can write a sample code for you. Thanks,

Hi, How do you access database from seagate. If you are using ODBC connection then you have configure the connections to the new server/database.

create formula to covert the string into date using CDate function. Use this date formula to link Main report to the subreports.

What version of crystal are you using?

Hi, Can you confirm that User1 can run this package from DTS designer successfully? May be your SQL Agent is runing under windowsNT login.

It was there, probably it must have been pulled off becuase SI 7.x is no longer supported.

Hi, Create another package which call this package and add send mail task to this new package on it's failure.

Searh the knowledge base for releases or patches.

Hi, Put the sought string in double quotes: "ABC" Cheers

Hi, You have to rename the excel file once it is created to manipulate it as you can not manipulate it when the file is open. Try the following example: Example: Dts package creates the excel file data.xls You rename it data_20031103.xls and use this file in your activeX to mail merge.

Hi, It seems the report got corrupted. I suggest you create another new report from scratch. The date parameters should be automatically created. Then you can copy the fileds and formatting from the existing report and test it.

Hi, Delete Tonumber from the formula and test run it and check for the result. Mid ( ToText({OEFCHEADER_1_NF.OECH_INVOICE_DATE}, 0, ""), 5, 2) There may be data error, one of the field values could be text. This way you can find the problem record and fix the value in database.

Hi there, Don't use custom font, use only true fonts.

Hi, I am sorry to know that my ideas are working. I don't really know what datetime format you are using in your stored proc. Is it possible for you copy the stored proc here? Try this if it is different from my code for the date variables: Declare two more date variables @a datetime...

Ok, tell me did you try with DateTime instead of Date. I guess you have the date parameter value type as date. Change two date parameters to datetime, verify the report and save it. Test run it from designer. Go to info desktop and refresh the report object and schedule it. Enter parameter...

Hi, I would suggest you check your stored proc. Is it returning the results set with same parameters in sql analyser? If so then try DateTime(2003,09,01) and DateTime(2003,09,30).