Search results for query: *

I am having trouble with that. I can get the buckets but there isn't a way to count the assets. I made 8 bucket formulas. So for {@bucket1} could I add in the count for the Assets. Something like: if {@megs} < .10 then "0.00 to 0.10" count (assetnumber) I am unsure of what the syntax for...

I have a chart that on of the axis is based off a formula called buckets that looks like this: if {@megs} < .10 then "0.00 to 0.10" else if {@megs} < .50 then "0.11 to 0.50" else if {@megs} < .69 then "0.51 to 0.69" else if {@megs} < .99 then "0.70 to 0.99" else if {@megs} < 1.5 then "1.0 to...

I can't seem to get a summary to work the way I need it to. Seems like it should be easy but it isn't working for me. I basically just need the following if ({provider})="nPhase" then sum({totalmegs}); This needs to sum for the entire report. What am I missing?-thanks

I am having trouble getting a report to group sections based on conditions that I set. I think I just don't know how to do this and am hoping it is easy. I want to have my report tell me how many accounts fall within a range of usage based on megabytes. For example: I have two fields on my...

sorry Lbass, I just noticed that it isn't quite calculating correctly. Here were my results. The first three are correct but after the one that says 1 mon 1 days 03:12:16 they start doing this: 1 day 00:03:01 264:03:01 1 day 00:06:30 264:06:30

24:02:07 25:00:57 963:12:16

Here is my dilema-this is an export from a third party software package that is a .csv which I changed to a .xls. The cells contain this data (all in one column) looks like this: (example) 1 day 00:02:07 1 day 01:00:57 1 mon 10 days 03:12:16 If I use crystal to report against this worksheet...

I am realizing that now as well. I just asked the same question of the person I was helping. Thanks for the information anyway.

That doesn't seem to be working like I need it to. Some fields contain something like this: 1 day 06:34:21 1 mon 10 days 03:30:15 1 day 5 hours 00:12:50 I tried seperating each section and then changing them to [h]:mm:ss but for the field that contains 1 mon, it changes it to 24:00:00. If...

Is there a quick way to convert this: 1 day 00:02:07 1 day 01:00:57 1 mon 10 days 03:12:16 1 day 00:03:01 1 day 00:06:30 to hh:mm:ss Thanks

I'm sorry, I think I didn't realize what I actually needed. I need it to search a1:a500 and where it sees an "A" in that column, I want it to print what is in column c. There will be more than one instance of this. The spreadsheet contains information spread out and doesn't have just standard...

I don't know if this is possible but I would like to populate a second worksheet with data from c1 where a1:a500="A". I know this formula will get me one record and if I drag it down, I will get a bunch of "False" then a record. I know why that is happening but how can I get it to just display...

This works for every other record whileprintingrecords; numbervar diff := 0; diff := {testtime_.Time}-previous({testtime_.Time}); Is there something I can add that tells every two records instead?

Actually, there could be several records for any given day. So I could have 4 on/off times for one day or more. I would like it to look like this: Johnson, Lee 10/1/07 10:00AM ON 10/1/07 10:30AM OFF 0:30 10/1/07 3:00PM ON 10/1/07 3:300PM OFF 0:30 10/2/07 2:00PM ON 10/2/07 3:00PM OFF...

I have a report that looks like this: Wilson, Ted 10/19/07 9:26 am 10/19/07 10:56 am 10/21/07 8:00 am 10/21/07 8:50 am and so on. What I need to do is evaluate the time difference for every 2 records. I would also like to be able to have a label that will say "On Time" for the lower...

I have a report that will show a variety of information. This is coming from a spreadsheet. I have 15 rows of data with a count for each field. Column A=Inspection and Column B=count. I want to create a chart with only the top 10 inspections. Is there a way to display only the top 10? (this...

I am having trouble getting this formula to return a count. Can someone tell me what might be wrong with it. I am using crystal version 11 developer. if (GroupName ({@monthname})="January") then count({Gprsfware.SCID}) I need it to count all the records for field SCID that were added in the...

Still no luck. This is what is entered in the formula and my fieldname is a formula as well. I am using crysal reports version XI. if ({@MEGUsage})>=1 and ({@MEGUsage})<=3 then=1 else 0 It doesn't like the "=" sign now. It is the same error message as before. Maybe I am making this to hard...

That doesn't work either. It doesn't like the <=3 portion. It gives me an error that it should be a number, boolean, currency, etc.

Thanks for all the information. I was able to get the files imported without having to use excel. I don't think I made the problem I was having very clear above. But none the less, I got it worked out.