I might not have expressed my need correctly. I want to display data on a userform that essentially is a "pop-up" within this Excel 2003 application that appears when someone is drilling down for some detail data collected through VBA coding from about 80 other worksheets. I don't want it...
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 am able to display data from the database OK using the "GetCurrencyFormat" API, but storing data is a problem. The receiving parameter in the stored procedure is type "money", and no matter how I try to save a value like 1.23, it winds up 123 if I'm using a setting such as...
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 the exact same problem as the original post and cannot for the life of me get CR 9 to let me check the "Don't Summarize" box. "Automatically set chart options" is unchecked, layout is advanced, I'm using a formula field and have tried all sorts of combinations...
Works great! I layered all the fields from other reports on top of each other in one place on the detail line, made the font white and sent them all to the background. Thanks!
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.
Makes sense, I appreciate it. My real mission is to apply a larger watermark to the entire page, but it looks like I could use same process with a page header (underlaying the whole page) containing the watermark. Any way to tile a smaller graphic to fill an entire section? Thanks.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.