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

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

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

Turk - with just the first portion, we still will bring back anywhere from a couple thousand records (1 month) to tens of thousands (12 month). The first case might result in 53 records that we actually need to see. I don't know if suppression is a good way -- maybe as a last resort. Vidru -...

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

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