alias.fieldname in report not working-Help? 
Author Message
 alias.fieldname in report not working-Help?

Situation:
Three tables in work areas loaded thus:
   sele 1
   use list
   sele 2
   use sumexp
   sele 3
   use title
Tables 2 & 3 (Sumexp & Title) indexed on common field
relations set with 2&3 as children of 1.
(The 'relating' works; with all three 'browsed' the records in 2&3 follow the
cursor in 1.)Building a report, the syntax in the expressions for report
fields list.ord_num (table.fieldname) doesn't work.  I get a blank report.  

The report was originally set up against a table created by a query but all of
 the fields have been changed to give the alias of the proper tables as
related.  

What am I missing??

TIA



Mon, 03 Nov 1997 03:00:00 GMT
 alias.fieldname in report not working-Help?

W>Situation:
W>Three tables in work areas loaded thus:
W>   sele 1
W>   use list
W>   sele 2
W>   use sumexp
W>   sele 3
W>   use title
W>Tables 2 & 3 (Sumexp & Title) indexed on common field
W>relations set with 2&3 as children of 1.
W>(The 'relating' works; with all three 'browsed' the records in 2&3
W>follow the  cursor in 1.)Building a report, the syntax in the
W>expressions for report  fields list.ord_num (table.fieldname) doesn't
W>work.  I get a blank report.  
W>The report was originally set up against a table created by a query
W>but all of  the fields have been changed to give the alias of the
W>proper tables as  related.  

W>What am I missing??

W>TIA

If the report was created with 'Save Enviroment' turned on it may be
loading the old enviroment.

Brian Copeland



Tue, 04 Nov 1997 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How to get a fieldname from an alias name

2. Table Name Aliases not working in XML Auto mode

3. SQL table alias suddenly not working

4. Set Alias Code Not Working - Any Ideas ?

5. 5.0 reports not working in 7.0 HELP!!!

6. REPORT PROBLEM: ALIAS NOT FOUND!!!

7. HELP: Site not working (or working erratically) after Hosting company upgrades server

8. Ingres 6.4 max(fieldname by fieldname)

9. After rs.open FILENAME, I cannot rs.fieldname.append FIELDNAME

10. HELP with MS Report Writer and report not pulling current data

11. HELP - VB3/ACCESS 2 conversion to VB4/ACCESS 7 not working - Not MIKE LUSK


 
Powered by phpBB® Forum Software