473,399 Members | 2,159 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

export report to .txt-file

2
Hi,

I have a MS-access database.
There is a report that i export (via a macro) to a .txt-file, the problem is that in each textfile is a empty line on top, which i don't get rit of...
Does anyone know a solution?
(i saw some threads on ithe internet of people who have the same problem, only answers i found where about how to get rit of empty lines between the lines of text, i had this also originally, now i only have one empty line on top of every textfile, it looks like this):
-------------------------

zerzaertarze
sdfgsd
dsfgdsfg
-------------------------
While it should be looking like this:
-------------------------
zerzaertarze
sdfgsd
dsfgdsfg
-------------------------

I hope someone knows the reason and solution!
It's driving me mad...

Thanks already!
fvd
Feb 5 '06 #1
3 4536
Niheel
2,460 Expert Mod 2GB
I can't find any built in solutions your problem.

I think the easier thing to do would be to create an app that will delete the first line of your apps.

Before you do that, check your database and see if you have an empty field somewhere. It would be the first field. I don't see why access would throw in an empty line.
Feb 5 '06 #2
fvd
2
No, there is no empty field.
The report and table are fine, only when you export it as a .txt-file a blanc line is being added, when i expor the same report as a .rtf-file there is NO empty line, so the reason lies not in the table or report.
Only the export to .txt goed wrong.
I don't know why...

If you have any ideas i would be very happy.
Thanks!
fvd
Feb 5 '06 #3
There is a fix...
The extra blank line at the top drove me insane! I happened to run the export on a different machine, however, and the line dissapeared - it's the printer driver. Set the printer to a generic one in the report page setup and it will go away.
Dec 15 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name>...
7
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to...
1
by: Ganesh Bansal | last post by:
hi In C#, I am using CrystalRportViewer to show reports made using Crystal Report. Now, I need to export my reports to txt format while CrystalReportViewer allows only doc, pdf, rtf and some other...
1
by: John | last post by:
Hi. Sir: Does anyboday know how to export subreport data using the export button in crystal report tool bar? We have a main report including a on-demand report. When we click the on-demand...
0
by: David Valle | last post by:
Hi, i've follow an example that Gabriele G. Ponti wrote on 8/5/2003 about the export of a report made in Crystal Report in PDF format, this: ...
3
by: Brad | last post by:
In a Vista/IIS7 asp.net app, a coded crystal report export is crashing IIS7....but it works just fine in visual studio's cassini web server. And if I create a web form and use the crystal...
6
by: Liliputanac | last post by:
Hello. Is there a way to accomplish this from VB.NET 2005 ? thnx.
17
by: 1q2w3e4r5t6y7u8i | last post by:
Hi, I am printing an invoice through the following code: dim cr as new crystalreport1 cr.PrintToPrinter(1, False, 1, 1) the problem is that the complete paper cames out. I want to print...
3
by: Toby Gallier | last post by:
I am trying to figure out a way to update multiple records when a report is exported. Each record has a "Status" field. I have a query that selects all records with a status of "To Send" and that...
1
by: coolminded | last post by:
hello everybody, i have a viewer to view the report, but actually i wanted to export it in the txt format directly. i did: Report.ExportOptions.DestinationType = crEDTDiskFile ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.