Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PGFrank

    issue with exporting into Excel

    I have had the same problem and could never successfully use any of the Excel formats for export, even after following lbass' suggestions in the thread that you linked. The only thing that works for me is to export the report to a tab delimited file and then import it into Excel. A bit more...
  2. PGFrank

    Adding Acute Accent

    You do not need to use MS Word. Simply use the Character Map utility (usually found under Accessories in the Start Menu) to find the character in the appropriate font, copy it to the clipboard and then paste it into the application. If the character you want is in the ASCII or ANSI set, you can...
  3. PGFrank

    Running Crystal reports without crystal installed

    Sounds like you need to install a CR viewer on the users' machines. There is a list of them at Ken Hamady's site. Some are free and all are more reasonably priced than the full CR program. Some also have bulk licensing discounts. We have used Millet's DataLink Viewer for several years and...
  4. PGFrank

    Formatting problem with line chart

    I have tried to find a solution in both CR XI and CR 2008. Hopefully someone here can help. I have a report that produces line charts in the group footer. The data currently group into four groups and therefore four charts are produced. The charts show the data points as I expected. The...
  5. PGFrank

    Exporting to Excel with Supreport (want on one line)

    I had a similar problem and also had a column (a subreport) that sometimes evaluates to null. This is what works for me. In the main report I created a formula that contains a single space. My main report contains a field that allows me to determine whether or not the subreport will have data...
  6. PGFrank

    Scale picture in a report

    Which version of CR are you using? In my experience, in XI you cannot get the image to maintain its aspect ratio (i.e., proportions) and stay confined to the graphic box. For me, when I select "Can grow" the proportions are correct but the image often expands outside the graphic box. One...
  7. PGFrank

    Mysql connection

    You can download the appropriate ODBC drivers from the MySQL web site. After installation, open Control Panel, Administrative Tools, Data Sources (ODBC) and create a data source to your MySQL database using the MySQL ODBC driver. Test it to make sure that it works. Once this is done, in CR's...
  8. PGFrank

    supercript work around crystla reports

    You can also create a formula with your db field and the HTML code "<SMALL>*</SMALL>" appended to the end. Then, when the formula field is added to the report, right click, select Format Field, select the Paragraph tab and set Text interpretation to "HTML Text". This will work for the * since...
  9. PGFrank

    Ways of emulating v7 Distributed Reports

    Ido Millet's DataLink Viewer will do this and so will most of the other CR viewers that I have seen. The report has to be written to retrieve the required data from the database, perhaps in response to user input at a prompt. Once the report is on screen, the user can print it.
  10. PGFrank

    Need to add HTML-formatted field to report...

    dgillz, Sorry I did not reply earlier; I was away for awhile but I see several others have chimed in. Yes, the tags have to be enclosed in quotes and the field set for HTML interpretation. Your example still does not work for me in CR XI but changing "<strong>" and "</strong>" to "<b>" and...
  11. PGFrank

    Need to add HTML-formatted field to report...

    dgillz, Re <strong> vs <b>, my experience is exactly the opposite of yours - <strong> does nothing but <b> works. Peter
  12. PGFrank

    Aspect ratio of dynamically linked images

    Thanks MJRBIM. I guess I will have to wait for an update.
  13. PGFrank

    Aspect ratio of dynamically linked images

    Anyone know how to maintain the aspect ratio of dynamically linked images in CR XI? I have a database with fields that point to images stored on the server. The images may have different aspect ratios, from square to rectangular (both long and thin and tall and narrow). Creating the OLE...
  14. PGFrank

    Crystal XI - What Product to Order?

    You might try www.softchoice.ca Peter

Part and Inventory Search

Back
Top