Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Creating Crystal Report Using VB6


how am i supposed to create a crystal report using VB6??

Which component in VB6 should be added in order to create this report??

Is there anyweb site to teach/guide user on how to create crystal report??




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Creating Complex Report In Crystal Report
i need an information and tutorial about following issues in Crystal Report:
1. how can i display two different database tables in 1 single report? for example :
     i have 2 tables, let's say tsales and tpurchase. and i want to display those tables like :
     Invoice Num Date Amount
     A1234 10/02/2006 1000 -> from tsales
     A2345 10/02/2006 2000 -> from tsales
     A3456 10/02/2006 3000 -> from tsales

     B2345 11/02/2006 2500 -> from tpurchase
     B2345 11/02/2006 500 -> from tpurchase

     Total 3000 -> total sales - total purchase
2. can i limit the information displayed from a tables? for example :
    i have datas like these :
     Invoice Num Date Amount
     A1234 10/02/2006 1000
     A1234 10/02/2006 1500
     A1234 10/02/2006 2000
     A2345 10/02/2006 2000
     A3456 10/02/2006 3000
     i want to display only one record for each Invoice Number, so it would be like :
     A1234 10/02/2006 1000
     A2345 10/02/2006 2000
     A3456 10/02/2006 3000
3. when i designing a report using crystal report, it seems that it has something bothering about the report's printing layout
    let's say when i design the report in my computer, the preview was excellent but after i printed it, there's slight differences
    between the preview and the print result. some column's width seems to be decreasing itself....and it get worse when i try
    to print it with a different printer. even the preview is changing when i change the printer....
    is there some way to create a report layout that is not affected with printer changing?
i really appreciate any help.....
thanks a lot


regards,

evan

Creating Report With Crystal Report 11(Crxi) In VB6
Hi There,

I used to work with Cr 8.5 with Vb6 for creating reports, I could add CR ActiveX designer run time... through performances & CR design through components, But now After installing CRXI I dont find none them to can Creat a report, I mean I cant find "Cr ActiveX designer Run time library 11.0" then the component for its design!!!!!


Can you please guide me to solve this problem?


 

Creating A Crystal Report In VBA??
I already have the report made up, I already added the crviewer control and some cr references. What else do I need?? I pasted the CRViewer control on the form, does anyone have any code that I could use to display a crystal report file?

Help In VB Creating Crystal Report
Can anyone explain what these declarations are for? Why must i declare these variable so that it will work.

Dim creParaFldDefs As CRPEAuto.ParameterFieldDefinitions
Dim crePara As CRPEAuto.ParameterFieldDefinition
Dim rptDB As CRPEAuto.Database
Dim rptTbls As CRPEAuto.DatabaseTables
Dim rptTbl As CRPEAuto.DatabaseTable
Dim creApp As CRPEAuto.Application
Dim CreRpt As CRPEAuto.Report

thanks!!!

Creating A Crystal Report
Hello,
  I need help in a big way. I need to create several reports for this program I am writing. I need to pass a query to Crystal Reports 8.5 but I can't figure it out at all. The problem that I am facing is passing a field into the query from Visual Basic 6.0.
I know I can creat the query inside Access and I am doing that for the reports that require all the information. How can I pass the required field for the query to access to create the report. For example say I have a query to print one purchase account. I need to to pass to the query itself the account number. How do I do this. Also I need to link to another table in Access.
Here is my query itself

SELECT Purchasing.* FROM Purchasing
WHERE (Purchasing.Purchasing_ID = temp);
temp= equals the field I need to pass in from visual basic 6.0


Any help will be greatly aprreciated.

Creating Crystal Report And Accessing In Vb
i have sql database i wanted create a report in crystal report 7 how should i access the sql tables in report i dont want use odbc datasource if i use odbc i ll have to always create some odbc connection at client site what is the other way for this so that when i call this report from vb 6 it should not say cannot open sql server

Creating && Desining Crystal Report Using VB 6.0
Hai,

Please help me to find the way of creating & desining Crystal report in runtime using VB 6.0. Also I am unable to filter the record using 2 table for SQL server.

Please help me to find solution

Thank you!!!

Help Needed For Creating Crystal Report From VB
Dim rptDB As CRPEAuto.Database
Dim rptTbls As CRPEAuto.DatabaseTables
Dim rptTbl As CRPEAuto.DatabaseTable
This are needed when a Crystal Report has subreports that may access different tables.

How to go about doing it if i need to access different tables without a sub report and with s subreport???

Thanks!!!

Creating A Crystal Report During Runtime
Hello All,

I am trying to create a crystal report control and name it druing the runtime of my program.

The reason I need to be able to add and remove it is beacuse my program gets an error during other procedures relating to the Crystal Report control I have.

What I want be able to do is add the control on a Click Event and then remove it once the report has been printed or closed.

I have searched the forums and have tried using the follwing syntax:

Option Explicit

Private WithEvents newText As CrystalReport

Private Sub Command1_Click()

Set newReport = Controls.Add("VB.CrystalReport", "newReport")

End Sub

I get an error that says " Runtime Error '711' "
"Invalid Class String"
"Looking for object with ProgID: VB.CrystalReport"

Thanks for your help in advance.

Crystal Report Creating Issue
hello Someone out there. If someone could please help me out, I'm in need of some desperate help.

Here's the deal.

I created the report. I've also selected a database.

-When I go to print it, the first page looks good, but every following pages after, the details section doubles, as in, there are two detail sections.

-Everything is pushed up on every page after the first.

-What should I do or am I explaining this correctly?

Please help, I am a semi begginner.

Thank you.

Creating A Report In Crystal Report
Can anybody help me to solvee the following problem.

The problem is I have a table named attendance. and the fields are

Emp_Code, Card, Name, date, arrival_Time,Depart_Time, Late_hours.

there are 100 employee in that organisation. and the data stored like

Emp_Code, Card, Name, date, arrival_Time,Depart_Time, Late_hours.
E001 0001 aaaaa 01/01/02 10:30 5:30 1:00
E002 0002 bbbbb 01/01/02 10:30 5:30 1:00
E003 0003 CCCCC 01/01/02 10:30 5:30 1:00
E004 0004 DDDDD 01/01/02 10:30 5:30 1:00

'
'
'
E001 0001 aaaaa 02/01/02 9:30 5:30 0:00
E002 0002 bbbbb 02/01/02 9:30 5:30 0:00
E003 0003 CCCCC 02/01/02 9:30 5:30 0:00
E004 0004 DDDDD 02/01/02 9:30 5:30 0:00
'
'
'
E001 0001 aaaaa 03/01/02 9:30 5:30 0:00
E002 0002 bbbbb 03/01/02 11:30 5:30 2:00
E003 0003 CCCCC 03/01/02 9:30 5:30 0:00
E004 0004 DDDDD 03/01/02 12:30 5:30 3:00



and I want the report like

Late Arival Report

Emp_Code Card Name 01/01/02 02/01/02 03/01/02
----------------------------------------------------------------
E001 0001 aaaaa 1:000:00 0:00
E002 0002 bbbbb 1:000:00 2:00
E003 0003 CCCCC 1:000:00 0:00
E004 0004 DDDDD 1:000:00 3:00

:

Creating Report On Crystal Report Using SQL
how to accesing/creating SQL server temporary table from crystal report ?

Need Help In Creating Report Using Crystal Report - VB6
Using VB6 and Crystal Report v10

Can someone teach me how to generate report in Crystal report using VB.

I just want to generate reports according to my MSflexgrid from my form. ( Just want to display whatever comes out of my grid ) tnx in advance

Creating Reports Dynamically Using VB6 And Crystal Report 8
I am trying to creating repoerts using VB6 and crystal 8 . The code is as follows -
Dim crystal As CRAXDRT.Application 'LOADS REPORT FROM FILE
Dim report As CRAXDRT.report 'HOLDS REPORT

