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!

  • Congratulations SkipVought 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: *

  1. SApple

    CE 8.5 Verifying Databases on Scheduled Reports?

    We are just starting to launch our customized CE application, which currently hosts 250+ scheduled reports. These reports use a SQL 2000 DB as their datasource. That datasource is updated every month with a new release (new data items, new columns, etc.). Does anyone know if CE 8.5 has a...
  2. SApple

    Suppressing selected dimensions

    We are in the process of converting all our end-users from individual MS Access tables and Impromptu files. They are accustomed to being able to select from a lot of data. We are in the development phase, with just a handful of pilot users. Once we start getting some feedback from the end-users...
  3. SApple

    Suppressing selected dimensions

    Anybody have any wisdom as to when CAP 9.0 is due out? It seems to have alot of features I'm waiting for (it also has a rudimentary querying tool as well which our endusers would love)... and thanks for the help!
  4. SApple

    Suppressing selected dimensions

    Thanks, Rich. I had seen it working, but now you mention it, I bet it was a CAP 9.0 demo. We're using a MS Analysis Services-created cube off a SQL data warehouse. I was trying not to hide some dimensions during cube creation, because I'd like to use a cube for more than one business unit, and...
  5. SApple

    Suppressing selected dimensions

    Hey gurus -- I have a cube that has about 20 dimensions. I want to design a report that allows the end-user to only see 10 of those dimensions. I can't (of course) fit them all on the worksheet, so I want them to be at the bottom of the worksheet in the Slice Dimension Panel so that the users...
  6. SApple

    Week Number in Year

    Thanks! I want the calendar week number...
  7. SApple

    Week Number in Year

    I'm needing to write a formula that will take a given date of a data record and return what week number in the year it falls in. For example: 12/31/01 would be week #53. Thanks for your help.
  8. SApple

    Cizer

    We checked into Cizer as a cost-effective alternative to Crystal Enterprise, and found that Cizer right now is compatible only with Crystal Reports 7.0. They stated that when they upgrade to support CR 8.0/8.5, their pricing structure will be in line with what Crystal is asking...so no cost...
  9. SApple

    Anyone Know Cizer?

    Anyone out there know anything about Cizer and their "streaming analytics" software that supposedly is a comparable product to Seagate Info/Enterprise? And the licensing fees are dramatically lower? Looks intriguing, but wonder if anyone knows if they live up to their promises...thanks!
  10. SApple

    Has anyone used CR 8.5 and exported to XLS, PDF, RTF???

    I was told by Crystal folks that the export to Excel will never be clean, unless the fields in the Crystal report are exactly lined up and aligned the way the Excel report should look. If you have a field as a group header that is extended over other detail fields below it (for example), Excel...
  11. SApple

    Compatibility b/t CR8.5 and Info7.5?

    We currently are using CR 7.0 and alpha-testing Info 7.0. We know we need to upgrade to CR 8.5, and wonder if anyone has encountered any compatibility issues with Info 7.5, which we will also need to upgrade to? Thanks!
  12. SApple

    Export reports to HTML? You may owe $10K per year.

    I was with some Crystal Decisions folks yesterday in a user group meeting and the question of licensing came up in regards to Crystal Enterprise (the successor to Info). You can either get named licenses (for $595 each), concurrent licenses, or a combo of both. Using as an example 25 concurrent...
  13. SApple

    Moving last names to beginning of field

    Ken, (1) which formula would you modify and how; and (2) now I'm told there are other names with first initial/full middle name/last name. <sigh> Thinking I should have left well-enough alone... I'm just not sure how to accommodate all the various permutations of folks' names...?
  14. SApple

    Moving last names to beginning of field

    Thanks as always, Ken. You are good. I took out the wildcard (of course now I realize I didn't need it!) and the names are coming in terrific. Now if I want to keep middle initials in on other reports (for names distinguished only by middle initials) do you have a suggestion as to how best to...
  15. SApple

    Moving last names to beginning of field

    I know this question must come up often, but I can't seem to locate the answer. I'm working in CRD v.7.0, and bringing in a field that has first name/middle initial/last name and want to format it last name first. I get this done by the following formula (called @UpperOriginator)...
  16. SApple

    Dictionary Compatibility with CR 8.0?

    Thanks, everyone...I just might proceed with the Dictionaries solution to this problem. I appreciate everyone's input! Sarah Applegate
  17. SApple

    Dictionary Compatibility with CR 8.0?

    We are currently using CR 7.0 and are considering setting up Crystal Dictionaries for sets of reports. When we upgrade to CR 8.0 in a few months, does anyone know how the Dictionaries will convert/translate? We are also considering getting into Info 7.5 at some point and wonder if that will have...
  18. SApple

    Global Search and Replace of Formulas and Criteria

    Thanks for your advice. We're using Crystal 7.0 and it does not have the automatic field remapping feature. Appreciate your time!
  19. SApple

    Global Search and Replace of Formulas and Criteria

    We are just finishing remapping our SQL database, complete with new table names, new field names, data mapped differently all over the place. Is there a faster way to globally replace all the field names in our formulas and select criteria rather than eyeballing each one? We can't set location...
  20. SApple

    Repointing CR7 from FoxPro .dbf to SQL database

    We are trying to do two things with some old reports: (1) upgrade from CR6 to CR7, and (2) since the database has been upgraded from FoxPro to SQL, repoint the reports to the new SQL database. We brought the CR6 report into CR7 just fine, but after we go through Convert Database Driver, Set...

Part and Inventory Search

Back
Top