report in Cystal Report

User avatar
sal21
PlatinumLounger
Posts: 4364
Joined: 26 Apr 2010, 17:36

report in Cystal Report

Post by sal21 »

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

User avatar
HansV
Administrator
Posts: 78570
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: report in Cystal Report

Post by HansV »

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

User avatar
sal21
PlatinumLounger
Posts: 4364
Joined: 26 Apr 2010, 17:36

Re: report in Cystal Report

Post by sal21 »

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.
changed idea...
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.

User avatar
HansV
Administrator
Posts: 78570
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: report in Cystal Report

Post by HansV »

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.
gPrintListView.txt
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4364
Joined: 26 Apr 2010, 17:36

Re: report in Cystal Report

Post by sal21 »

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.
gPrintListView.txt
bro... the code work perfect.
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

User avatar
HansV
Administrator
Posts: 78570
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: report in Cystal Report

Post by HansV »

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