Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MVisconte
  • Content: Threads
  • Order by date
  1. MVisconte

    User-selected Group by _OR_ Top N?

    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...
  2. MVisconte

    Does ActiveX Patent Case effect BOCE?

    --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...
  3. MVisconte

    MS IE ActiveX Patent Case - BOCE?

    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...
  4. MVisconte

    "Cannot create object: PSReportFactory"

    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...
  5. MVisconte

    Tip: How do you get the most recent (period's) data?

    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...
  6. MVisconte

    "What's This" / Help as user Data Dictionary? How?

    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...
  7. MVisconte

    Cool solution: Test field for list of word embedded anywhere...

    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...
  8. MVisconte

    Breaking the WHERE - on purpose...

    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...
  9. MVisconte

    ? Set multiple report colors from CR Formula (const value)

    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...
  10. MVisconte

    SI 7.5 Sched Error w/ "blank" PESTARTPRINTJOB.

    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...
  11. MVisconte

    UN-accounting for amounts in groups...

    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...
  12. MVisconte

    Analyze _each_field_

    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...
  13. MVisconte

    Basic permissions change, sp_tables issue

    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...
  14. MVisconte

    New Reports w/ INSTANCES naming, not OBJECTS

    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...
  15. MVisconte

    "Not-used" data analysis - Approaches?

    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...
  16. MVisconte

    SP Union SP?

    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...
  17. MVisconte

    Multiple DBs/Multi-join... IN CRYSTAL?

    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...
  18. MVisconte

    Best way to compare Table Data?

    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...
  19. MVisconte

    xmlhttp: How to set referrer...

    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...
  20. MVisconte

    ? &quot;INCLUDE FILE&quot; from inside vbscript in *HTML* page?

    ...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...

Part and Inventory Search

Back
Top