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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by LughS
-
chart format question
You may get mileage out of the option to put the labels on the "sides" of the chart. Chart Options > Data Labels > Labels on sides However, you may still get some overlap. You can sometimes move the labels a bit. However, you can't move them much. And, the exact amount by which you can move...- LughS
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Conditional summary?
Use a formula to alias, like so: SELECT {myfield} CASE 1: "Data Entry" CASE 2: "Missing Data" CASE 3: "Old Data" CASE 4: "Virtual Data" DEFAULT: "Good Data"; Or, since you are using simple numbers, you can use an array-based solution. ["Data Entry","Missing Data","Old Data","Virtual...- LughS
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Insert Count from Table Not in Details Section
Personally, I think you need to set Crystal aside, and go back to Access. I think you can solve this problem much more easily in the source database. First, what is the relationship between tblRequestedInformation and tblNewCustomers? One to many? Many to many? I.e., do you have records in...- LughS
- Post #13
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Dynamic Columns Question
Have you looked into using a crosstab? Everything you are saying there, especially the dynamic number of columns, sounds like that's what you want.- LughS
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
