Visual Basic :: Error On Selection Formula To Display Data On Crystal Report From SQL Database

Crystal Report Selection Formula
Hi,
how can i use left, right and mid ect. function in crystal report selection formula. for example:

CR.SelectionFormula = "mid({Custumer.CustCode},1,3)" ....

we can use mid funtion in VB and Substr function in SQL query, what in Selection formula?

thanks

Crystal Report Selection Formula
I have a problem with the selection formula to be used by crystal report 10. At first I just set one selection formula and it's work and now i want to used two selection formula but I do not know how to write it. Below is the code and the word highlight with red color is the formula i want to add.Can anyone teach me how..

Code:

Private Sub ListView1_DblClick()

ndLeaApprEmpNo = Trim(ListView1.SelectedItem.SubItems(3))
ndLeaApprLCode = Trim(ListView1.SelectedItem.SubItems(1))
ndLeaApprDt = Trim(ListView1.SelectedItem.SubItems(4))
'MsgBox ndLeaApprEmpNo & ", " & ndLeaApprLCode & ", " & ndLeaApprDt
Unload Me

Me.MousePointer = vbHourglass
Dim crApp As CRAXDRT.Application
Dim Report As CRAXDRT.Report
Dim strSelectionfrm As String
Set crApp = New CRAXDRT.Application
Set Report = crApp.OpenReport("C:Program FilesMicrosoft Visual StudioVB98ProjectsLeaveAppLeaveForm2.rpt")

Report.Database.Tables(1).SetLogOnInfo "SQL", "tebrauteguh", "sa", "sa"
'{tblLeaveApp.EmpNo}='" & ndLeaApprEmpNo & "' -->another selection formula i want to add, how to combine both
strSelectionfrm = "{tblLeaveApp.Date_App}='" & ndLeaApprDt & "'"

Report.RecordSelectionFormula = strSelectionfrm
Report.DiscardSavedData
Form8.CRV.ReportSource = Report
Form8.CRV.ViewReport

Form8.Show
Form6.Hide
Me.MousePointer = vbNormal

End Sub

Selection Formula In Crystal Report
Hello!

I created a parameter in CR that takes a list of values and limits selection to them, e.g.,

{fieldvalue} in {?parameter}

So, this works if I passed in (A0111,B0121) as the parameter. If the field value is any of those two, it gets listed in the report.

The problem I have is that if I pass in (A011, B012), then CR treats that as (A011*, B012*), e.g., anything that starts with A011 is pulled in. I only want, to give an example, A011 only.

What other way can I approach this to avoid the problem? Thank you for your help.

-Bahman

Selection Formula In Crystal Report
Hi everybody,

Im using crystal 4.6 basically i want to select records using the selectionformula property of crystal control
something like.
cr.selectionformula=expr1 AND expr2 And expr3
i searched a lot but found that one expression is used for selection like
cr.selectionformula=expr1

i need to select records based on multiple conditions

Any help is welcome
Thanks
Kapil

Crystal Report Selection Formula Problem
I want to pass the selection formula from the vb application which is using a crystal report control. I am using crystal report 8.5. now i have a list of 3000 items from which i am allowing the users to select the items he want. whatever items he is selecting is passed as the selection formula

"{inventoryreceiptdetail.itemid} in [" & SelectedItems & "]"

(where selectedItems contains comma seperated item codes)

The thing works fine when i select few items, but as soon as i select somewhere around 1000 codes (each code is of 10 digit) it gives me error 20515.

I tried putting that selection formula directly into crystal reports. it said, "too many items have been given to this array" . When i reduce the items, it works fine.

Can you help how to get the result even with large number of items

Crystal Report Selection Formula (Urgent)
Hi Friends,

I am using crystal report to get the list of students registered between two dates. I am using vb6 as front end I've written following code to display report:

VB Code:
With crStudList .Connect = strConn .ReportFileName = App.Path & "
eportsStudentList.rpt" .ReportTitle = "Student List" .WindowTitle = "Student List" .SelectionFormula = "{tblStudent.RegistrationDate}>=#" & dtpFrom.Value & "# and {tblStudent.RegistrationDate}<=#" & dtpTo.Value & "#" .WindowState = crptMaximized .Destination = crptToWindow .Action = 1 End With

