Recent content by fcullari

I put a portion of the table below I need to get data from limittypesequence 2 value1, fractionvalue1, value2, fractionvalue2 and if limittypesequence = 4 value1 and fractionvalue1. If I open the condition to limittypesequence 2 and 4 I get duplicate tests and the columns do not line up. I'm...

There are separate data values for limitsequence 2 value 1 or fractionvalue1(Lower Spec Value) and another set for limitsequesnce 4 value 1 or fractionvalue (midpoint), your suggestions would only show 1 value.

I have a field limittypesequence and need data from 2 and 4, I was able to figure out the calculation below for 2 separate variables but when I put it in a table I cannot get the results broken down for the same parameter id. =If IsNull(<Fractionvalue1>) And <Limittypesequence>=4 Then...

I have a report that requires a sample # to also show as a barcode. I have the barcode font that I need but do not know how to add it to the report?

How do I put in a blank when I do not require the parameter, but want the rest of the conditions to run in the report? After coding like stated above, how do I allow blank as an option?

I have to create a crystal report that will need to filter by 4 different selections: Factory, Source Order#, Style and Color. There can be nulls in any of the selections which will need to be skipped, and they want to be able to choose multiple selections on any of the selections. I tried...

Thanks synapevampire, If you do come across your article with alternatives to bubble sorting, Please send it to me. I appreciate the example you sent me and I will try and use it

I need to sort on a string field and have it list the fields that are separated by comma's I have style numbers in a large string field - 0559, 0592.0560,057888, 0364, 0258 I want it to list in a column: 0258 0364 0559 0560 057888 0592

Can someone help me on this one?

It's a simple formula {datFieldUser.Field_Value}

I have a string data field with numbers separated by comma's. Example of data: 0470,08161,08845,28845,0458,08058,41319,41329,41330,44154,44450,44454,R00600,M0458,M00600,M02600,F00458,85264,83454,83444 I want to have these numbers listed in a column and sorted expected output 0458 0470 08058...

I have a data field that has a string of numbers, I want to have each number list separately, and be able to sort by those numbers. Example of data field: 0470,08161,08845,28845,0458,08058,41319,41329,41330,44154,44450,44454,R00600,M0458,M00600,M02600,F00458,85264,83454,83444 I want to see my...

Thanks, I'm almost there now. But instead of a coded date I need to use a formula date @Transdate or a Parameter Date ?Date. What do I need to change to make that work.

I've been researching how to sort a query by a date within a history field. Beginning of field - On 03/21/06 10:08:00 AM SM made the following changes:The Value For Misc 11 was changed from to BTThe Value For Misc 13 was changed from to RETOn 04/18/06 10:08:07 AM SM made the following...

I created all the formula's for the start and end dates, now how do I get the Calendar_name fields for break along the top with the dates. I just need Calendar_name fields for the Product Development tasks, and I need them to show from the top. Style Season Bid Pkg Approved Cost...