Tauf and David, Thanks for the reply. The product claims that you can create a formula using an SQL based formula, but when I tried it, the report stopped working. Also how do you do a table in a smart reports? They seem to have a lot of graphs but no tables.
Also I don't believe that our customer is willing to spring for BMC Analytics, though they are extremely dependent on our Crystal Reports right now and I don't think Smart Report is going to be able to handle it. I've watched the videos on-line. Do you know if there is any other training available out there? Thanks again, On Wed, Jun 22, 2016 at 11:55 AM, Tauf Chowdhury <[email protected]> wrote: > ** > 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] <[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] > <[email protected]>> > Date: 6/22/16 11:04 AM (GMT-05:00) > To: [email protected] <[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_ > > _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"
