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 dencom 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: richl13
  • Content: Threads
  • Order by date
  1. richl13

    Get difference between 2 groupings

    I have a report with 2 groupings. Each group has 7 rows and totals. For example I have 1 group with: A, 1000, 1000 B, 2000, 1000 C, 1000, 1000 D, 2000, 2000 Totals, 6000, 5000 Another group with: A, 2000, 3000 B, 3000, 3000 C, 2000, 2000 D, 1000, 2000 Totals, 8000, 10000 What I would then...
  2. richl13

    Resize markers on chart

    I am using Crystal 2008. I've created a bar chart and changed on of the series to a line. Is it possible to remove the markers or change the size of them?
  3. richl13

    passing count to variable in dynamic sql

    I am trying to create a stored proc with a dynamic sql statement. What I am trying to accomplish is passing the count(*) to a integer variable. Below is my sql. The @iPul is returning NULL. How should I change this so I can get the value in @iPul? SET @SQLFromWhere = ' FROM P LEFT Join S...
  4. richl13

    Create TIF

    I am using VB6 and have Lead Tools Raster Imaging 13 . I have never used lead tools and would like to create a tif file from VB. The tif page is an audit form that will have a table layout at the top with data pulled from our database and the rest of the page will have checkboxes. I will...
  5. richl13

    Pass parameter to Crsytal report

    I have an app that opens a crystal report, sets the login info, passes the parameter, then exports the report. Below is part of the code I am using. I need to run this report multiple times with new parameter values. How can this be accomplished without doing OpenReport everytime? Dim Report...
  6. richl13

    Using VB6 to open Crystal report and export it to pdf

    I wrote a script to query up about 50 ids. Loop thru them and open up the crystal report and pass the ids then export it to pdf format. I have 2 questions. 1. Instead of doing the below statements each time is it possible to do a refresh? Set Report = crxApplication.OpenReport("test.rpt"...

Part and Inventory Search

Back
Top