Search results for query: *

Within an Excel 2003 application, I invoke a userform that is to display data collected from various worksheets in a browsable, "grid-like" fashion. But I can't use any controls that would have to be registered. Of the few valid controls remaining in the toolbox, Listbox is too limited for what...

I am distributing fields from a fixed-length input text file across cells in Excel via the TextToColumns method. Some values contain leading spaces that must be retained but appear to be dropped by the method. I don't want to put delimiters in the input file. Is there a way to retain leading...

I have a VB 6.0 application storing U.S. dollar fields on a SQL Server database into columns of the "money" datatype. This app will now be used in countries that use settings with the comma as a decimal separator, etc. I want to treat these money fields as U.S. dollars regardless of...

On a line chart in CR9, I have to plot individual values over various time periods that are not known until the chart runs. I get the data plotted but all points are spaced equally rather than to scale. In other words, the total time for the graph might 18 hours with one point plotted at 1 hour...

My problem is similar to one posted last year but the suggested solutions don't seem to work for me. In Chart Wizard I choose a line chart, uncheck "Automatically set chart options", choose advanced layout, and attempt through various combinations to plot individual values, using data...

I have requests for "wide" reports, for example 30 columns that require using two or more pages. I can simulate this by creating one or more subreports resembling the main format, and can even apply different page headers and page numbering through special code to make this combination...

I am converting an Access report to CR 9. The old report contains check boxes, which I don't see as a field choice in CR. Does Crystal support such things (check boxes, radio buttons, etc.)? I find nothing in the documentation. Thanks in advance.

The requirement is to add dynamically a watermark image to a report depending upon some condition. For example, a paid invoice (a data field is available to determine whether paid) would print with the word "Paid" tiled in the background; an unpaid invoice has no watermark. Can I do...