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 bkrike 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: *

  • Users: espltd
  • Content: Threads
  • Order by date
  1. espltd

    another export to excel question

    Hi, just wondering if anyone knows if there is a way to set fixed column lengths when exporting a report to excel? Also is there a way to remove specific fields when the report is exported in excel? I was thinking of passing a parameter to the report but not sure if this would help.
  2. espltd

    exporting file in drilldown view

    Hi I have a crystal report and when I export the report in PDF and save it, it saves the non drilldown view, not the drilldown view that was displayed in the browser. I am using crystal report 10 that comes with vs.net 2005. Any ideas, thanks.
  3. espltd

    Setting field if no data returned from dataset

    I have a crystal report and would like to place a string value in 2 columns if no data is returned by the dataset. So with a report that has 2 columns named Name and Total, if no data is returned instead of Name Total I would have Name Total none N/A Thanks.
  4. espltd

    problem with chart using crosstab layout for data

    Hi I have a column of data that is either 1,2,3,4 and have changed the name of the column in a crosstab where 1 = Data Entry, 2 = Missing Data, ect by adding the following; In the crosstab expert, selected the row field (that results in the numbers)->group options->options->customize group...
  5. espltd

    possible formula question

    I have a string field that typically only has three different values for an entire dataset. So for example row # location 1 Calif 2 Calif 3 Ariz 4 Calif 5 Nev 6 Calif I was just wondering if there is a way to only display the...
  6. espltd

    create hyperlink in dataset, display in report

    Hi I have a report that I would like to place a hyperlink in the data. For example one of the columns is a report number with some letters so it is a string type. If I convert it to a hyperlink in the dataset before sending it to the crystal report will it show up on the report as a clickable...
  7. espltd

    dynamically hide/show chart legend

    Hi, just wondering if there is a way to allow the user to select hide or show legends on a crystal report chart? I am using vs2005 crystal reports 10 that comes with it. One way would be to create 2 seperate reports, one with legends and one without and display the appropriate one based on the...
  8. espltd

    keep width of bars on chart narrow

    Hi just wondering if anyone knows how to keep the width of the bars displayed in the chart narrow. Currently when there is only one or two bars displayed on the chart they are quite wide. Thanks!
  9. espltd

    another chart display question

    Hi using the crystal reports that comes with vs2005. I am trying to create seperate charts for the following and was wondering how to set it up. The data has location and category names as two of its columns. I would like to set up seperate charts, one for each location and simply display the...
  10. espltd

    Y axis display integers only

    Hi I am using crystal reports that comes with VS 2005 and was wondering if there is a way to have the y axis display integer values on the y axis of a chart? For example a chart that might show the count of items and it seems to default the y axis increments to values less than 1 to provide...
  11. espltd

    change title in series box of chart

    Hi I have a simple chart with the legend definition being displayed on the right of the main chart display. The chart is working correctly but I would like to change what is displayed for each legend if possible. The legend currently is Count of Table.Autos, Count of Table.Trucks and I would...
  12. espltd

    Crystal reports print dialog-incorrect steps to print

    Hi, just wondering if there is a fix for this, but when the user selects the print icon on an opened crystal report the print options box opens and states, To Print; 1. In the next dialog that appears, select the "Open this file" option and click the OK button. 2. Click the printer icon on the...
  13. espltd

    underlay following selections seems to cover lines

    I have a page header with a water mark and in the section expert I have the underlay following sections selected. I noticed that I have lines in the report footer section along with data and the watermark image seems to block out the lines. The watermark image does appear to be behind all data...
  14. espltd

    watermark displayed over details section of report

    Hi I have a watermark setup that repeats a text label (draft) for each line in the details section of the report. This works ok but was wondering if there is any way to display a large water mark stating draft over several rows of the detailed section instead of the text label being repeated at...
  15. espltd

    watermark on a crystal report

    Hi, Just wondering if there is a way to place a watermark on a report, for example I would like to place DraftOnly in greyed out text, using crystal reports 10 that comes with vs.net 2005. Thanks.
  16. espltd

    document.close causing runtime error

    I have a crystal report document and when I run a long query I get the error, object not set to instance of an object. This occures on the document.close method so it looks like document does not get instanciated properly only with long queries. It works fine for short queries taking under a...
  17. espltd

    trying to get drilldown to work.

    I have a crystal report 10 with the detailed section set has hide, drill down ok and results being displayed in a group footer. I was hoping to be able to expand the details section at run time for each desired group but when I click on the group display the page does reload but only shows...
  18. espltd

    formula not available in crosstab

    Hi I have a couple of formulas and would like to place thier results in a crosstab but they do not appear to be available from the crosstab expert, using crystal 10. Thanks.
  19. espltd

    running total not resetting

    Hi I am using crystal 10 and can not get a running total to reset. I need it to reset back to 0 at the end of the group. It does look like it is incrementing correctly. I am using 3 seperate formulas, the reset formula placed in the group header Numbervar X:=0; In the details section I have...
  20. espltd

    add text column to crosstab

    Hi just wondering how to add a descriptive text column to a crosstab? From the crosstab expert you can add columns from database fields but I did not see how to just add a column to place a text object in (for example to display descriptive information about the data like a row title). Using...

Part and Inventory Search

Back
Top