I am trying to write a report where I return rows with number data fields. It doesn't matter from which table I'm getting the data, as this is a more general question.
In any case, I would like to know if it's possible to do any of the following.
1. calculate a field in the report: I get two number fields from a table and would like to, say, add the columns to display in a new column.
2. Create a new column and populate that column based on data in another column: e.g. If Column1 = blue then CalculatedColumn =12 else CalculatedColumn =6)
3. Count distinct: Retrieve a number of rows that would include data from a report accessing Tasks, Request Items and Requests, then find how many distinct Request Items there are (for instance, let's say I have 20 tasks for 16 RequestItems which were part of 10 Requests...then I'd like to see a distinct count of 10 Requests.
It seems like it would have to be possible, but if none of these is possible in a standard report, is there another approach to find this data? Please keep in mind that I'm just getting started in this and if you give me code, I won't have any idea where I would write or call the code.
Thanks,
Eric
