Search results for query: *

That worked, awesome! Thank you both for taking the time to answer!

...whileprintingrecords; stringvar v_hours := split(totext({WOO_HistoryTransaction.StartTime},[highlight #729FCF]"#.##",2[/highlight]),".")[1]; stringvar v_minutes := split(totext({WOO_HistoryTransaction.StartTime},"#.##",2),".")[2]; time(v_hours & ":" & totext(tonumber(v_minutes)*.6,"#",0))

Hey guys, I've got a couple fields I'd like to convert to time. The string looks like 6.000 or 20.500. Both values would be 6:00am and 8:30pm. I'd like to get it to a time format as well so I can append it to the date using the dateime function. I've googled and everything I have tried has...

I am creating an Access DB mainly for ordering tracking purposes. I would like to be able to add a button to the form that would allow me to pass the order number and print the corresponding pick sheet or sales order, via VB, without having to log into MAS90. I did some searching, could find too...

CR 8.5 is the version I'm on. What I have is a database of baseball players and would like to format the players sums and averages so that if they are in the top 3 color the font red or whatever. I have 2 groups, g1 is stats.player and g2 is stats.opponent. The avg field for example for the...

I'm trying to figure out what I've done wrong, but can't seem to make sense of it. I'm trying to conditional formatting of fields that have certain text in a description. Here is the formula: if {SO_24CRWPickingSheet.ItemDescription} like "Discontinued" then crBold else if...

Damn that looks simple... Can't believe I didn't think of that. Man do I feel stupid right now... Tried it, worked great, as usual, LB! Thanks for your help again!

First off thanks for your help LB, I hope I don't confuse you more with this post, but here goes... I left out the fact the want two qty's purchased, one for this year to date, and one for last year to date. The same with unit price. They want the qty's summed and the latest unit price for...

ok, I didn't get it completely right... The Previous year still isn't working. Current year is fine though.

Nevermind guys, went a different way, and used a formula field instead of a running total field.

I've got a report that is pulling items purchased and unit price. I've been asked to only pull the latest price though and sum the qty purchased per part number. I've created a group for customer # then a group for item #. In the Item # footer I have qty purchased sum and the running total...

Sorry about that. Someone called me and I just clicked submit. CR 8.5 & ODBC (MAS90). ** exapmle ** Item # Unit Price 125 .25 .25 .30 .35 .40 What I want to do is create a group for the unit price, becuase nth...

I'm trying to figure out the nth smallest number for a report the has unit prices in it. I can't get the nth smallest to work correctly because the unit prices are duplicated for our item numbers. Is there anyway I can create a formula that does the nth smallest for groups? Thanks for any help!

Thanks for your help guys, rnd's solution fixed it for me.

I'm having a problem getting the time portion of a timestamp to show in CR 8.5. The only thing that shows is the date. If I use the same fields in Excel, I get both the date and time. What am I doing wrong? Thanks for any help!

that's exactly what I'm look for.

I've been looking in here and on the net trying to figure out is I can auto refresh a report in Crystal 8.5, but can't find anything. Is there any way I can auto-refresh a report in CR 8.5? Thanks for any help!

NM Synapse. I figured it out! Thanks a lot for your help!

Synapse - That works great, however, I can not create a group for the formula field now. I sthere anyway I could do that with this formula, or is there another way to do it? Thanks for your help!

Synapse - You are correct in your assupmtion. I meant the text output based on the fields. Thanks. I will give that a try. Turk - I'm not saying you're incorrect but I have another report with this fomula and it works perfectly... The only difference is that it uses one field form the DB...