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!
-
Congratulations gkittelson 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: jejohn1216
- Order by date
-
How to mimic 'NOT EXISTS' in Crystal Reports 9
OK, forgive my dense-ness here. If I open the CR I created and go to Database -> Set Datasource Location ...... is that where I use the SQL as a new data source? My current connection is ADO to the database. What type would the SQL statement be? When I click on Create New Connection, I don't...- jejohn1216
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
How to mimic 'NOT EXISTS' in Crystal Reports 9
I have a sql statement that selects the proper data by using a NOT EXISTS sub select. Runs fine and is accurate using Query Analyzer in SQL Server. I have tried to build a report in CR that mimics this select, but cannot get it to match. I tried using "not ({TableA.FieldF} in [109, 92])" but get...- jejohn1216
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Page Break logic so Group Totals are on same page as detail
Told you I was a neophyte! That worked great. Thanks, lbass.- jejohn1216
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Page Break logic so Group Totals are on same page as detail
I'm a CR neophyte, so excuse this question. I have a Crystal report that lists detail lines, then totals by group. Everything works fine, but I want the report to not split the detail and it's group totals if it won't all fit on the page. I don't want a page break after every group total...- jejohn1216
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
