Search results for query: *

Thanks, Ian, but I am actually viewing the reports in the report designer on the SAME box that they are being served up on. None the less, it is certainly worthy of another look.

I am at a loss as to why this is happening, but I have a series of Crystal Reports (version 9) that are being used in an ASP application. In the Report Designer I have ensured that there is plenty of room between the righ-hand edge of the text box and the right-hand margin of the page...

Is it possible to run a series of UNION queries in a view as follows? When I build it in a new view, it run just fine, but I am unable to save it. I get a message that says "VIEW DEFINITION INCLUDES NO OUTPUT COLUMNS OR INCLUDES NO ITEMS IN THE FROM CLAUSE." SELECT dbo.tbl_Case.CaseID AS...

okay...I'll try it. THANKS

I'll try a SP next...and will let you guys know. Once again, thanks to you all for your help and support. You're the best! -Austin

apparently MS SQL doesn't like UNIONS in a VIEW for some reason. urgghhhhhh. Not sure where I go from here. Unless I do it in a stored procedure.

When I attempt to save the QUERY, I get a message that says UNABLE TO PARSE QUERY TEXT The SQL pane is out of sync with the other panes. The query cannot be represented graphically in the Diagram Pane and the Grid Grid Pane. Do you want to Continue? Click YES to edit the query in the SQL...

I pasted this into a view and it seems to work okay! Can I simply run a view from CR? And then set up a parameter in CR? Thanks to you all for your kind helpfulness.

Here's the error that I am getting when I attept to run it in the .NET application that it exists in: Server Error in '/' Application. Unknown Query Engine Error Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more...

Thank you so much for taking the time to help me out. I have been playing around with the same idea. However, in some cases, I may not have data in one of the tables, and that seems to be throwing an error, so I am not sure what to do in that event. SELECT dbo.tbl_Case.CaseID AS CaseID...

Thanks! Above each of these "case" tables there is another parent table (e.g. tbl_mediators, tbl_litigants, tbl_attorneys, etc where the pk=mediatorID or pk=attorneyID etc). The name address layout, unfortunately, is similar but not identical in all tables. That would have made too much sense.

I am using CR version 9 built over a SQL 2000 database and am having a difficult time trying to figure out how to best handle to following issue. I have Ethics and Professional Standards Cases that included people in five different tables (all related by CaseID). I need to create a single...

Thanks very much for your speedy response. This is a big help!

I'm not sure I'm in the correct forum, but hopefully someone will be able to offer some help here! I am attempting to move data from an old SQL2000 database to a new SQL2000 database. The new database has some additional tables, I've added a few fields to some of the tables that were present...

Thanks very much for taking the time to help me out with the problems in my formulas! I really appreciate your help! - Austin

I am using CR version 9 with SQL 2000 in a .NET application. Everything works fine except that the formula that I am using to list the articles that have been allegedly violated are being listed TWICE in the text (in the following REPORT FOOTER a). I am using the following two formulas in a...

I have developed a Stored Procedure in MS SQL2000 which combines (UNION) simple select statements from four different tables to produce one data set of names and addresses. Each of these tables are linked via a USERID and a CASEID. I have spent too many hours trying to figure out how to...

Great idea Turkbear! I will do that now and simply pull the data using the label wizard. I think even I might be able to manage that! I really appreciate your taking the time to respond and help me out! Have a good day! - Austin

Perhaps I don't completely understand how to use the Mailing Label Wizard in a way that will allow me to insert a SQL Query utilizing five separate tables. Let me attetmpt to further explain the steps that I am taking, and the error that is generated: I have set up the basic label (not using...

Thank you for taking the time to respond to my question, SYNAPSVAMPIRE! You are absolutely correct...I couldn't have been much more vague. Let me provide a little more background to explain what I am attempting to accomplish. I want to build mailing labels for specific people from five...