How to export item from listview in a Crystal report?
Naturally the column name are the title of column in report.
In the head of report insert a MyVar string (is the farm name)
Tks.
I just have installed a new version of Crystal Report
report in Cystal Report
-
- Administrator
- Posts: 78570
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: report in Cystal Report
You'll have to store the data in a database, connect the Crystal Report control to the database, set its SQLQuery to a SQL string that retrieves data from the database, and set its ReportFileName to a file name.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
Re: report in Cystal Report
changed idea...HansV wrote:You'll have to store the data in a database, connect the Crystal Report control to the database, set its SQLQuery to a SQL string that retrieves data from the database, and set its ReportFileName to a file name.
in effect i need a simple print report.
Thge code above print directlly on defualt print.
but insert header and column name only on first page i need on all pages of report...
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78570
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: report in Cystal Report
As you know, I don't have VB6, so I don't know if this will work.
The attached text file contains only gPrintListView, not the rest of the code.
The attached text file contains only gPrintListView, not the rest of the code.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4364
- Joined: 26 Apr 2010, 17:36
Re: report in Cystal Report
bro... the code work perfect.HansV wrote:As you know, I don't have VB6, so I don't know if this will work.
The attached text file contains only gPrintListView, not the rest of the code.
but in the second page, i cannot undesrtand why the title of column are covered from value of the first row in listview, or the other way around.
Peraphs the count of lines.... when strt the first row in listview
-
- Administrator
- Posts: 78570
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: report in Cystal Report
You'll have to change the lngY value, but unfortunately I cannot help you with that since I can't test the code. Sorry!
Best wishes,
Hans
Hans