SQL command result won't display in report

[TomBoardman]

Using CR XI, I have a SQL command defined using the Database expert. The SQL command is simply,

Select Sum(Column1) As TotalA FROM Mytable WHERE Column2='A'

When I browse the SQL result within the Links tab, the result is correct. But when place TotalA into the page header section, the field is blank during print preview. I've confirmed that 'Suppress if 0' is off. Any suggestions for my problem?

 

[lbass]

Not sure what you mean here "When I browse the SQL result within the Links tab". Are you doing this within Crystal Reports? I recreated your command and it worked for me.

-LB