CRViewer.DisplayBorder = False 'MAKES REPORT FILL ENTIRE FORM
CRViewer.DisplayTabs = False 'THIS REPORT DOES NOT DRILL DOWN, NOT NEEDED
CRViewer.EnableDrillDown = False 'REPORT DOES NOT SUPPORT DRILL-DOWN
CRViewer.EnableRefreshButton = False 'ADO RECORDSET WILL NOT CHANGE, NOT NEEDED
Set crystal = New CRAXDRT.Application 'MANAGES REPORTS

Set report = crystal.OpenReport(App.Path & "
eport1.rpt") 'OPEN OUR REPORT

report.DiscardSavedData 'CLEARS REPORT SO WE WORK FROM RECORDSET
report.Database.SetDataSource rs 'LINK REPORT TO RECORDSET

CRViewer.ReportSource = report 'LINK VIEWER TO REPORT
CRViewer.ViewReport 'SHOW REPORT


When i run the application it gives the error subscript out of range at the line --report.Database.SetDataSource rs .
Please let me know how i can assign a recordset at run time and create a report

Error Creating Crystal Report Object
I have the following code that throws an error on line 2- can't create object??:

Dim objReport As Object
Set objReport = CreateObject("crystal.crystalreport")
objReport.ReportFileName = "c:contract.rpt"
response = objReport.PrintReport

I'm using vb5 and crystal 4.5? What needs to be registered and how can I check it?
Thanks in advance.

Crystal To Stop Creating Report If No Data. How To Do This In VB6
Hello,
I want crystal to stop creating report ( in pdf format ) if there is no data. I've configured in Crystal Report Option to suppress report when there is no data.

However, when I'm creating the report through VB code and Crystal objects, Crystal does anyway create the report with no data.
Is there any setting for Crystal that need to be set in code to stop this?

Your help would be much appreciated.

Many thanks.

Creating A Crystal Report From Adodc Recordset
Please give answer of this question...
I want to create a crystal report 8.5 with crystal report 8.5 Designer module dynamicall like in same way as I can create Data report with Data Report Designer module given below.

Data report Creation process is as follows:
         1. In visual basic at first i add a Data report designer module (Report1)
         2. Then i placed three text boxes on the report detail section
         3. Then in another form i opend a adodc record set (i.e which can be bind with data grig )
         4. Then i added following code to open report
     
        With Report1
        Set .DataSource = Adodc1.Recordset
            .DataMember = ""
        With .Sections("Section1").Controls
            For intCtrl = 1 To .Count
                If TypeOf .Item(intCtrl) Is RptTextBox Then
                    .Item(intCtrl).DataMember = ""
                    .Item(intCtrl).DataField = Adodc1.Recordset(z).Name
                    z = z + 1
                End If
            Next intCtrl
        End With
        .Refresh
        .Show
        End With

      5. After adding this code a report is generated showing all records in the adodc1 recorset.

Now i want to create crystal report exactly the same way how it is possible
Please Help me

Creating Crystal Report Through Visual Basic 6.0
Hai,

I had done one project named as Resume handler. In this we are storing the entire details of candidate resume.
I had added one search form in with softaware,qfn,location as search options. The shortlisted candidates are listed in Flexgrid control.

My need is If I click on a candidate name in the Flexgrid control then a report will automatically generated by using the data in the database.

I am new to programming. How to connect the VB 6.0 with Crystal Report 11? How we can pass the required arguements from VB to Crystal Report? How can I allign the data in Crystal Report?

I am using Visual Basic 6.0, MS Access 2000, Crystal Report 11.

Please help me to solve this problem.

Thanks in advance.

Creating Price/volume Graph In Crystal Report
hi,

How do I remove the 'powered by crystal ' icon from the toolbar of crystalreportviewer?
Is it possible to create price/volume graph in crystal report?

Exporting Crystal To PDF But Creating Individual Files Based On Data In Report
I have just begun toying with Crystal reports and have completed the report that I want linked to the current database. The only problem is that when I export the report to PDF - I want to create a number of PDF files based on different data in the report. I can't seem to be able to do this via Crystal Reports (v9 i am using) so I thought that I could run a VB script on the full report and spit out the differing text files from the script.

Does anyone know of a good way to do this? Is this the best solution?

Please Help!!

Many Thanks

j_young_80

Unable To Open The Crystal Report Exported In Crystal Report Format
Hi,
Sub: Unable to open the Crystal report exported in Crystal Report Format

1)    I have used Oracle Native connection, while designing the report.
2)    I have passed the record set to the report at run time.
3)    Exported the report to Crystal Report Format, But I could n’t able to open report, while opening , the report asks for OLEDB information, even though I used Native connection at design time.
4)    In Crystal Report 8.5, connect driver property, but I am using crystal reports XI and in Visual Basic 6.0, Is there any method or property to convert the connection?. As I have to export report to crystal format and emailed to user, so that user can open it.
Any assistance in this regard is highly appreciated

