Search results for query: *

CRXI Where can I find this jar? com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader Thank you

This is a java web application using: jdk 1.4.12 crystal reports xi r2 sun application server 8.2 Here's the problem: I would like to generate a dynamic XML document as the datasource. (This XML datasource is a result set from a query. I've completed and tested the XML file; it works.) Using...

My mistake, I'm using crystal reports XI. This is in a Crystalreportviewer.jsp on a sun app server. This is the line with the problem: exportOptions.setExportFormatType(ReportExportFormat.MSExcel); because if i change it to exportOptions.setExportFormatType(ReportExportFormat.MSWord); I...

The Export to Excel option returns this error:"Export format is not supported or not recognized" However, Microsoft Word and PDF work fine. Furthermore, I gathered the below source code from the Business objects "Tutorials Section", and it doesn't work. Also, when I click on the business...

Can crystal do a dynamic sql. For instance, i have a multi parameter as id. i want crystal to append this to the existing where clause. Exactly, with out " thanks "(id is null or id in(1,2,3)" where 1,2,3 are the id passed in. Thank you

I mean. If the end-user select 1,2,3,and 4 for a userRole and 24 for provider id, I want. {Command.ROLE_ID} = 1 {Command.ROLE_ID} = 2 {Command.ROLE_ID} = 4 and then {Command.ROLE_ID} = 3 and provider_id=24 All data should be returned. I can write it in Java; however, the client is using...

That fix doesn't work. The problem is if the end-user chooses 1 and 3 for a role_id and 24 for a provider_id. The sql will do this: if 3 in {?userRoleId} then ( {Command.ROLE_ID} = {?userRoleId} and {Command.PROVIDER_ID}={?providerId} ) This is correct for role_id 3. However, the problem...

BTW, {?userRoleId} and {?providerId} can have multiple values. Thanks

Sorry, {?userTypeId} was supposed to be {?userRoleId} //3. SQL not working the problem. else {Command.ROLE_ID} = {?userRoleId} or {Command.PROVIDER_ID}={?providerId} The problem is if the end-user chooses 1 and 3 for a role_id and 24 for a provider_id. The sql will do this: if 3 in...

I have three tables: User_role, users, provider. In the users table, column provider_id can be null. Obviously, these are subsets of the real tables. User_role role_id | description 1 | Admin 2 | SysAdmin 3 | Private 4 | General users user_id | role_id |...

Does anybody have information on books, websites, manuals, or other pertinent learning materials applicable to the “Crystal Reports XI”? Amazon has this book,” Crystal Reports XI: The Complete Reference (Complete Reference Series) (Paperback) by George Peck “ Has anybody used or would they...

How do you add a blank line in a formula? for example: fullName := fullName +"BLANK LINE"+ trim({Command.LASTNAME})+ ", " + trim({Command.FIRSTNAME});

Is it possible to have sortable columns? For instance: (where "Name","ID" are hyperlinks to sort and redisplaying) Report Name ID Paul 1 Al 2 Jim 3 click on Name, result is Name ID Al 2 Jim 3 Paul 1 Thanks

Thanks, it works. Now, I'm trying to alternate color. My color formula is: if remainder(RecordNumber, 2) > 0 then silver else white; Also, it is placed in the group footer section. However, it only prints white lines. Any suggestions?

Here is the Result Set. ---------------------------- ID_NUM | Name | Description | ---------------------------- 1 |Al |Reporter | 1 |Al |Developer | 1 |Al |DBA | ----------------------------- Desired result Report ID_NUM Name Description 1 Al...