Where DtpFrom and and dtpTo are DtpPicker control which are used to select start and end date value. I've set its format to customFormat and Custom format i've set is "dd/MM/yyyy"

Its not giving any errors but if i give 01/02/2006 as start date and 28/02/2006 as end date, it should display only students' who have register in between these two dates but it displays all who registered in 02/01/2006 or 20/01/2006 or 08/01/2006.

plz help.

thx a lot

Crystal Report - Subreports Selection Formula
please help me

i need to change All the subreport selection formula , same as the main report. I Try this code but doesn't works.

'sel is string which the selection formula
Cr.SubreportToChange = ""
Cr.SelectionFormula = Sel
iSub = Cr.GetNSubreports
If iSub > 0 Then
For iCtr = 0 To iSub - 1
StrSub = Cr.GetNthSubreportName(iCtr)
Cr.SubreportToChange = StrSub
Cr.SelectionFormula = Sel
Next iCtr
End If

that code is working only if there is only one table in a main or subreport. that doesn't work in more table !

please help me , how to do this ?

thanks very much

Change Selection Formula Of Crystal Report
Hi There,
I wanna change the slection formula for selecting records of a report (created using Crystal Reports 7) from within the vb code. I'm Able to change the formula when i'm using a string field for condition.

When I Use

crx.replaceselectionformula "{T01.F1}='AGL'"

everything works fine and i get the preview window of crystal reports.

But when I Use

crx.replaceselectionformula "{T01.F0}=date(2004,11,18)"
No records are listed whereas i'm having 10 records with F0 as 11/18/2004

Here

crx - Crystal Reports ActiveX Control Object
T01 - Data table
T01.F0- F0 field of T01 (Data Type : Date/Time)
T01.F1- F1 field of T01 (Data Type : String/varchar(10))

Is the code i'm using correct. If not please tell me how to select records with the given date for T01.F0 Field

Date In Selection Formula Of Crystal Report
Hello,
I m setting the range of Dates in Selection formula of Crystal Report which is adjusted in VB. Code is like this :

Qry="{GateIn.InDate} >= '" & Format(DTPFrom, "mm-dd-YYYY") & "' " _
& "And {GateIn.InDate} <= '" & Format(DTPTo, "mm-dd-YYYY") & "' "

CryRep.ReplaceSelectionFormula Qry

Its not working properly. How can be its possible ?

Thanks

Crystal Report ,how To Discard A Selection Formula?
When i pass a selection formula from form to report it works as where clause , but if i want to undo the changes made by selection formula i.e. i want the original report without the effect of selection formula how to do it?

Thnaks to all u wonderful people in advance.

How To Display Data From Database SQL In Crystal Report?
i'm new in VB.NET and need help in crystal report.
i've tried but i still face problem in binding the crystalreport viewer and crystal report. i get error when i put this source code: "CrystalReportViewer1.DataBind" in method CrystalReportViewer1_load.
i would be grateful if anyone can help me in this... please...
thanks

How To Use Record Selection Formula With Visual Basic 6.0 And Crystal Report 11.0
Hello Crystal Report 11.0 experts users,

I am first time trying to use CR11.0 with vb6.0. Previously I was using
CR8.5 and find no problems. Now, I am trying to use new VERSION OF
CR11.0 with VB6.0 and am strucked here.
I am using below code
Dim Report As New CRAXDDRT.Application
Dim RepApp As New CRAXDDRT.Report
CRViewer1.ReportSource = Report.OpenReport(NPath & "Service
Dash11.rpt")
RepApp.RecordSelectionFormula = "{DashBoard.Year}

06"

It gives me error message saying "Basic syntax is not supported in group
or record selection formula".

I have tried all possibilities and even searched in sites but not
finding any clue in this regard.

Kindly assit me in this regard.

Regards
arun

[UNRESOLVED]Crystal Report -- Formula Error
@ Details section i used Supressed (No Drill Down) with the ff statements:

If {?ReportType} = "1" Then
{@Balance} <= 0 //All -Balance will be shown
    else

    If {?ReportType} = "2" Then
    {@Balance} >= 0 //All +Balance will be shown
        else

        If {?ReportType} = "3" Then
            {@Balance} <> 0 // 0 Balance will be shown

Now my problem lies at the Report Footer, I want to sum up the values as per condition above.
I used sum() and it ignores the condition and sums all positive and negative giving me wrong grand total. Any advice on how to sum it up according to the report type i selected?

Edited by - pasaway on 5/11/2006 1:29:49 AM

Selection On Data On Crystal Report
I'm new with Crystal Reports in VB. Now I've created a report within Crystal Reports. This works well. The source for the report is the database that also is being used by my VB-application. Now I Call the report from my VB-application and it is being shown, but with all the data from the database of course. How can I do a selection on the data being showed? The user can select a week in the VB-app for example and only the appointments for that week have to be shown in the Crystal Report. How do I do this? Thnx a lot 4 the reply's in advance...

Display Image In Crystal Report From Database
hello
sir

i am desperately in need of suggestion or say i want to know how to display image (ie pic of students) in a crystal report to print their admit cards.
Sir i have a databese field name (picture datatype - ole object ) in STUDENT_mas table
and the data stored in the database is Long binary data

sir now i want the report off all students for their admit card with their pic stored in the database on the report . iam able to display the same in vb in image control
but not able to display it in crystal pls
pls
pls
pls
help

thanking u in advance

hussain

Data Display In Crystal Report ???
Hey I`m sorry for asking again and again, but I have not worked on Crystal Repots before this.

What is basic concept of showing data in Crystal Report. When I select tables and fields in a report. Then all available data is displayed in that report OR can it be changed as per requirements. If yes then how ?

e.g. I am having data of attendance (date / time) of Employees. And I want to display data only for specific month. In short how can I customize display in Cryst. Repo. ?

One more que. : Format of a field is Date/Time and I stored time in it. (e.g. 14:00:00) but report is showing Date value at random (e.g. 99/12/30)

Please Guide !

Crystal Report Data Display
Hi all
I have made Report by using recordselectionformula but when i am previewing the report that is coming correct and suppose i have closed the preview and without unloading the project i want to see the report for some another record i have to click on the refresh button without this i am not getting data display
and if i stop the execution and execute the s/w then again once it is working o.k. for once and again the same procedure if anybody of u can suggest me sol.
Dinesh

Crystal Reports Selection Formula HELP
Hi

Please bare with me as i'm new to Crystal

I intend to open a report (CR8) from a VB6 application. I have a database (Access) that holds the info I want but I only want to show records that are >= the date I enter into a text box.

Just to start with I have this as my selectionformula in Crystal which does not return any faults and if i change the date between the hash's then the report changes accordingly (from within Crystal)

DateValue ({Outgoing.Date}) >= #01/08/04#

I have deleted this formula in Crystal and am now entering it at the cr1.selectionformula property in my VB code but it does not seem to like it when i open the report telling me 'You need a number or string etc here'.

Ideally i want the hashed date to be a string in VB that i enter into text box but I though I Better try to crawl before walking.

Many Thanks
Shamus

Selection Formula In Crystal Reports
With crptCreditorsList
.ReportFileName = App.Path & "
eportscreditorslist.rpt"
.PrinterCopies = intCopies
.SelectionFormula = " {Creditors.accountnumber} BETWEEN '" &
strFirst & "' AND '" & strLast & "' "
.Action = 1
End With

WHy doesn't this Selection Formula work?Please help....

Crystal Reports Selection Formula, SQL
How do I construct a SelectionFormula that uses a date in VB? I am using SQL Server 6.5.

My VB6 code looks like this:

Private Sub cmdPrint_Click()
Dim rptSql As String
Dim rptDate As Date

rptSql = "SELECT * FROM CheckRegister WHERE {CheckRegister.bank_statement_date}=Date('"
rptSql = rptSql & cboStatementDate.Text + "')"

CrystalReport1.SelectionFormula = rptSql
CrystalReport1.Action = 1
End Sub

I have tried many variations on this formula, such as using the string variable alone, in quotes, and using a date variable instead of a string variable, but nothing seems to work. I keep getting the error message "The remaining text does not appear to be part of the formula".

Does the date have to converted to a different format?
If any one has a solution, I would greatly appreciate it.

Help With Crystal Report - Display Only Needed Data
i'm really new to crystal reports. i have a database which saves payroll information every 15th day, now i want to come up with reports on a specified paydate only... how do i go about it?

say, i have payroll records each employee for the last 5 paydates, so how do i go about having only to print one of these paydates instead of having all existing paydates in my report?

any suggestion, links? tnx.

Display Dynamic Data In Crystal Report
hello Sir,
i m using vb6 and access 2000,crystal report 9.
i would like to display changed access table data at run time. my problem is report is not accepting data from database.
actualy i stored data in access table from text file.
but it not reflecting when i create exe of project and run it.it display records from local disk,where project sored.
pls help me. my code is as

Open App.Path & " est.txt" For Input As #1
Line Input #1, cname
Line Input #1, ccity
Line Input #1, sno
Close #1
str1 = "Delete * from Table2"
Set rs = New ADODB.Recordset
cn.Execute str1
rs.Open "Select * from Table2", cn, adOpenDynamic, adLockOptimistic
rs.AddNew
  rs.Fields(0) = Trim(cname)
  rs.Fields(1) = Trim(ccity)
  rs.Fields(2) = Trim(sno)
rs.Update
rs.Requery
cr1.Database.SetDataSource rs
DoEvents
cr1.DiscardSavedData
cr1.ReadRecords
rs.Close
For i = 1 To cr1.Database.Tables.Count
cr1.Database.Tables(i).SetDataSource (App.Path & "sample.mdb")
cr1.Database.Tables(i).Location = App.Path & "sample.mdb"
cr1.Database.Tables(i).SetLogOnInfo "", App.Path & "sample.mdb", "", ""
Next i
cr1.Database.Verify

Crystal Reports: Selection Formula Of A Subreport
in my report i have a subreport. the problem exists when i want to make a selection formula of that subreport. it says that cant find the table.

Selection Formula To Subreport: Crystal Reports
I've never used the subreport feature of Crystal report and do not know how to call up a report that has them from VB. I have a report with 3 subreports. I need to have the reports only display values for a specific date. How do I pass the selection formulas to the subreports? Is it just the normal way? I use this to select the records of the primary report, but the subreports are showing all dates....

Code:
With CrysReport
.ReportFileName = App.Path & ReportName
.DataFiles(0) = App.Path & "DB.mdb"
.SelectionFormula = Selection 'defined my selection formula elsewhere
.DiscardSavedData = True
.WindowState = crptMaximized
.Destination = crptToWindow
.Action = 1
End With

Selection Formula Problem Crystal Reports
Hi there

I want to pass a parameter from vb6 that whould return like in this example cust 1 and cust 2. How do I do this? Because the selection formula does not seem to work

CR1.ReportFileName = gsReportPath & "ActiveCust.rpt"
CR1.SelectionFormula = "{Customer.Id} in ('1' ,'2')"
CR1.PrintReport

CR REport - Group Selection Formula
I would like to create a group selection formula...
Can anyone give me a sample code formula to what goes into a Group selection formula, the CR help tells you the steps to create one but do not give you an actual sample of the formula.

How To Display The Crystal Report 11 Using VB6.0 - Error Message Invalid TLV Record ...
Hello VB & CR users,

I have upgraded my Crystal Report 8.5 to 11. I know how to use CR 11.0
with VB.NET.

But one of my applications is still using VB 6.0 but I want to upgrade
all the reports to 11.0. I have added the "Component ->Crystal Activex
Report viewer library 11.0" and named crviewer1. Using below method
previous 8.5 reports displays correctly but the new report which is
creates using 11.0 gives message "Invalid TLV record". Please anyone
guide me here what else is required or which is correct code for the
below procedure????

ReportName = NPath & "oilcustomer.rpt"
Set CrxReport =
crxApplication.OpenReport(ReportName)
CrxReport.DiscardSavedData
CrxReport.VerifyOnEveryPrint = True
For i = 1 To CrxReport.Database.Tables.Count
Set CRTABLE = CrxReport.Database.Tables.Item(1)
CRTABLE.SetLogOnInfo "ServerName", DatabaseName", "Username",
"Password"
Next i
CrxReport.DisplayProgressDialog = True
CrxReport.VerifyOnEveryPrint = True
CrxReport.UseIndexForSpeed = True
CRViewer1.ReportSource = CrxReport
CRViewer1.ViewReport
CRViewer1.ShowFirstPage

Regards
Arun

Set Selection Formula For Subreport In Crystal Reports Using Visual Basic 6.0
Hello Experts,
I have designed a report using crystal reports 8.0.
There are subreports also included.front end is visual basic 6.0
I change the selection formula of the main report using
crystalreport.selectionformula. I am not knowing how to
set the selection formulae for the sub reports.
can any one help me .

How To Display Image In Database To Data Report
Hi,
I store my images in ms-access and I would like to display it to data report for each record. I don't know how to code or
method for data report. I would like someone to suggest me or example code.
Thank you very much
Tom

How To Display Flexgrid Data In Report Without Storing In Database
hi

I am developing s/w regarding that how to display flexgrid data in report without storing in database

i tried it with textbox then it is ok with it
but when i try with flexgrid it gives error like subscript is out of range
code is like this

private sub command1_click()
With DataReport1.Sections(1)
.Controls("txtitemcode").Text = Form1!msflexgrid1.TextMatrix(newrow, 1)
End With
DataReport1.Refresh
DataReport1.Show
end sub

waiting for reply.
thanx in advace

Crystal Report Error 20534: Error Detected By Database Dll
Hi,

Can anyone tell me what this error means and how can I solve it?
I am using vb6 app, crystal report 8 and access 97. I try to open a report which is connected to sql table when this error occurs.
Thanks for help.

Error Msg In Connection From Crystal Report To SQL Database.
Error Msg in connection from Crystal Report to SQL database.

I am trying to connect to SQL database from CR (Crystal Report)

In SQL server end,
I have created a "dbo" login id (rmslogin) and password for access to the database.

In the CR end,
I have created a report using ODBC/SQL, via a ODBC system DSN that I have added in the client PC, using the "dbo" id (rmslogin)and password to access the database.

But when I try to invoke the CR from my VB application, the error message in the attached file keep appearing..

The second portion seem to relate to the login password..which is correct.

But I do not understand the first portion about connection string error, coz I'm pretty sure I did not add a connection string while I'm creating the report.. any ideas???

The application seem to function correctly if the "dbo" id have NO PAsSWORD.

hmm any ideas???

Help!!!

Thanks!
Tommy

Error Database SQL 7/2000 In Crystal Report
Hii I would like to display a report on Crystal Report ver 8.01 of some table (database) from the SQL 7/2000 but when me tried this on the preview there in an error ( “Seagate Crystal Report : Database Error”, “General Sql Server error: Check messages from the SQL Server “, “ Error Detected by database DLL” ), I connect from CR->database->more data source->Microsoft SQL Server->…. ,but when I use connect from CR->database->ODBC->create data source… We could go true without any error ? I wonder and would like to know, why this could happen ? Please, Advice of there is something wrong , thank 'U

Error Opening Crystal Report With Oracle Database
I use Crystal Reports 8.5, Visual Basic 6 and I have an Oracle Database.
I want to open a Crystal Report from VB6, but what seemed to be very simple with MySQL and Access, now seems very complicated with Oracle.

This is the code I tried, but I get the Error ORA=00933:SQL command not properly ended.
Can anyone help me PLEASE !

*******************************
Dim RepName As String
Dim crxApp As New CRAXDRT.Application
Dim crxRep As New CRAXDRT.Report
Dim i As Integer

repstring = Me.Command2(Index).Caption

Set crxRep = crxApp.OpenReport("R:" & repstring)
crxRep.DiscardSavedData
For i = 1 To crxRep.Database.Tables.Count
crxRep.Database.Tables(i).SetLogOnInfo "", "", "usrname", "passwd"
Next i

Me.CRViewer1.ReportSource = crxRep
Me.CRViewer1.ViewReport

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.

Crystal Report Formula Help
i dont know where to begin... i have created this report and would like to have when the user inputs a begdate and enddate and state to show $totals of that criteria.
the report does show the beg date and end date and the state , but the only thing wrong it calculated the total cost of all the states income in the grand total of the report, i only want to have the state to show the total of that kind
ie if user inputs begdate = 1/1/03 and end date (today) and select state CA i want the report to show the totalcost income of that state between those dates, it only shows the grand totalcost of all states right now....
i am using win xp, vb6 and crstal report 4.6? that is on the vb cd

i dont know if i need to code in vb or put a formula in crystal???? HELP please

StartDate = InputBox("Enter Starting Date To Print:", "Date Entry", Date)
EndDate = InputBox("Enter Ending Date To Print:", "Date Entry", Date)
State = InputBox("Enter Code of State To Print:", "State Entry")
If StartDate = "" Then
Else
If EndDate = "" Then
Else
If State = "" Then
Else
CrystalReport1.ReportFileName = "\Server1salestx.rpt"
CrystalReport1.GroupSelectionFormula = "{OrderStatus.Date} >= " & "Date(" + Format$(StartDate, "yyyy,mm,dd") + ") and {OrderStatus.Date} <= " & "Date(" + Format$(EndDate, "yyyy,mm,dd") + ") and {OrderStatus.Order_State} = " & "'" + (State) + "'"
CrystalReport1.Action = 1
End If
End If
End If
End If

Crystal Report 8.5 Formula
greetings,
I work with VB6 sp5, SQL Server2000, Crystal Reports 8.5
Trying to create a certain report, I need to check the values of some table fields and accordingly display some notes.
my table contains, among all others, two int-type fields called HoursIn and MinutesIn. I would like to create a formula (i guess) to check these values.
If both are 0 then I would like to display "CLOSED", otherwise diplay the HoursIn and MinutesIn values.

can someone help me with this please?
should I have an empty text field and feel it accordingly? or insert the formula field and have it feeled? how can it be done? I tried but with no success.
thank you in return.

Formula In Crystal Report
Hi All,

I want to create formula in Crystal report.I am very new to Crystal reports.Can Any one guide me how to Create formulas.

I want to use replace function .

Any Ideas??

Crystal Report 8 Formula?
I'm having problems grouping a formula field. I have been told that you cannot create a group if the formula has the WhilePrintingRecords within the code. I have 4 formulas that help me get the subtotal(so to speak) for the Total Time(text object). Not a field with in database.

Formula1: WhilePrintingRecords;
NumberVar RunningTotal;
RunningTotal := 0
Formula2: WhilePrintingRecords;
NumberVar RunningTotal;
RunningTotal := RunningTotal + {@TimeDiff}
Formula3: WhilePrintingRecords;
NumberVar RunningTotal;
RunningTotal;
The 4th formula is just attaching the word minutes to formula3 total. Now is there another way to get a total for this field without using the WhilePrintingRecords, so that I can make a group out to the total field?

Thanks for any help jeffro!

Crystal Report Formula..??
I hope someone can help me out. I'm trying to write a formula for the top ten in industrial. The fields I'm using are repairtime, setuptime, and pmtime, which are used to do the totaling and that will be used to find the top total of the machineno. Also I'm using the machineno, and division, the division field is used to look up just the industrial equipment.

Can anyone help out??

Aja

Crystal Report Formula
Hi Guys,

I am using Crystal reports 8.5. I am writing reports for another packaged software which takes custom crystal reports. I have written a report and it work fine. But I have a small problem in Record selection. I have a field on the report depending on this field starting characters another field must be selected from another table. I was wondering if a formula can do this. ie using a query in a formula.

I would check like this

if Left({field1},1) = "S" then
here I need to select another field from another table with different condition
else
{field2}

Could you guys help me out on this.

thanks

Crystal Report 9 Formula
where can i get more tutorials or resources or good ideas for effective high level formula writing.

Crystal Report Formula
Hi friends,
I am using crystal reports 8 . while writing the formulas the all the fields are not displayed in report fields(in formula box).
for E.g I am trying to hide/supress one of the fields which is blank using the formula for that particular field. but cannot see that fields in report fields in the formula box.
Any help will be highly appreciated.

Noorali.

Retrieve Specific Data From Access Database To Crystal Report
I'm a newbie with Crystal Report and VB6.

Can anyone tell me how to retrieve a specific data from access database to crystal report?

Say, I want to retrieve from table sales, where month is September.

Can anyone tell me the step by step on how to do this?

Thanks

Crystal Report Database Connection Logon Failed Error
hi
i get log on failed when trying to connect to access database through
field explorer wizard database connection.
in the dialog box i m giving password which is the one to open access file so it is right?
otherwise if i dont assign password to access database file it works fine but with password it gives error .
and also what goes in jet database and jet database password textbox on dialog?
thanx in advance
nilesh

VB6 And Crystal Report 8.0, Client Machine Error Detetcted By Database Dll
Hello,
We are using VB6 with SP6 and crystal report 8.0. We designed one crsytal report using addins for crystal repor in VB6. We are using Microsoft access driver (*.mdb) with mdac 2.8
and using ADODB connection object.
Our client has a multiuser environment, so we have to dynamically create a temporary table which contains the report data and while showing the report we set the datasource to this temporary table.
Every thing works fine on the main computer where Access file reside, but on the client computer (which connects to this mdb on main computer) report is not shown. It shows error detected by database dll. Apart from viewing this report, every thing else within our application works fine on this client computer so this rule out any network problem.

What my first guess is that, this temporary table is not visible on client machine to the crsytal report, but if I do a select * from this temporay table the data shows?

Please provide me with some ideas how to solve this problem.

Thanks in advance,
Amir

'Error Detected By Database DLL' While Calling Crystal Report For Different Databses
In my Application I am using VB6,SQL Server Database. I am calling the Crystel Report using Crystal Report OCX. I used the connect propety of the control as

.connect="DSN=kiran;UID=kiran;PWD=kiran;DSQ=kiran"

here I have created a DSN 'kiran'

the rpeort is working fine for the 'kiran' database, but when I want to work with another database to 'newdumpkiran' it is showing an error as 'Error Detected by the Database DLL'.

i changed the connect property as

.connect="DSN=newdumpkiran;UID=newdumpkiran;PWD=newdumpkiran;DSQ=newdumpkiran"

Also I cretaed a new DSN 'newdumpkiran'

but it is showing an error

any body please help me.

Pass Formula From VB To Crystal Report
Can anyone explain to me how I can pass a formula from a VB6 application to Crystal Reports?

I want to select specific data from the database based off of a variable in vb.

For example: In the VB app, to create the recordset, I would say
SQL = Select * from tablename where dbField = '" & txtRegion & "';"

I only want to pass the results in the recordset to CR or pass a formula where Crystal Reports would give me the same info.

Thanks,
Sam

Formula Problem In Crystal Report
I am using Crystal Reports XI.
Here is the scenario:
In the Report, I have 2 tables from the same MS Access Database. They are:
PartStatus
PartNumberChange
They both have a Primary Key call "dbPartNumber"
In the Link area of the Database Expert, the relationship is showing from PartStatus to PartNumberChange.
Part Status record must exist.
PartNumberChange record does not need to exist.

I created a record formula:

Code:
{PartStatus.dbQtyOnHand} + {PartNumberChange.dbOldQtyOnHand}
The problem is when I print the report only those PartStatus records that have a PartNumberChange record will print.
I want to print ALL the PartStatus records with their "dbQtyOnHand" . if they have a PartNumberChange record , I want to add the dbQtyOnHand to the dbOldQtyOnHand and print that total.

If I remove the formula, all the PartStatus records print but the totals are not correct if there is a matching dbPartNumber record in the PartNumberChange Table.
Thanks,
Sam