I have a stored procedure that is used in a Crystal Report. When I run the query I get "'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." 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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.