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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View Ok Crystal empty

Status
Not open for further replies.

WTKnow

Programmer
Aug 3, 2006
29
US
Report based on SQL view.
View executed brings 100 records.
Report comes up blank.
Going to Database - Show SQL View - copy.pasting into Query Analyzer - brings 100 records.
It almost seems like my Report has box 'do not show data' checked somewhere... {please, advise}.

Thanks
 
Check the Report->Selection Formula->Reocrd, and for any suppression within details section of the report.

Also see how many rows the indicator shows for the record count when you hit the refresh button.

-k
 
Thanks but no, everything in there is ok. Anywhere else?
I am turning it inside out but no luck!
 
It is fixed..too embarrassed to tell. Unless you insist...
 
Nope, would never insist, must have been a temporary Crystal bug, I've had many...

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top