The code is as follows:
Public Sub Aging_REPORT(strSQL As String, sReportName As String, sDestFileName As String, ReportTitle As String)

On Error GoTo Err
Dim CrAppl As CRAXDRT.Application
Dim crrep As CRAXDRT.Report

Dim rsCrystal As ADODB.Recordset
 
    Set CrAppl = New CRAXDRT.Application
    Set crrep = CrAppl.OpenReport(sReportName) 'Opens the report
    
   Set rsCrystal = New ADODB.Recordset
  
   
    rsCrystal.Open strSQL, Conn, adOpenStatic, adLockReadOnly
    rsCrystal.Requery
    
    
     With crrep
     .DiscardSavedData
    .Database.LogOnServer "crdb_oracle.dll", strServerName, "", strUserName, strPassword
     .ReportTitle = ReportTitle
     .Database.SetDataSource rsCrystal, 3 'LINK REPORT TO RECORDSET
     .VerifyOnEveryPrint = True
     End With
 
   With crrep.ExportOptions
    .DestinationType = crEDTDiskFile
    .FormatType = crEFTCrystalReport
    .DiskFileName = sDestFileName
   End With
   
     
   crrep.Export (False)
    Set crrep = Nothing
    Set CrAppl = Nothing
    Exit Sub
Err:
 MsgBox Err.Description

End Sub

Thanks,

How To Pass Format String To Crystal Report From VB And How To Use It In Crystal Report?
Hi,

I am working on VB 6.0 and using crystal report 7 as reporting tool.
In report, some clients are asking 3 decimal places(Eg. 2000.500) while other clients are asking 2 decimal places(Eg. 2000.50) for numeric fields.
I want to pass the amount of decimal places for numeric fields to crystal report from VB.
How should I implement this using VB.
Pls any one can help me?

Thanks in vance,
Soundar

How To Replace Crystal Report Control With Crystal Report Designer
Hi,

I want to replace crystal report control with crystal report designer in vb. report files are ready.
and parameters have passed by crystal report control to the actual repors which are made in segate crystal report.
now i want to keep the re[prt files as it is. but instead of control,
i want to use designer.

plesae help me

thanks
mital

Crystal Report ActiveX Vs Crystal Report Wrapper.bas
When print a report via Visual Basic, is it recommended to use the methods and properties of the ActiveX or using the functions provided by the wrapper, such as PEOpenPrintJob and etc.? If there's no diff in using both, then I have a question. There is a PEClosePrintJob function in the wrapper, however, there isn't any methods or properties in the ActiveX to perform such function. What will happen if PEOpenPrintJob (called by ActiveX's ReportFileName) is executed x times but the print job is not closed at all?

Regards.

Brandon

Connecting SQL Db From Crystal Report (through VB Crystal Report Control)
VB -> Crystal Report -> SQL database
I need to use VB to call CR (Crystal REport) to access data in an SQL server.



SETUP:
1) Over at the SQL server, I have created a login account, login ID = "RMS", and password = "9999".
2) I have created a ODBC - System DSN (in the control panel), with the login ID, password as in (1).
3) I have run-time CR installed on the client PC.
4) At the click of a button in my VB application, the CR (.rpt) will open (via Crystal Report Control in VB) and retrieves data from the SQL server database through the System DSN created in (2).

PROBLEM:
MY VB application FAILS to open up a CR file (.rpt) No error message though.

