Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 04-12-2009, 11:00 AM
lazlo24 lazlo24 is online now
Registered User
 
Join Date: 12-10-2006
Posts: 23
Reports or totally fields

Hi

Is there a way to run a report or to get a total of a field.

I have created a field for my projects to estimated time to complete and I would like to total that value up.

Has anyone worked out a way to do this either within URD or if required, outside of URD using URD data?

Thanks
Reply With Quote
  #2  
Old 04-12-2009, 05:12 PM
$bill $bill is online now
Registered User
 
Join Date: 09-14-2006
Posts: 210
Column totals/calculations is on the "roadmap" for a future update.

The workaround that I have used for some calculations requires copy and pasting a grid from the Related Items Pane into Excel .
Reply With Quote
  #3  
Old 04-13-2009, 10:56 AM
lazlo24 lazlo24 is online now
Registered User
 
Join Date: 12-10-2006
Posts: 23
Thumbs up Export to excel answer

Well I found a way.

It is not available within URD but there is a nice way to get the data out an into Excel whilst maintaining the format of the data.

1. Using a search create a list of all of the items within the required scope.
2. In the search results window, set the columns you need in the report (Only need to do this once)
3. In the search results window, select all using 'Control A'
4. Copy grid values using 'Control Shift C'
5. Paste into excel.
Now you can play with your perfectly exported data.

I tried to you the export feature of URD but the filtering and select mechanisms are too basic and you tend to get rubbish data out. This report running into excel works sweet.

What goes to the top of my wish list is an export search to excel button (Or at least export search grid data to clipboard)
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 08:03 PM.


Copyright © 1999-2023 Kinook Software, Inc.