Search results for query: *

Do a conditional supress on either pagenumber = 1 or recordnumber = 1 Both should work about the same. -- Marc Visconte CSC Lead RMS Developer Crystal Reports

...input that will change the grouping from the Trunk Identifier or Percent Utilization where % utilization is sum(circuit BW, Trunk ID) / trunk BW * 100 Paramter set grouping by different fields is easy, but I don't know how to achieve grouping by FIELD _or_ Top N (all). Because the % util...

Yes... and it's a reasonable and reasonably common request. First you need a parameter and you need to set default values for it. I.e. {?SortOrder} w/ default values of "Birthdate", "Hire Date", "Last Pay Date", etc. - using dates as an example. Next, make a formula that will test for the...

The only Remedy reporting tip I have is... "don't"? (just kidding) Actually, When we use the Remedy ODBC driver, we use the one that comes with the Remedy user tool. I personally don't like the Remedy driver, mainly because of the inability to do joins. The majority of my reports are written...

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

Oh, additional... 1) The links I saw on Google (PSFactory) seemed to deal with DLLs that weren't registered correctly (IIRC). I looked for a couple mentioned and tried re-registering them, but it did not change anything. 2) The laptop system I have (my "remote dev" system) has similar...

Guys, sorry take so long. It turns out that the ActiveX and Java Viewers DO work on this system. I overlooked that as I was working on the "report parts" which require DHTML viewing. On THIS system, neither DHTML or Advanced DHTML work, in either CMC or the ePortfolio. I get "Unable to...

No, we dropped support years ago. We got fed up after a while when their normal "support" consisted of "hm... I don't know. Have you tried re-loading your system? Try that and call me back..." Sigh. I guess I re-load. -- Marc Visconte CSC Lead RMS Developer Crystal Reports

Thanks for the response. I will try that on the code I was tinkering with, but the CInt doens't show up in the main code (orig ePortfolio), and it is still effected. This is not my couple-of-days... now the desktop workstation is throwing errors also: There was an error retrieving data from...

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

Actually, you CAN join tables, but the results are hella slow. The way to do it is to define more than one ODBC to the Remedy system. You can add/join tables from different data sources in Crystal, and let Crystal handle the data merge. Just be aware that. it. is. NOT. fast. Getting a good...

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

Found the reason for the horrible slowdown. One of the things passed down to the sub-report is information used to conditionally outline fields and highlight fields. These were passed as parameters to the subreport, but for some reason they showed up in the WHERE clause. I found out by...

...= "CLOSED" and {Tm_Action_Request.Action_Type} = "UNSCHEDULED OUTAGE" and ( ( ( {Tm_Reason_For_Outage.RFO_2} Like split("*" & join({?Keyword}, "*,*") & "*", ",") or {Tm_Reason_For_Outage.Service_4} Like split("*" & join({?Keyword}, "*,*") & "*", ",") or...

...net which takes the parameter list and converts it item by item into a wild-card-buffered list: List: "UPS", "A/C", "POWER", "HEAT" converts to "*UPS*", "*A/C*", "*POWER*", "*HEAT*" which allows us to do something like: AND ( field1 like @KeyArray OR field2 like @KeyArray OR field3...

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

Does licensing cost enter into the decision? We're at a similar juncture. We currently have lots of CALs -- which are fine for us. As they've dropped CALs, if we re-license we'll have to convert to named user or processor licensing. The new licensing may wind up costing us up to a cool mill...

I thought I had tried it w/ scalars variables set to arrays... my attempt didn't work, but I am more than willing to experiment again with it. I'm excited... can't wait to do the two-hour drive to the office to play. That's part of what's so much fun about this job... it's like free-time in...