I realise that the VB CAN only open the CR (.rpt) when the PASSWORD in (1) is LEFT BLANK.

QUESTION:
It seems that I have to Hardcode the password somewhere.
1) HOw do I pass the password to CR so that the CR will not fail to display itself?


Really appreciate your good karma!

Thanks in advance!

Crystal Report... How To Print Crystal Report Using PrintDocument??
Hi.. I need help greatly... there's an issue which required me to make use of the PrintDOcument Object to print this crystal report..Instead of the pre defined printer button on the crystal report viewer..???Can anyone teach me HOW to print crystal report using the print document??it just seems to can't capture the crystal report for printing.... ANd how do i make use of the PrintPage Event???

Accessing Main Report Field From Sub Report In Crystal Report 8.5
Hi there,

is it possible to access a field that is in a main report from the subreport. The sub report and main report uses different Sql
statment. How could i achive this.

The reason i need this is because, i would like a value to appear
in a fieldA in the subreport, if the value in fildmain in main repoert is equals to 10.

any suggestions....

Thank You...

regards ....

How To Dynamically Change The Login Info Of A Crystal Report Using Crystal Query File
Hi,

How can I dynamically change the login information of a Crystal Report that uses a Crystal Query File (*.qry) to retreivee it's data using VB.NET?

It works fine when the report is built on regular table links generated within the Report Designer, I simply use the following :

Dim myLogonInfo As New CrystalDecisions.Shared.TableLogOnInfo()
myLogonInfo.ConnectionInfo.ServerName = UCase(SelectedDB.GetName) & "_ODBC"
myLogonInfo.ConnectionInfo.DatabaseName = UCase(SelectedDB.GetName)
myLogonInfo.ConnectionInfo.UserID = UCase(usr)
myLogonInfo.ConnectionInfo.Password = UCase(pwd)

(...)

CReport.Database.Tables(i).ApplyLogOnInfo(myLogonInfo)
MessageBox.Show(CReport.Database.Tables(i).TestConnectivity())

But when the Data is retreive using a query file it crashes.
Any ideas?

Thanks.

In Crystal Report, Report Is Viewed But Doesnot View Next Page Or Not Any Message Display!
in crystal report, report is viewed but doesn't view next page or not any message display! and surprisingly page no is increased infinitely (up to no limit!, I have checked up to 400+) but next page was not displayed! if I print report , only 1st page is print!

In this report , I have attached 6 subreports!

I hope anybody reply about my problem

Storing And Retriving Images From Access Databse Through VB Data Report Or Crystal Report
hi friends
    i have a problem that i have a database of some 8000 students in which there is a field called "photo" which stores the photograph. it is stored as BLOB field. now i want to retrive it in my report. i'm getting very much difficulties in it. can i have a help from master minds to resove the same. it will be very much helpful to me.
    my e-mail id: nnpatwa@yahoo.com
  ur suggestions r welcome. anybody can mail me. hoping for the best.

Crystal Report Crosstab Report Criteria Selection Using Access 2000
Hi there
I there anyone with an idea on how i can filter crosstab Report done in Crystal Report 8.5.. I'm trying to get data btw two dates for instance 05/01/04 and 05/31/04 but the following code doesn't do that. I'm using access 2000 database. Pls assist.

fMainForm.CrystalReport1.ReportSource = crptReport
fMainForm.CrystalReport1.ReportFileName = "F:OutGrowerReportsGLdelivered.rpt"
fMainForm.CrystalReport1.SelectionFormula = "Wdate" >= " & {CrossTabData.WDate} =" & "'" & CDate(DTPicker2.Value) & " AND Wdate" <= " & {CrossTabData.WDate}=" & "'" & CDate(DTPicker2.Value) & "'"
fMainForm.CrystalReport1.WindowState = crptMaximized
fMainForm.CrystalReport1.PrintReport
fMainForm.CrystalReport1.PageZoom (100)

or is there another better way to do this.

