Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
 To: jAy_Em Sancho
  Where is jAy_Em Sancho?
 quezon
 Philippines
 jAy_Em Sancho
 Tags
Subject: RE: Create Report Programmatically
Thread ID: 221194 Message ID: 221207 # Views: 66 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Tuesday, March 17, 2009 9:55:25 AM         
   


> >
> >
> > CREATE REPORT FileName | ? FROM Source [FORM | COLUMN]
> >  [FIELDS FieldList] [ALIAS] [NOOVERWRITE] [WIDTH nColumns]
> > 

> > try this code
> >
> >
> > clea all
> > &&generate a report "on the fly" with any table (no memo fields,G)
> > &&First,configure dialog box print to portrait or landscape 
> > afile=getfile('dbf')
> > if empty(afile)
> > return
> > endi
> > 
> > Use (afile) SHARED AGAIN IN 0
> > SELECT * FROM (afile) INTO CURSOR mycurs 
> > Create Report c:\myreport From DBF("mycurs")
> > 
> > repo form c:\myReport preview      &&max 8 fields in portrait, max 11 columns in landscape view
> > use in 0
> > 

> >
> > Dont rate please.its only for the pleasure to help.Give me only a feed back.
> > Yousfi Benameur
>
> thanks! and i try and gladly this is really what i want to happen, but how can i add page header?
>
> thanks in advance.


that is called "quick report" and you cannot put too things . It works with the table/cursor directly. If you want some sophistical report you must use the designer.

Dont rate please.its only for the pleasure to help.Give me only a feed back.
Yousfi Benameur




COMPLETE THREAD

Tip: click here to scan for Windows Registry Errors and Optimize PC performance
Create Report Programmatically Posted by JAYEM SANCHO @ 3/17/2009 7:25:17 AM
RE: Create Report Programmatically Posted by tushar @ 3/17/2009 7:39:07 AM
RE: Create Report Programmatically Posted by Yousfi Benameur @ 3/17/2009 7:49:47 AM
RE: Create Report Programmatically Posted by JAYEM SANCHO @ 3/17/2009 7:55:29 AM
RE: Create Report Programmatically Posted by Yousfi Benameur @ 3/17/2009 9:55:25 AM
RE: Create Report Programmatically Posted by Srdjan Djordjevic @ 3/18/2009 4:18:01 PM
RE: Create Report Programmatically Posted by Pete Sass @ 3/20/2009 5:53:41 PM