Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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