(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › EXPORTING VIA REPORT
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic EXPORTING VIA REPORT (Read 604 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
EXPORTING VIA REPORT
Jun 10th, 2011 at 3:31pm
Print Post Print Post  
Hello!
I use a Report to create a ascii - File with a  return as separater .
With a @NL() a get a <BR> as separater !

Thank you for the help.

hier is the output:

"=============================="<BR>"C"<BR>"DTENS"<BR>"2011/06/07"<BR>"2011/06/0
7"<BR>""<BR>"457717"<BR>"Schoolmann"<BR>"Tanja"<BR>"F"<BR>"1981/09/25"<BR>"BKK Pronova"<BR>"ENDBEFUND"<BR>"M"<BR>" "<BR>" "<BR>" "<BR>" "<BR>" "<BR>"WBC"<BR>""<BR>""<BR>""<BR>"8,306"<BR>""<BR>""<BR>""<BR>""<BR>""<BR>""<BR>"
"<BR>""<BR>""<BR>""<BR>""<BR>""<BR>""<BR>""


hier is my Code:

FileWriteLn(sFH,
@chr(34) + Berichtanfang   + @chr(34)            //1
+ @NL() + @chr(34) +  BerichtKennung +@chr(34)      //2      
+ @NL() + @chr(34) +  ENR +@chr(34)            //3
+ @NL() + @chr(34) +  Eingang   + @chr(34)         //4
+ @NL() + @chr(34) +  Ausgang   + @chr(34)      //5
+ @NL() + @chr(34) +  PraxisNr  +@chr(34)            //6
+ @NL() + @chr(34) +  LabNr     +@chr(34)            //7
+ @NL() + @chr(34) +  Nachname  +@chr(34)            //8
+ @NL() + @chr(34) +  Vorname   + @chr(34)      //9      
+ @NL() + @chr(34) +  Geschlecht      +@chr(34)      //10
+ @NL() + @chr(34) +  Geburtsdatum   + @chr(34)      //11
+ @NL() + @chr(34) +  Kostentraeger +@chr(34)      //12
+ @NL() + @chr(34) +  Befund +@chr(34)            //13
+ @NL() + @chr(34) +  Befundart +@chr(34)            //14
+ @NL() + @chr(34) +  " "       +@chr(34)            //15
+ @NL() + @chr(34) +  " "       +@chr(34)            //16
+ @NL() + @chr(34) +  " "       +@chr(34)            //17
+ @NL() + @chr(34) +  " "       +@chr(34)            //18
+ @NL() + @chr(34) +  " "       +@chr(34)            //19
+ @NL() + @chr(34) +  Kode  + @chr(34)                  //20
+ @NL() + @chr(34) +  Parameter + @chr(34)            //21
+ @NL() + @chr(34) +  Normalwert + @chr(34)            //22
+ @NL() + @chr(34) +  Bewertung      +@chr(34)            //23
+ @NL() + @chr(34) +  Ergebnis +@chr(34)                  //24
+ @NL() + @chr(34) +  ErgebnisText + @chr(34)            //25
+ @NL() + @chr(34) +  Einheit      + @chr(34)            //26
+ @NL() + @chr(34) +  TextAllgemein + @chr(34)            //27
+ @NL() + @chr(34) +  TextMethoden  +@chr(34)            //28
+ @NL() + @chr(34) +  Materialbezeichnung      +@chr(34)      //29
+ @NL() + @chr(34) +  MaterialSpezifikation    +@chr(34)      //30
+ @NL() + @chr(34) +  TestStatus               +@chr(34)      //31
+ @NL() + @chr(34) +  AbnahmeDatum      +@chr(34)            //32      
+ @NL() + @chr(34) +  AbnahmeZeit      +@chr(34)            //33
+ @NL() + @chr(34) +  ProbenmaterialIdent      +@chr(34)      //34
+ @NL() + @chr(34) +  ProbenmaterialIndex    +@chr(34)      //35
+ @NL() + @chr(34) +  GebuehrNr    + @chr(34)            //36
+ @NL() + @chr(34) +  Kosten    +@chr(34)                  //37
+ @NL() + @chr(34) +  BerichtEnde    +@chr(34)            //38
  )
« Last Edit: Jun 10th, 2011 at 7:37pm by Amor »  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: EXPORTING VIA REPORT
Reply #1 - Jun 10th, 2011 at 8:34pm
Print Post Print Post  
Hello Amor,

You will want to use @Chr(10) instead of @NL() for creating a return character in your export file when being created from a report.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: EXPORTING VIA REPORT
Reply #2 - Jun 10th, 2011 at 10:26pm
Print Post Print Post  
Thank you very much Ray.
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge