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

  • Users: 2J
  • Order by date
  1. 2J

    Pie Chart Values on Slices and Outside Slices

    Is it possible to show Pie Chart Values in the slices and the percentages outside the slices? I am able to do one or the other but can't seem to be able to do both. Thanks 2J
  2. 2J

    How to get Fixed Number of Groups in Bar Chart

    I have created a bar chart that displays stacked bars based on a formula. However sometimes there is no data for some of the groups. I would still like to see the space where the group should be left blank so that the bars are always in the same spots no matter whether there is 1 or 4. At the...
  3. 2J

    TCP synchronous messages

    I need some help writing a Perl Script.<br><br>#print
  4. 2J

    Linking Subreports Containing Stored Procedures

    How have you linked the sub-report to the main report?<br> <br> <br> In order for the sub-report data to be based on the main report the parameters for linking must be data that is in both reports. For example if you want the subreport to display information for every Customer, link the...
  5. 2J

    Stored Procedure Return Values

    Does anyone know how to capture the return value of a stored procedure in a Crystal Report?<br> <br> I want to return a certain value if there are no records available and then report an error message to the user.<br> <br> Thanks<br> 2J
  6. 2J

    ROUND Function

    I found the solution to the problem on another forum.<br> <br> <br> Using the decimal datatype instead of float fixes the problem because float only aproximates values. For complex mathematical calculations decimal, money and numeric datatypes are mre appropriate
  7. 2J

    ROUND Function

    Does anyone know how SQL Server chooses to round when the last digit after the decimal point is 5. I've used this function in a stored procedure and two records with the same value (0.265) get returned differently, 0.26 and 0.27. At this point my only solution is to do the rounding in Crystal...
  8. 2J

    SQL Expression Builder

    Is anyone familiar with the expression builder in Crystal Reports Designer? Can I use this to create regular SQL statements of the form SELECT FROM WHERE ORDER BY<br> <br> If you have used this feature before could you please provide and example showing exactly how to use this with the exact...

Part and Inventory Search

Back
Top