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 Chriss Miller 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. rhinok

    Crystal Reports 2008 ready for release

    I don't interpret it that way, Ken, at least in regards to consulting. I think it prevents us from purchasing copies of Crystal Reports and then using that those copies to consult for clients, but it doesn't prevent us from doing work on a client's existing license. For example, I couldn't use...
  2. rhinok

    BusinessObjects Insight Americas 2007 (October 15 -18, 2007)

    I'm here - I'll try to meet you guys for lunch. ~Kurt http://www.acuityreporting.com
  3. rhinok

    Crystal Reports 2008 ready for release

    Also, reporting from Insight. I had a chance to participate in the beta. I personally consider this to be the best release of Crystal Reports ever. There is a broad spectrum of improvements/enhancements, many of which Ido listed. FYI - there will only be one edition of CR2008. No more...
  4. rhinok

    how to SQL expresion

    Generally speaking, you need to add parentheses around your SQL Expression, a la: ( SELECT DISTINCT portfolio FROM funds WHERE fund_group = '59' AND CSTM_FundChannel = 'Age-B' ) A SQL Expression field is essentially the same as a subquery in true SQL. You can choose to correlate the...
  5. rhinok

    Exporting to CSV results in the page header appearing with every recor

    Yes, it does. Since you'll have one header per field, you'll have the same number of fields in each part of the query. The downside is that you'll have to convert all of the data elements to string datatype (char, varchar, etc...) Ultimately, this is a kluge, but it will accomplish the goal...
  6. rhinok

    Advanced HTML via Infoview

    BusinessObjects XI has a Crystal Reports Explorer (an add-on to Professional, comes with Premium) that allows one to create/modify reports in a zero-client environment. ~Kurt http://www.acuityreporting.com
  7. rhinok

    Exporting to CSV results in the page header appearing with every recor

    It's not an issue with CR. .csv is not designed to have header information. .csv files are most often used as a way to import data into a database. As such, a header is not necessary, only the data is. With that knowledge, you could manipulate the data in such a way that the first line of...
  8. rhinok

    Crystal Server XI

    mjrbim knows what he's talking about. Also, Crystal Reports Server is limited to a single, quad processor server. I'd recommend that you review the following BusinessObjects XI Sizing document: http://support.businessobjects.com/communityCS/TechnicalPapers/boe_xi_sizing_recommendations.pdf...
  9. rhinok

    CRYSTAL SQL DESIGNER QUERY

    The version of SQL that is available within the SQL Designer depends on the database to which you connect and the method of connectivity (ODBC, Oracle native, etc...). I've created Queries in T-SQL and PL/SQL without incident. If you have any option at all, however, I'd avoid using Crystal...
  10. rhinok

    Select records From Where

    Here's a slighty different Age calculation formula: //Age in Years NumberVar DoBVar := IIF((100 * MONTH(CURRENTDATE) + DAY(CURRENTDATE)) < (100 * MONTH({person.birthdate}) + DAY({person.birthdate})), 1, 0); NumberVar YrsVar := DATEDIFF("yyyy",{person.birthdate},CURRENTDATE) - DobVar; Other...
  11. rhinok

    Business Objects Labs

    I've just returned from the Business Objects Insight Americas 2006 conference in San Francisco. During the conference, the new Business Objects Labs division was announced and demos were given of some of it's developments. The tools look very promising and are specific to BusinessObjects...
  12. rhinok

    ERR: crystal active X viewer is unable to create its resource object

    1) The Active-X plugin must be installed by a user that is part of the local Power Users or Administrators group. 2) Windows SP2 and other pop-up blockers can prevent you from being notified to install the Active-X viewer 3) Spyware/Adware/AV/Firewall software may have rules preventing you...
  13. rhinok

    CR 10 pipe delimited txt output

    Exporting Crystal Reports to various text formats can always be tricky. I created a sample report that exported to a pipe-delimited format in CR10. Here's what I did to make it export properly: 1) Eliminate all unnecessary headers and footers, including the page headers with the labels...
  14. rhinok

    How to Avoid blank report to be sent via CE scheduling

    bessebo, I too would be very interested in seeing your code! On a side note, I think you attended my session on SQL Expressions judging by the names on my feedback! I also saw Ido and MJRBIM there, as I have for the past few years! ~Kurt http://www.acuityreporting.com
  15. rhinok

    Is there speed differences between Views and Stored Procedures

    Another factor is that using a Stored Procedure (or a SQL Command Object, which is conceptually the same) will hinder you from efficiently using some Crystal Reports functionality. As an example: You have a report design requirement to have a single parameter that allows users to select one...
  16. rhinok

    CrystalReports.com

    I was privvy to a pre-release demo and was asked to provide a quote for press release. Here's some of the text from my email commments back to a BOBJ Marketing rep: As you can see from my comments, this product is really limited and is probably only applicable to very small clients. Based on...
  17. rhinok

    Business Objects User Conference in Orlando

    If I had gone for the sole purpose of attending breakout sessions with Crystal Reports content (I didn't), I would have been sorely disappointed. That being said, I did attend some sessions I found valuable. Please note,however, that for attendees like Ido, Brian, Bruce and myself, we are...
  18. rhinok

    Does the exam cover CR XI Server

    CR Server is basically Enteprise Professional with a different license structure. ~Kurt ~Kurt
  19. rhinok

    Report Parts Distribution

    Since you're emailing the report, you can't use Business Views, which would otherwise allow you to filter the instance at view-time based on the user groups. Your only option, as far as I know, is to parameterize the report based on Suppliers and then schedule the report multiple times, once...
  20. rhinok

    Business Objects User Conference in Orlando

    I'm planning on being there. Unfortunately, I was not accepted as a speaker (again), but I'm going anyway! So far I've met bdreed35, Ido Millet, chelseatech and Howard Hammerman (among other great people) at various conferences. It would be nice to see other TTers there, too! ~Kurt

Part and Inventory Search

Back
Top