Search results for query: *

I posed this question a few months ago - this was the reply I received and the Fix( ) worked for me. "You can either use a database function (if your rdbms has one) so that it is faster, or you can use Actuate's Fix( ) or Int( ); either will truncate any decimal places, returning only the...

OK - The Start and End date is always the same (Parameters for report dates (ie 1/1/04 - 1/31/04) I suppose I could set 3 controls using the conditions. The report is looking at one specific result type "a", but each employee that qualifies also needs to meet the min results in "b", "c", "d"...

I'm not quite sure I follow. If you mean do I have access to the database then no, I don't have access to the data where the information I need is stored. My only access to this data (aside from pulling down tables into access to run analysis) is through Actuate. I'm sorry if I'm not...

That is what I need to do. I have a grouped report that I need to highlight the best performers in each product by division. That control is a computed value. What I've read for this type of sorting seems to include extensive coding as well as performance issues. Is that correct? Chris

As always you have been very helpful. If I hear anything about Microsoft's SQL reports I'll be sure to forward. If you have some spare time I have another post out there that I'm having difficulties with... dynamic sorting. This I anticipate to be my final Actuate report. With 5 completed...

Bill, I was wondering if you could offer an opinion on the strengths and weaknesses of Actuate verses Crystal reports. After a short time using Actuate the company I work for is considering a move to Crystal. As you know, I have only a "tiny-bit" of experience with Actuate and was wondering...

I am trying to sort a grouped report by results in a control. My first grouping is for Divison, then employee. I need the employees within each Division to sort descending by results. The control that holds the results contains the following logic in the value exp. Sum([PolCount])...

Thanks! Fix() worked perfectly! You are the best! Chris

When I format the controls value it still rounds up. All I want is for my value to be expressed as 95 rather than 95.5. Something that should be so simple.... sorry very frustrated today. Thanks for your help on the Date problem it's working great!

It's me again. Do you know how I can RoundDown in Actuate? The standard RoundDown(0.0,0) function is returning an error. Thanks!

Sounds like I may need the Now(). We won't always be running the report on the 1st of the month... (good point). My Start and End dates are Parameters -- Unfortunately, I didn't design the portion of the Liabrary that drives all of our secondary reports. It worked so I basically went with...

When -- hmmm The reports are generated monthly. February would be using January results however, the group of people that I need to include in the report is the condition that would be changing...basically, for one report it's anyone on plan for the year preceding the report date. The second...

Can I ask you a question about the Parameters in Actuate? I have a couple reports that are running fine in Actuate however, when I move them to the web there are some dates that will need to be updated monthly. Is there a way to set this Condition "Dynamically" (for lack of a...

Thanks Again Bill. I suppose then I shouldn't be discouraged after only 2 months with the application. Chris

Thanks for your help. I was finally able to make it work. I've moved on to another section of the report and once again... it's not working! How long did it take you to master this software? Actuate is definetly a challenging product to learn.

I have the Value Type sent to AutoValueControl. Is that ok? I tried to put the iif in the Value exp (the DateDiff formula) and it wouldn't run. I was told that Acutate couldn't handle complicated iif statements in the Value expression that it would I would need to sent the datavalue...

Yes, they are aggregate controls. One sums pol cnt and one calculates an objective based on an if statement. The If statement is in the Finish () the datavalue is based on a DateDiff calculation in the the Value Exp. How do I set break points to "get" the values? Thanks for...

No. I'm still either getting a null value or all No's. I checked the slot information and my "Qualified" cell is last. I'm sure I'm overlooking something. Should I be inputing the GetControlValue in the Value Exp of my control or in the SubOnRow method. If it belongs in the...

Thanks for your response, but I'm still getting incorrect results. I checked the order of the controls and my "qualifed" control is last. This is my code and I'm getting all "No" for a response. iif(getcontrolvalue([PolCount])>=getcontrolvalue([PolReq]) and...

Can someone help me understand how this method works. I need to reference the value of two separate controls in the formula of another control? I just can't seem to make it work. Thanks!