Search results for query: *

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...

I will try this longer version. Thanks for your help.

Cross tab within the report does not solve my problem. They want a tabular report with all the tasks broken down and the start & end times under the tasks. I've never done this kind of report with Crystal before.

I created a formula field for all the Calendar Names - Example: IF ISNULL ({TACalendar_1.Name})THEN 0 ELSE IF {TACalendar_1.Name} = 'FINAL COST APPVL TO FINANCE' THEN 1 ELSE 0 Because I need to breakdown the Calendar Names and then put the Start and End dates per that task. The Calendar_ID...

There is a StartDate and EndDate fields. [Calendar ID] [Style] [Season] [Calendar Name] [Approved [Bid Pkg [Dev Cost] Sent] Spec] [Start [End [Start [End [Start [End Date] Date} Date] Date]...

I need to breakdown fields by task type and then list the start and end dates for that task. I'm using Crystal 9 with NGC's eSPS software. We have calendars setup with tasks and I need to breakdown each task with it's start and end dates. Task Types (TACalendar.name) - Approved Cost, Bid Pkg...