Search results for query: *

Exactly what I needed. Thank you LB!

Hello, I am using Crystal Reports 2013. I have a SQL table with about 50K records that looks like this. I want to identify the accounts that have an Inventory_Flag of 'Y' AND 'N'. In other words, using the sample data above, the only Account I want to identify is 78989. Thanks for any...

LB, Works like a champ. Thank you! TP

There are 30 departments. The report always contains the same departments. TimothyP

Hello, I am using Crystal Reports 2013. I have a SQL table that looks like this with thousands of records. My report groups by and does a page break on Dept. There are many pages per Dept. The current report (mainframe COBOL) I am converting, has an index page at the end that shows each...

Nevermind lbass, I found the 'Add Command' option. Let me see what I can figure out and I'll post back my results.

Thanks again lbass for your efforts. I'll give it a try. But how do I go about using a command as a datasource against SQL tables?

I keep getting the following database warning in Crystal XI because of the multiple data sources. I don't think this is a problem? Database Warning: "More than one datasource or stored procedure has been used in this report. Please make sure that no SQL Expression is added and no server-side...

Yes, for each table the links are between the contract numbers. I just double-checked. Also, each contract number in the primary Table A can be in one, many, or no records in Tables B and C.

Maybe it's not the join after all. I am linking FROM table A TO table B, and FROM table A TO Table C, with a left outer in both cases, and no selection criteria at all. I create a report to display TableA.contract# and TableB.contract#. This displays a contract number value in both...

It definately has something to do with the join(s). As you suggested, I removed all selection criteria and picked a contract number that is showing on this report that should not be. At first, I only (outer)joined Table A to Table B and displayed TableA.contract# and TableB.contract#...

I DO NOT have "convert nulls to default values" checked. Some additional information... It is possible that the same contract number can be in BOTH Tables B and C. It appears my report is selecting the contract numbers that reside in ONLY Table B or Table C, but not in both. The report is...

Hi lbass - thank you for your time. My entire record selection formula is Isnull({TableB.contract_num}) and Isnull({TableC.contract_num}) Based on dgillz's response, I thought conditional suppression was my only alternative that would not undo my left join(s). In response to your first...

Thank you for your replies. However, I am still experiencing the same issue. How can I use a conditional suppression without undoing the left outer join?

I am using Crystal Reports XI against SQL server tables. I have 3 SQL tables. Table A – stores all contract numbers Table B – uses the data element contract number Table C - uses the data element contract number I want to identify all contract numbers in Table A that are not found in either...

That's it! Thank you

I am using Crystal XI against SQL server tables. This seems like a simple solution, but I wasn't able to find it in any of my tek-tips searches. What is the general soulution to keep Group Header and Detail records together? In other words, I don't want to end a page with a GH and I dont want...

Can Microsoft Source Safe be used effectively for Crystal XI reports?

I'm using VB.net in Visual Studio 2003 against SQL 2000 tables. I am trying to learn and apply a professional looking navigational structure for my web application. It was suggested to me to use Panels within a 2 column, 1 row table. The left table column would include my menu panel and my...

Perfect, thank you!