My organization has had Smart Reporting and we use Remedy onDemand. The tool is powerful and can deliver the reports but it's been buggy when it comes to calculating date/time queries. We are also having issues with the way user sessions are translated from ITSM to smart reporting. The handoff of the session is not clean. I don't know that you can run direct sql. You would probably need to create the views and the queries using the GUI and then view the SQL.
Sent from my iPhone > On Jun 22, 2016, at 11:22 AM, David Charters <[email protected]> > wrote: > > ** > Yes smart reporting will work for most reports. You can also implement BMC > Analytics for complex reporting using cursors and other advanced functions, > which if done right blows regular Crystal reports out of the water. > > > > Sent from my Verizon, Samsung Galaxy smartphone > > > -------- Original message -------- > From: Joanne Janssen <[email protected]> > Date: 6/22/16 11:04 AM (GMT-05:00) > To: [email protected] > Subject: Experience with Smart Reporting? > > ** > Hey, > > At this point I am a Remedy user/report developer, rather than a Remedy > Developer, just as a preface (they won't let me get my hands on it!). But my > question is about Smart Reporting. Has anyone used it to create reports? We > have developed some very sophisticated Crystal Reports, however we are > transitioning to Remedy 9.1 and have been told that we can no longer use > Crystal, due to security concerns. I'm trying to create some of our simpler > reports and have run into some snags. > > I've created Views for our HPD:Help_Desk based reports, and used some of the > canned formulas that Remedy supplied successfully, but have not been able to > create any of our customer SQL formulas. Does anyone have any insight into > this? > > Thanks > > Joanne > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
