|
-
Feb 24th, 2000, 12:56 AM
#1
Thread Starter
Lively Member
Hi, everybody!
I'm using the command:
MyCrystalReportsControl.PrintReport
to display my report to the user. The problem is that the report appears too small. How can I get it to appear using all the screen, since there isn't a command like
MyCrystalReportscontrol.Maximize ?
Another question:
I have connected my CrystalReports Control to a Data object. In the form load event, I set the Data Control Recordsource like this:
MyData.RecordSource = "SELECT Distinctrow last([TAG]), Last(Equipment.Description) AS LastDescription, Max(Calibration.RealDate) AS MaxRealDate, and so on,
and this line doesn't cause any error message, but my report isn't displaying the result of the aggregate function, it's displaying all the lines...
So, I have added the same SQL statment as the SQLQuery Property of my CrystalReport Control. Again, no error messages but again, all the lines in the report.
I can't access the option - Show SQL Query - in the Crystal report itself (after choosing Add-in , Report designer, opening my .rtf file and choosing the –Show SQL Query- option in the Database Menu), so I don't know why it's not displaying the result of my SQL statment.
Any ideas or suggestion?
Thanks very much in advance,
Roselene
P.s. Sorry I didn’t make myself clear this time. In case you think I should give more details, please ask. 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|