Search results for query: *

Here's my issue: I have a report where Group 1 is the Date, and Group 2 is the time. I've got a field where in order to get the data I need, I create a sum of this field (represents a value in seconds for the record) in Group 2, suppress it, and then have a formula that is displayed (Sum...

I found it! Here's the formula (from crystal's knowledge base...was buried in another function): local numbervar RemainingSeconds; local numbervar Hours ; local numbervar Minutes; local numbervar Seconds; //divide the @TotalSeconds by 3600 to calculate hours. Use truncate to remove the...

I have a field where I have a time value that is displayed in Seconds. I need to display it as HH:MM:SS. I've been looking and looking through the help text and the knowledge base on Crystal's site, and can't find anything...anyone know how to do this?

That was it! I knew it had to be something simple like that, but sometimes staring at all the formulas makes you a bit blind...

I'm trying to display in the header of my report the value for last month (in the following format - "December 2002"). How can I do this, especially since I'm not actually reading this value from a particular database value?

I just tried this. Now my problem is, how do I do a comparison (count) of records created in the month vs. records resolved in the month? Only solution I could find was to use Running Total fields, and then I still can't use them in a chart. Ack - this is insane!

Unfortunately, I don't think I can. The problem is, I have one set of records that were created in a month period. I select them based on the Create Date field = the month I need. Then, I have to pull records that were resolved in a month period. They may or may not have been resolved in the...

The worst part of this is, I have to use Running Totals because I have to use shared variables that I'm passing from a sub-report. What I really need to do is have two calculations - one where I calculate the number of records created in a month, and compare it to the number of records resolved...

Here you go: Name: {@TotalDisplay} Formula: WhilePrintingRecords; numberVar Total; Name: {@RunningTotal} Formula: WhilePrintingRecords; numberVar Amount; Amount := Amount +{@Res1stNYSS}; Name: {@Res1stNYSS} Formula: if {@TimeDiffOpen_Resolve} < 20 then 0 else if...

The report is grouped by the following formula: @Create_Date_Month - Month ({@Create_Date_Full}) Values are based on: @Pct_Res_1st - found in the above group of the report If isNull({@TotalDisplay}) then 0 else if {@TotalDisplay}=0 then 0 else {@AmtRes1stCall}%{@TotalDisplay} Since I've...

Oh - and I check on &quot;Don't Summarize Values&quot;, because all I want to do is use the actual number that is shown on my report...

I'm running CR 8.0 Data Tab - I select &quot;Advanced&quot; Place chart once in the footer Select &quot;On Change Of&quot; @Create_date_month (formula field that pulls the month value from a date field, this is how I'm grouping my report) Show Values: @Pct (formula that I use to get the...

I realize this is an old thread, but I am having this exact problem currently. Does anyone know why this occurs? Thanks, Rebecca

Ken - actually, I thought of the Crystal Dictionary solution last night...I've been playing with it today, and although I do have formulas that couldn't be written in v. 5, I can still create them - it tells me that they're wrong when I save, but I save anyway, and they seem to function...

I have several formula fields that I've constructed that I will use on many reports. Is there an easier way to insert them into a new report other than opening another report that has them, then copying/pasting? Perhaps there's some sort of tool for &quot;sharing&quot; them across reports...

Is there any way of stripping out/preventing the prefix of &quot;DE_&quot; being added to my column names when I export a Crystal Report into Access via ODBC? Thanks, Rebecca

Oops, my apologies...since I'd made the subreport so tiny on my primary report, and the subreport tab didn't automatically appear, I just assumed it was &quot;gone&quot;...however, then I saw that all I needed to do was double-click on my subreport to bring up the tab...thanks anyway!

This has happened to me a few times now...I have my primary report, and I've attached a sub-report to it (not creating a new one, but attaching a separate report). I make changes to both the primary and sub reports, I save and close the primary report, and when I re-open the primary report, the...

Thanks Ido...that did the trick (even though I spent the afternoon driving myself bonkers, going through Crystal's website - ack!) Cheers, Rebecca

K - Your formula worked well (for some reason, despite checking off the Null qualification in the Report Options, it seemed to have no effect), but now my problem is that I can't use my formula field as a Group By field? Any ideas why that would be?