Search results for query: *

thanks lbass, it works fine, and now I need to add few more features...: * All the values are in secondes, so I would like to divide the summary fields by 3600 (to get it in hours), can I do it by the format tab? * I have another grouping level which call "manager", each manager can have...

I created formulas, added the grouping but can't find how to sum the data for each user, any idea? lbass- do you have a link for documentation of such things? thanks

thanks lbass, can you please explain me again how to do it?... 1. where should I create the formulas? on report -> formula workshop -> formula fields? 2. what do you mean in 'insert a group on user id'? how and where should I do it? 3. how can I add something into the detail section?

'login time' 'work time' '% work time' 'non work time' 'break time' user a user b user c ...

I have a table that stroe login data of users, breaking by several types (e.g. wait time, call time, break time, lunch time etc.), the table structure is: userid, type (of time), and value (in seconds) I need to pull a 'user times' report which calculate the values and show them as follows...

Thank you lbass! the formula give me the abilty to set value of a specific field, but I want to add a computed column (e.g. X+Y...). In the crosstab I would like to see both X, Y and X+Y. Do you have any idea how to do it? (I'm using v10) -Bracha

Hi All, is thee any way to specify the column in a crosstab report? I have a tabel whick includes userid, code and value, the code can be x, y or z, and I want to show it as follows: X Y (X+Y)Z user A user B user C Total

Hi All, Is there any way to select from stored procedure which returns ref cursor (instead of tables, views)? In the sp I have my business logic, and I don’t want to copy it to each report… Thanks!

Thanks nagornyi! Does it mean that most of the work should be done in data model and not in layout? Comparing to some other tools (brio, sqr, crystal...) - the select is very simple (and can be used for several reports) and computed fields / filter / sort etc. are supported in the tool. Thanks...

Hi all, Using matrix report, how can I: 1. hide some of the columns - let's say that there are 4 different codes: A,B,C and D (those codes will be rendered as columns), I want to show columns C,B,D in that order. 2. add computed column which is based on some other columns (A+B/c) Thanks.