Help With Report - Easy One For People Familiar With Crystal Reports, Data Report Et Al
Till date, I have worked only with the Data Report
Utility that is dovetailed with the Data Environment
Designer, for the purpose of generating reports in my
applications. Shamefully, I am completely nescient of
Crystal Reports. I would want someone to kindly take
time to read my query and provide me a clue as to the
solution. The problem, I surmise, would be
interstingly simple for the creed of programmers who
are familiar with reporting softwares like Crystal
Reports.

I have a table in MS-Access 2000 and its called
'Holidays'. The Holidays table has the following
fields:

What's Logon Parameter To Oracle Server With Vb To Print Report With Crystal Report
Hi all,

How to write a log on parameter to oralce server with using vb to print a report that using crystal report

is it crystalreport1.connect = "Dsn=servername;uid=username;pwd=password"

and how to use the selectionformula

VB6.0 With Crystal Report 8.5 Package Setup For Crsytal Report Engine (Crystl32.ocx)
Setup Crystal Report Problem When I click Crstal Report Engine at Control Component (Crystl32.ocx) and I make Exe of VB 6 with SP4 , then I use Package & develop tool to make setup list I will facing a problem of Error 28 Out of Stack Space .

How To Change Database Conn Using RDC9 On Created Crystal Report Report.
Hi,

please answer me as soon as possible.

I have used CR 9 to create report that uses SQL Server data.

Now I want in VB to change so that I get report for some other database server and database. Structure and table names are identical.

I neet solution that will work for SQL Server and that will be work for all my reports, so that I don't need to know what tables are used in report. Also I need to say that my report uses more than 20 tables.

How ?!! I have read about changing connection property but it doesn't work. What to insert * HERE *:

Dim crxApplication As New CRAXDRT.Application
Dim Report As New CRAXDRT.Report
Dim strSel As String

Set Report = crxApplication.OpenReport("HZZO.rpt")

* HERE *

Report.DiscardSavedData

strSel = "{Stavke_računa_poliklinike.RacunBR} = '20030000001' "
Report.RecordSelectionFormula = strSel

cv.ReportSource = Report
cv.ViewReport

Server will be: gradp4
Database will br: Bis6Test
User: ime
Password: sifra
Connectivity technology: OLE DB

Thnx in advance.

Show Print Dialog When Printing Report With Crystal Report
Hi there,

In my code when I press on the printing button I want it to show the printing dialog to choose printer and tray which I will print out.

My code like this:

