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!
-
Report Selection - how to choose data
Hi guys, never mind I got it going! YAY I just put the duplicates in another group and then it filtered it out for me. Thanks so much!- HolleeC
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Report Selection - how to choose data
Thanks so much lbass - that worked! I had to modify it a little bit because I had to modify hastrue flag to if {table.exists} then 1. Now the assets with any true flags definitely don't show up. You are a genius! There's still a little to do though because there are duplicates (for all the...- HolleeC
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Report Selection - how to choose data
Hi Turkbear. Thanks so much. I don't think it works, because I haven't explained properly. I tried the equijoin and also the Not In statements, but the problem is that I have to evaluate whether or not there is a flag after I've returned the data. Here's a sample of the report: Asset...- HolleeC
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Report Selection - how to choose data
Hi guys. Sorry for the confusing explanation, but I'm a newb so here goes. I have a crazy report that has one main table, then it has links (some outer joins) to 6 other tables, so it's a beast. I have it working semi ok with just the outer joins and links, but now have a quandary with one...- HolleeC
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Help with how to return a multifield from sql query, & concatenate
Hi guys. Harley, that was my problem - and PScott, I didn't know my strings from my arrays! The records (in access) returned from this query could be one line or up to 3 or 4 lines. The only difference for each record is the STAND_ID number. So I did the EOF thing (or a Do Until EOF and... -
Help with how to return a multifield from sql query, & concatenate
I've been stuck on this for a while as a newb, so please forgive me in advance. Any help would be very appreciated. I wrote a little script to query a sql server database. Everything works except the fact that more than one recordset can be returned, and each record can have more than one...
