Recent content by ausmoran

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