Search results for query: *

Hi- I'm in charge of a fat client VB application at my company. A couple of years ago, we came across an issue where when the user brought up the Crystal Report viewer in the application, a Microsoft error would pop-up, and the whole program would crash when the user selected "send report" or...

Hi, I'm trying to graph a report that shows hours along the x-axis (group axis) and a query-generated result along the y (data) axis. But, the group axis keeps showing two decimal places, and I don't know how to get rid of them. I rounded the numbers in my database, so they're no longer...

Hi, I'm using a VB 6.0 app to connect to/edit/create records in an Oracle HTMLDB database. The application works fine in Win2000 (my PC), but gives the following error on WinXP machines when the user brings up a record to edit: Run-time error '3265': Item cannot be found in the collection...

Hi, I'm trying to populate a flexgrid in my VB 6.0 application with values from a query of an Access table: sql = sql & "SELECT * " sql = sql & "FROM SongInfo " sql = sql & "WHERE " & Sec1 & Sec2 & Sec3 'Populate flexgrid Set db = OpenDatabase(Appl) Set qu =...

Hi, Anyone know how to get CR XI to get rid of decimal points if the quantity of what I'm showing in my bar graph is only 1 or 2, or even tell Crystal that the max scale is always at least 3? I know how to manipulate it in VB, but I don't have that luxury in this case. Thanks!

Hi, Anyone know how to get CR XI to get rid of decimal points if the quantity of what I'm showing in my bar graph is only 1 or 2, or even tell Crystal that the max scale is always at least 3? I know how to manipulate it in VB, but I don't have that luxury in this case. Thanks!

Hi, I've distributed a simple VB 6.0 report viewer to some of my colleagues here at work, and two of them get error messages when they try to open Crystal Reports that are pointing to an Oracle 9i database. The errors are, in order: First window: Prompting failed with the following error...

Hi, I'm trying to setup a report in a VB application that uses the RDC. (I'm using CR XI) There is a chart that has two characteristics (on change of): Failure Location and Cause Code. I need the "Recycle" Failure Location to always be tan, and the "In Service" Failure Location to always be...

Hi, I'm having difficulty merging pdf's that I export from CR XI. I'm using Adobe Acrobat 5.0. When I open one of the files I've exported, then try to insert another file (both have been exported from CR XI), I get the error message "these documents contain subset fonts that have the same name...

Hi, I have a viewer in VB that works really well, and even gives the user a message when there are no records for the parameters they've entered (I'm using Crystal to handling parameter input, not passing them through VB). What I'd like to do is show the parameters they selected in the message...

Hi, I'd like to know how to display a message (either using VB or code inside the CR) telling the user that no records matched their parameter criteria when the report is finished searching and displaying. I've used the printingstatus.numberofrecordread function, but it only works when there...

Hi, I have a VB app that imports an excel spreadsheet into a temporary table in Access (2002 SP3), then queries that table (created at runtime) against another existing table, does some edits, then deletes the temporary table. My problem is that the query (which creates a recordset with an sql...

Hi, I'm setting up a menu bar on one of the forms in my application, and I can't find anywhere in VB to change the font of the menu items. I've set the form font to Tahoma and it works for all new controls I bring into the form, but the Menu Bar captions are still in MS Sans Serif. Where can I...

I'm dealing with part numbers in my database that have two formats. For example: Format 1: 285W0024-1 285W0024-1B 285W0024-10B 285W0024-100 Format 2: 69-37350-1 69-37350-1B 69-37350-10B 69-37350-100 When I query my database, I'm using instr to compare these numbers to the part number the...

I'm using CR XI and RDC in VB6 (CRViewer). A couple of the reports my users are opening/viewing take about 6 seconds to load, and all I've been able to do so far to keep their attention span is put a message in the status bar at the bottom of the form saying "Retrieving data...". I found out...

Hi, I'm using CR XI and VB 6 to load a report into CRViewer. The user of my app has many reports to choose from, but two summary reports take a long time (5 or 6 seconds) to load. I'd really like to show SOMETHING during this time while it's loading, but I don't know how, and I feel like I've...

Hi, I'm trying to create a combination line/area chart in Crystal, and the area(s) only spread in the chart as far as the data label at the bottom. Is there any way to have the area(s) extend to both horizontal ends of the chart? Thanks in advance. Versions: Crystal Reports 11, Windows 2000

I'm trying to launch a second report in VB (viewer) when the user drills down on a group name in the viewer. I need to pass the group name to the next report, but I'm having great difficulty getting the syntax for retrieving the name. Here's the code I've been able to piece together: Dim...

Anyone know if combination line/column charts (like those supported in Excel) are available/possible in Crystal Reports? I can't find any in the listing, and was wondering if there are some online or available from Business Objects. Thanks.

Hi- I need to know how to calculate a 6 month rolling percentage in my Crystal Report and graph it. The two fields in the formula are deliveries and returns (called recycles). So, if my data looks like this (with the data starting in August): Aug: 6 Deliveries, 0 recycles -----> 1-(0/6) =...