Search results for query: *

Guys (and dolls), I have a problem that is baffling me: Can I make a parameter-driven grouping that includes Top-N or typical group name? I.e. We have circuit data: Trunks and circuits on the trunks, Trunk bandwidth, and circuit bandwidth. I would like have user-parameter input that will...

--OOps... just posted in NEWS instead of as a QUESTION. Sorry... Here's the QUESTION (along w/ the news, if y'all didn't know...) Just got a question regarding Microsoft and ActiveX technology. Evidently MS is fighting (and losing) a patent case w/ Eolas Technology (Wasn't Eolas an elf in...

Just got a question regarding Microsoft and ActiveX technology. Evidently MS is fighting (and losing) a patent case w/ Eolas Technology (Wasn't Eolas an elf in LotR?)... The upshot is that MS is going to have to cut some ties 'tween IE and plugins. Does anybody have an idea of how this will...

Hi folks, I have a problem that I am having a hard time research and subsequentl, solving. CE 10, XP - my laptop (local development system) Have reports that WERE running, then turned up an error that I cannot shake or pin down: "There was an error retrieving data from the server: Cannot...

We have a need for a report to run from the MOST RECENT Wednesday back one week. 00:00:00 Wednesday back to the PREVIOUS 00:00:00 Wednesday What the best way to get that most recent week, w/out manually scheduling? You need to calculate the most recent 00:00:00 Wednesday. From there...

Hi folks, One of the developers for a system we are interfacing w/ asked for a data dictionary for some of the fields. I know we "should" have one, but the guy who would know isn't in. I know that the developers have tried to keep the help system updated. I know Remedy is pretty much...

We need to test several fields (four) against a user-entered list of words. All fields will be tested for any of the terms embedded anywhere in them. i.e., "UPS": "User reports UPS failure at site." i.e., "Power": "Power supply failed" The user enters their list of words into a parameter...

Folks, I have a problem with a badly behaving report (grin). We're trying to run the report from a far-remote SQL server. My WHERE clause runs fine in developer but won't run (at all) on the APS -- it blanks out. The server has hundreds of thousands of records, and a typical run w/out any...

While researching something else CR on the web the other day, I ran across a mention of setting a color "constant" in a user formula (with other report constants). The idea was, you could define several constants in one formula and just copy/insert that formula from report to report. From w/in...

Hi, We have a new report developed under 8.0 to run under SI 7.5 (I know, but we'll upgrade soon). It runs FINE in developer, but when we try to schedule it under SI, it failed. The only text in the Message is "PEStartPrintJob : " In other words, PEStartPrintJob is blank. All other...

I have a peculiar report redesign, with even more peculiar results, and I've hit the cognitive wall... We have two joined tables, one with basic (helpdesk) ticket information and a new table with multiple "ticket parts" in it. The time totals for each ticket are stored in the first table... I...

Folks, I have a peculiar reqest from mgmt, namely, to come up w/ a "report" ("even if it's just an excel list") that will step through every field in every table in our Remedy DB to see which of the fields are not being used. I know, strange, and ... a "bad" use of resources -- but I still...

Or, "Too many hands"... We had another group "run some scripts" just before we started having various users experience access issues. The acting SA has reviewed permissions and "patched" as best he can, but I have question relating to one of the symptoms we have noticed: We are having event...

Hi folks, We have a remote site that has some problems that I'm trying to troubleshoot/fix, and I need a leg up: Site SA has reports published... when users try to view, they may or may not get errors upon drill-down, featuring "Object not found". S/He thinks it may be because the database...

Hi folks, I have a report request that I am working on but I am trying to wrap my mind around the best way to approach things, and I'd appreciate input. "They" are trying to get a feel for all (ALL) the fields in our Remedy helpdesk app that aren't being used. The way *I* proposed to do this...

Hi gang. I have a longish parameterized query consisting of several unions of bi-drectional outer joins. The resultant query just misses fitting into a single stored procedure (certain combinations of the parameters yield a nvarchar over 4000 characters). It has been suggested that I split...

I have to compare Remedy data tables from a main site to four sub-sites. I can do this by using left and right outer joins (to similate full outer joins). I came up w/ the stacked union queries to check Master->Site1, Master<-Site1 Master->Site2, ... Gave that to our (new) DBA guy and...

We have a data comparison project and I've been asked to provide support. We have five (5) geographically separated Remedy servers that have menu tables which have &quot;drifted&quot; from the master dataset. We have to analyze the tables of menu choices for all five and then use the data to...

Hey gang, I'm using xmlhttp inside local web pages (vbscript inside an html page) to consolidate a lot of web searching. I grab &quot;data&quot; from three or four sites w/out any problem, and put all the &quot;data&quot; into a series of pages for easy coffeebreak reading. One site shows...

...as if the title weren't bad enough... Is there any way to use &quot;INCLUDE FILE&quot; in a .htm page running locally under IE? I use IE to gain the &quot;script=vbscript&quot; advantage to replace functionality that was lost when a server was blocked. (nutshell) I wrote some...