Public Report As CRAXDRT.Report
Set Report = crxApp.OpenReport(App.path & "Data
ptBDM.rpt")
Report.PrintOut true

With these code it only let me choose from page to page not for printer and tray.

Thanks a lots.

Crystal Report Problem Stock Ledger Report In Pos System
I am making a stock ledger report for a Point of Sales System. The user selects the items and the date range and the stock ledger report comes in the following format


Date --- particulars-- reference--qty--rate--value

The report is grouped item wise. The database table contains more or less the same fields.

What i want is to calculate the opening balance and make it appear before each item. say a user selects 1st march - -7th march 2005 as the date range and all items, so the report should show opening balance as on 28th feb 2005, the transaction after the date. How do i calculate the opening balance as on 28th feb in the report?

kindly help

Set Crystal Report Width And Height - For Very Long Report Size
i need to come up with a report that is 25 inches in width and about 113 or 15 in height... how?

i know, this might be simple for some but, i really have no idea...

Passing Pwd To Crystal Report Through Code To Generate Report On Pwd-protected Db
Hi everyone.

Now, I need to pass password to a report in run-time and generate it. I am using Crystal reports 8.5 and my database (from which I intend to generate report) is db-password protected. My project works very fine after the addition of 'Jet OLEDBatabase Password=myPwd' in the open string.

Please help me as I am in the middle of nowhere. I need to have a code on opening a report by passing the pwd from code and then open it using filters users prefer.

Thanks in advance.

Chirohorit

How To Save Report In Jpg Format, Generated Using Crystal Report In VB Application
Hello dear,
I am using VB6 + CR9 to generate a photo-ID report and want to save the report in jpeg format. Pls. let me know, How can it be possible?

Splitting Wide Report Into Multiple Pages In Crystal Report 6.0
I have designed a report in Crystal Reports 6.0 which does not fit into an A4 sheet. So I have to split the page into two or more A4 sheets. How can i do that?

Any help or sample report will be greatly appreciated.

Stuck With Report Design (Visual Basic .net/Crystal Report)
Hi all,

Im stuck with this report. My task is to create report from table that was designed by someone else and it cannot be changed.


The table schema is like this:
*******************************
accountID -----------------------int primarykey
batchNo---------------------------varchar
name --------------------------- varchar
icno ------------------------------varchar
coop1----------------------------varchar
invoiceNo1---------------------- varchar
amount1------------------------- float
coop2 --------------------------- varchar
invoiceNo2 ----------------------- varchar
amount2 ------------------------ float
coop3 --------------------------- varchar
invoiceNo3 ----------------------- varchar
amount3 ------------------------ float
coop4 --------------------------- varchar
invoiceNo4 --------------------- varchar
amount4 ------------------------- float
coop5 -------------------------- varchar
invoiceNo5 ---------------------- varchar
amount5 ------------------------ float
..
..
..
..
coop10 --------------------------- varchar
invoiceNo10 -------------------- varchar
amount10 ----------------------- float
********************************
The coop/invoiceNo/amount actually up to coop10.

The coop1 to coop10 fields is optional.. meaning some account can have only 1 or 2 coop and other will be empty.


accountID: BatchNo: name: icno : coop1: invoiceNo1: amount1: coop2: invoiceNo2: amount2: coop3: invoiceNo3: amount3: ......... coop10
0000001 A0001 Danny 123 CoopA 123 25.50 CoopB 123 110.34 CoopAX 251 110.66
0000002 A0001 David 5452 CoopM 123 25.50 CoopA 123 150.34 null null null
0000003 A0002 Marry 6655 CoopA 123 25.50 null null null null null null
0000004 A0002 Jack 1544 CoopA 123 25.50 CoopB 123 110.34 null null null
0000005 A0001 Lind 1235 null null null null null null null null null
  
In the Crystal Report i need to group the report by batch number with this format:


Date:

Batch: A0001
           
                   No: AccountID: Name: ICNo: Coop List: Invoice No: Amount:

                   1 0000001 Danny 123 CoopA 123 25.50
                                                    Coopb 123 110.34
                                                    CoopAX 251 110.66
                   --------------------------------------------------------------------------
                                                     Sub Total: 246.50
                   --------------------------------------------------------------------------


                   2 0000002 David 5452 CoopM 123 25.50
                                                     CoopA 123 150.34
                   --------------------------------------------------------------------------
                                                     Sub Total: 175.84
                   --------------------------------------------------------------------------


                   -------------------------------------------------------------------------
                                                 Grand Total: 422.34
                   --------------------------------------------------------------------------
The data will be generated from vb.net and filled to dataset from data adapter.
I will pass the dataset to crystal report using reportsource.

eg.
        x.xCRListSetAmtCOOP.SetDataSource(edt)
        x.CRAccount.ReportSource = x.xCRListSetAmtCOOP

The problem is how can i display only COOP with value inside the table to the report?

PLEASE HELP..OR AT LEAST GIVE ME SOME CLOSES SOLUTION ON HOW TO SOLVE THIS.

I dont know if CR can generate this report with that table schema or not.. pls help.. really..
thanks in advance








Edited by - racyde on 6/7/2006 10:46:48 PM

Crystal Report 6.0 Troubles To Get Data In The Report With Win 2000 Environement
I have migrated and old VB5 application that was running perfectly on windows 98 and millenium to Windows 2000.
All the application is working fine, but sometimes when a report (crystal Rep. 6.0) is called from the vb application, the report comes blank although the temporary table generated for the report is correctly populated in the access 97 database.
Restarting the application and re-asking the report often show the correctly filled data.
 
It sounds like Crystal report encouter troubles to read the database in windows 2000 although exactly the same process was used for the former windows version. All the software are the sames :
 
Visual Basic 5.0
Crystal report 6.0 
MS-access 97 Database
windows is now windows 2000 SP2
 
Has anybody an idea to help me ?
 
Thank you !
 
Denis

Solution Required In Crystal Report Cross Tab Report Through Vb Ocde
Hi all,

I need some help from you friends, Actually we are developing reports using Crystal Reports 8.0, Visual Basic 6.0 and with Sql server 7.0 as our database. I have created RPT report file and I am calling them through my VB form. As i am a beginner for this I am facing some problem while generating Reports (cross tab reports), which are as follows.
·    1. Can we change the width of the column in cross tab at runtime?
·    2. My cross tab report has 16 columns so it is extending to one and half page even in landscape. Is there any solution to print this cross tab report in one page in Landscape by changing printer setting through VB code programmatically?
·    3. At present my report is displaying data for one company (which ever user has selected) in one cross tab. If user selects all companies option then my report should display multiple cross tabs continuously with one cross tab for one company data in a single RPT file (it can extend multiple pages). Is there any solution for this? If u have solution pls help me as soon as possible.
          4)I also want to supress the empty columns in the .RPT file through VB code

Waiting for u reply as soon as possible
thanks
Sunny

Getting Crystal Report Messages While Executing Report From Visual Basic 6.0
Hi,

I am trying to execute Crystal Report from Visual Basic. I am getting some messages while executing the report, which I want to suppress.

I am using Crystal Reports XI and Visual Basic. I am connecting to SQL server database using ODBC connection. I am using CRAXDDRT class library.

I have set all required properties for processing crystal Reports like database connection, Report file, Export options, Export report file, Database table connection properties. Before exporting I am verifying the database by CRReport.Database.Verify command. Then I am using CRReport.export (False) command to export the report output to some disk file format (Excel, PDF etc.)

But when the CRReport.export command gets fired, it shows me message like “The database file Mytable has changed. Proceeding to fix up the report”. I do not want to get displayed this message, as my requirement is to execute report silently without having any user interaction.

Please let me know if any one has solution to this problem.

Problem Creating Report With Data Report
i have data enviroment with the connection to my data base. it has one command which it is supposed to select a single recordset based on the input by the user in a form in my app. if the command gets everything from the table it works properly and displays what i want. but when i use the sql statement it doesn't retrieve the record i want. when the user inputs the jobnumber it is store in a public variable called jNumber in the form frmReports. here is the sql statement i am using:
SELECT * FROM MainLog WHERE JobType = ' " & frmReports.jNumber & " '

wat am i doing wrong?

Crystal Report 8.5 Error While Exporting A Report In PDF Format
can anybody help me??
I have generated one report in crystal report 8.5 .Now crystal report is giving a facility to export it in different file formar like excel,PDF,RTF.Here I am facing one problem I am able to export the report in all file format except PDF and RTF.When I am selecting a PDF file format it is asking me for disk file, MAPI .After this i select the disk file option ,then its asking me for all pages or range of pages.After this nothing is appearing on the screen...

Can anybody please help me..

Passing Crystal Report Or Viewer A Value Used For Filtering The Report
I having a problem trying to filter out my crystal report based on a case number which is a primary key in my access table tblCaseInfo. I am trying to do this through vb.net so when the user is viewing a particular case they can click the print button and print only that particular case being viewed. The case number will be coming from a textbox (txtCaseNumber.text) on the form in vb.net.

As of right now when the print button is clicked every case in the database is displyed in the crystal report viewer to be printed.

I have three tables involved:
tblCaseInfo - VictimID, AssailantID are foreign keys for the table listed below
tblVictimInfo - VictimID Primary Key
tblAssailantInfo-AssailantID Primary Key





Only code I have so far:

Private Sub btnPrintSurveyReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrintSaveSurveyReport.Click

frmSurveySummaryReportInstance.ShowDialog()

End Sub

Generating Report On The Basis Of Textbox Value By Using Crystal Report 9.0 In VB 6.0
Hello friend,

I want to generate report on the basis of textbox value entered by user by using crystal report 9.0 in VB 6.0.

please help me regarding the same.

Regards
kamlesh

Copyright © 2005-08 www.BigResource.com, All rights reserved