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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Viewing reports on web with crystal activexviewer
What do you mean exactly by "could not display my report"? Was there an error message? Blank page? Page with gray box in it?- Tmorton
- Post #2
- Forum: Business Objects:Crystal Enterprise
-
Problems when I use UNION
Did you make any progress on this? Maybe you could try giving your fields an explicit alias using the AS keyword? Like: SELECT People.`Name` <b>as Name</b>, People.`Age` <b>as Age</b>, People.`Sex` <b>as Sex</b> FROM `People` People WHERE People.`Sex` = 'M' UNION SELECT...- Tmorton
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Suppresion
You could suppress the fields which are the same as those in the previous record. This is done by right-clicking on the field in the Design View, choose Format Field, click the x-2 box to the right of Suppress, and then enter a formula such as this: if previous({ado.order_numb}) =...- Tmorton
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
