Search results for query: *

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.

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...

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.

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.

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...

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.

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?

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...