Search results for query: *

I can't figure out why this is happening. Any help would be greatly appreciated. I have a report with just one group, it pulls almost ALL of the information it needs from one table in my database. There are 2 fields however that I need it to report that aren't located in that table. So I...

ok....I'm smoking weed or something. The formulas that I have in right now work. The parameter is a string, so it doesn't make sure that they put the date in in the right format, but it at least works. If you have any suggestions on how to improve it, I would love them. BTW, Thank you OCS...

I'll try to explain it better. I am trying to basically create a "To Do" list. In my program, there is a table called TrackItems where they can assign tasks to each other and themselves, but there's not a report made that will bring up their "to do's" for each day. I have...

Synapse, Will that still work if my {table.field} is stored as a number? or do I need a tonumber function instead?

Dgillz, It has to pass through to SQL because I am designing a report to be run on a program called Proform which uses the SQL query to run its report. I have gotten the report to run great in Crystal Reports, but ProForm only sees the SQL query.

dgillz, will that pass through to my SQL query? That's the issue I am having now. I have a formula that will do it, but it doesn't get through to the query.

Ok, I'm going to try this another way. I have a parameter which is a string input field. My end users will be inputing Dates into it in the 05/10/2003 format. I need a formula which will convert that string into a number field in the 20030510 format. Any help?

hmmmmmmm.....I'll keep trying. Thanks again for your input.

That didn't fix it either. I have a formula that works when I run it in Crystal Reports, but it doesn't pass through to the SQL Query: WhileReadingRecords; NumberVar input := {TrackItems.DuDt}; If input < 19590101 then Date (1959, 01, 01) else Date ( Val (ToText (input, 0 , &quot;&quot;)...

Synapse, I get the same error if I try to insert the shorter formula into the selection formula. Any more thoughts?

I do have a paramater called startdate. It's a date field, I'll try your second suggestion. Thanks for your patience...This is all extremely new to me.

I copied exactly what you had posted and created a new formula and pasted it into it. val(totext(year(minimum({?StartDate})),0,&quot;&quot;)+ iif(len(totext(month(minimum({?StartDate})),0,&quot;&quot;)) =...

I didn't think I was using summary or running total fields. How can I stop from using them? They aren't anywhere on my report.

Synapse, I tried inserting your formula into my Report, but when I try to save it, it tells me that the summary/running total fields can't be created. What does that mean?

I am REALLY new to Crystal Reports (I've had it for two days now.) How do I add that function that you pointed me to to my report? Also, when I run the report, it asks me for a date range, but I can't get the range I input to search the dates in the database because they are all in numeric...

I am using Crystal Reports with Softpro's ProForm. I have NEVER programmed before and need some help. ProForm stores its dates in an odd format. It stores them as a number in the 20030430 format (April 30, 2003.) I am trying to create reports, but I don't want to have to teach my employees...