Search results for query: *

Worked like a dream! Thanks to everyone... synapsevampire....this made my day!:-D texusgirl

Hey that is so close to the results that I wanted! The only thing is it is a string therefore, I can't format field options for date/time. I get 3/1/2005 12:00:00 AM 4/1/2005 12:00:00:00 AM etc... I think 12 months will be the max that I would need to report on. Thanks to everyone on the...

synapsevampire, When I run the subreport I get "A string can be at most 254 characters long".?? Any ideas? Thanks again, texusgirl

It's a new day...I will get this figured out! The main report and all subreports are working fine. This is a new subreport that I am adding to th main. I think my links are fine as you stated, each quoteno will have the same date range. My intent for this subreport is to print each month/year...

They vary because I have 4 subreports all together, all are linked to the main report by the field quoteno. Are you saying I should link this one by quoteno & orderdate? I have the subreport grouped on orderdate...and formatted correctly. Also I selected "Print for each month". Still I am...

Lookin good, just a snag on the range??? The Orderdate and expiredate will vary. Therefore, I won't know what their values are from record to record. I guess that's why I don't see the datevalue purpose?? thanks again, texusgirl

Madawc, Thanks, but that doesn't increment the month year for me. I need a formula that will increment the month year from the orderdate to the expiredate. I have an orderdate value and expiredate value. I need to have crystal increment from begin(orderdate) to end(expiredate) in mm/yy format...

Hey Everyone! Here's my situation. I am using Crystal 8.5 and creating a subreport. The subreport has an orderdate(datetime) and an expiredate(datetime). What I am looking for is a way to create the report that will return the orderdate thru expire date in mm/yy format with a line for each...

Thanks sooo much lupins46! Worked like a charm...all the fields did not look like this but I did a little if then statement and whahla it worked! I am new to crystal so you will probably be hearing from me again. This is a great site.[smile2]

Hey Everyone! I have a question on how to pull values from one data field in order to use them in two different fields. Example: 2(5698) I need to use the 2 in one field and the (5698) in another. Any suggestions? thanks in advance texusgirl

Hey everyone, No need to reply to this one, I figured out the problem. I had my syntax correct DTSDestination("fieldname") = DTSSource("fieldname") + DTSSource("fieldname") etc... The problem was that my destination and source were two different data types, I had...

Hey Everyone, I am converting data using DTS packages. I need to know the syntax to add several DTSSource fields together to get the DTSDestination. I am using ActiveX script. Thank you in advance. texusgirl

Worked like a charm! Thank you so much.[thumbsup2] texusgirl

Hey everyone! I am trying to dump some data and have a field called desc that has a vendor# at the end of the field within parens. I need to extract only that part of the field...any suggestions? Example desc = Test Data blah blah (V#1234); the only part of this field I need to dump is the...

YEAYA! It worked great! Thank you soooo much.

Sounds like that is what I am looking for...where do I put it though?

Hey everyone! Here is the problem...I am writing a stored procedure and need to restrict the number of returned records to 10 and can't seem to make it work. Here is the code: Select POH.PONumber, POH.POEntryDate, POH.DueDate, POD.ItemCode, POD.ItemDescription, POD.UOMCode...