to learn more about dbambs, share content, and exchange messages and invites.
I have done a cross tab report. Work Order is the Master and Task Management is the Sub query. Below is the jist of it: Subquery is Inner Join Work Order ID = Root Request ID Work Order… Show more Community: I have a report I'm struggling to get correct. Here are the details: Smart Reporting 9.1.04 High Level: I want to show all work orders within the past year in a table summary. … Show more In Business Objects I was able to do a count on different queries then Merge the queries so that I have a nice table. I don't think it is possible in Smart Reporting from everything I've tried. … Show more I cannot figure out why my report is having an issue with the Sum of number of work orders and number of incidents. Here is my setup: version 9.1.04 Basic report is Assigned Group - Assignee -… Show more Is there a way to include in an attachment for all the related reports? I've looked through the documentation but cannot find any information on it. Here is my report with 2 tabbed related reports… Show more Has anyone run into a problem with subtraction of 0's? I've looked at all the options on my report but I do not see if this is a customizable item or if there is a way to handle 0's. Here is a… Show more I have a report that I want to show the "ASGRP", "Change Type" (Calculated Field), and the number of work orders. I want the sub total for the ASGRP. For the Sub Total I select "Assigned Support… Show more Smart Reporting V 9.1.04 I have this requirement - Customer wants to see how long a ticket sits in their queue (initially assigned to the support Group) until it is acted upon (reassigned, status… Show more Smart reporting version - 9.1.04 View used - Work Order view We are not able to display the work order status and the task's status associated with the work order. Can anyone confirm if this is… Show more Smart Reporting Version: 9.1.04 I am in need of extracting just the subdomain from the DNS Host name field in the Asset Management View. The problem is the data in the field is not consistent. … Show more Load more items I have successfully setup the aging bucket as shown here Calculate Ageing buckets in Remedy Smart Reporting 9.1 Here is how I have it setup in my table: To sort by days open I had to create… Show more