Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing blank reports from preview
Message
From
16/09/2005 09:22:14
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01050188
Message ID:
01050228
Views:
11
I think you're on to something here Sergey.
When the report comes up in Preview the correct alias (c_incal) appears but on the printout the wrong alias (workpriv) is there.
In the Data Environment Init, I have the code:
Select c_Incal
Go Top

Is there somewhere else I can put this code so that it will print the correct cursor?

This is a great help,
Thanks

>If you add a report field with expression 'ALIAS()' (w/o quotes) would it show correct alias?
>
>>Here you go Sergey,
>>
>
>>
>>RepoWin = Createobject("RepoForm")
>>RepoWin.Caption = "[Report] : " + Juststem(lcFileName)
>>	
>>lcOutPut = "PREVIEW"
>>If "PRINTER" $ lcOutPut
>>	Report Form GetFullReportPath(lcFileName) To Printer NOCONSOLE
>>Else
>>	RepoWin.WindowState = 2
>>	RepoWin.Name = "RepoWin"
>>	RepoWin.Visible	= .T.
>>	Report Form GetFullReportPath(lcFileName) &lcOutPut Window RepoWin
>>EndIf
>>		
>>Define Class RepoForm As Form
>>	BorderStyle = 3
>>	BackColor = Rgb(255,255,255)
>>	ControlBox = .F.
>>	MaxButton = .F.
>>	MinButton = .F.
>>	Closable = .T.
>>	ZoomBox = .T.
>>	ScrollBars = 2
>>	Left = 0
>>	Top = 0
>>	AutoCenter	=	.T.
>>	Visible	    =	.F.
>>Enddefine
>>
>
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform