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!

Register Log in
  • Congratulations Chriss Miller 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: kacie
  • Order by date
  1. kacie

    More than 1 value returned

    I ran just that section of the SP. I included the cmpid on each row. There are only 21 rows with no dups. There are also no dups in the tbl_company table. Can I do an Update with an aggregate total with a group by the way I have it? This is the only thing I can think of.
  2. kacie

    More than 1 value returned

    I have a stored procedure that is used in a Crystal Report. When I run the query I get &quot;'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.&quot; The code is: UPDATE #tbl_company SET...
  3. kacie

    I have to parse names into three se

    I have to parse names into three seperate fields: Lst Name, Fst Name, Middle. The company is sending me the name in one field ie : Smith, James E. or Smith, James Using MS Access Update queries how can I parse the name out into the three fields? Thanks.
  4. kacie

    Exporting PDF not available on users PC

    I am using the Crystal distribtuion wizard. According to their K Base it is for v8.5. We have been using since v6.5 until now I have not had any problems. You are correct the v8.0 the pdf was not available but hopefully there is work around.
  5. kacie

    Exporting PDF not available on users PC

    I am under the gun need some help. We allow the user to run reports by using the Report Distribution Wizard. On my PC I have the CR Developer 8.5. I did apply the wizard on my destop, ran a report and was able to export the report as Adobe PDF. When I went to the user desktop to run the...
  6. kacie

    Export Drop Down Option Box

    Is ther any way to eliminate the mail option in the drop down box? I do not want my uses sending the reports via mail but I would like them to have the ability to export to Excel. Thanks.
  7. kacie

    Setting Export File Drive Destination Default

    I am exporting to Excel 8.0 (extended). When you get to the Choose Export Box it always points to the temp folder on C:\. I would like this to automatically point to the users H:\ (home drive) on the Network. Is there any way to set the default?
  8. kacie

    Stored Procedures, Parameters &amp; Subreports

    I have a main report linked to SQL Stored Procedure with 5 parameters. In the main report I have a subreport linked to a different SQL Stored Procedure with the same 5 parameters. The need for the subreport is so I can get unduplicated counts. Is there any to pass the parameters from the...

Part and Inventory Search

Back
Top