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
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
**RESOLVED**Crystal Reports Formula (PASS/FAIL)
Let's say I have a crystal report which contains the names of ten people. Each of these people has undergone five tests which result in either "PASS" or "FAIL". I am setting up my report to look like a grid. The names of each individual will go in the report header and the results of the five tests ("PASS" or "FAIL") in the details section. In order for the individual to ultimately pass they must pass all five tests. I would like to have a formula, which I would put in the report header next to the individuals name, which would result in "PASS" only if the individual passes all five tests or "FAIL" if the individual fails even one single test. Any crystal formula gurus out there?
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
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.
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
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
Sending Value In VB To Formula In Crystal Report 8.5
holla...
wrong room perhaps... but pls help... since I know this room will reply faster that other.... and I need this help soon.
I have a .RPT file which have an empty formula.
if you ask why empty formula ? coz, I'll send a value to this empty formula from my VB project.
PS : only 1 formula exist in that .RPT file
let's say this empty formula name = "period"
and I have a text box object, name = "txtPeriod"
what i need to do is to send txtPeriod.Text (in VB) to formula "{period}" in Crystal Report.
I did as below, but error.....
VB Code:
Dim CApp As New CRAXDRT.Application Dim CReport As CRAXDRT.Report Dim myPeriode as String Screen.MousePointer = vbHourglass Set CReport = CApp.OpenReport(App.Path & "myReport.rpt") CReport.DiscardSavedData CReport.PrinterSetup (0) myPeriode = "As Of : " & Format(cDate(txtPeriod.Text), "mmm-yyyy") 'error occured at below line CReport.FormulaFields(1).Value = myPeriode
any help ?
pls...
thx a lot,
[-w-]
Calculate And Formula In Crystal Report
I must do a report by crystal report6 about testing result that concerns 4 tables as follows:
1. Product table => ID, Name,
..(other details of product)
Eg. F102 Bead wire02
2. Specification => Table that keep specification of each product
Effect_date : effective date for this product (mm/dd/yyyy)
Product_ID : id that links to product table
Aname: Type of analysis
Min: Minimum value
Target: Target value
Max: Max value
XXXX = Aname in specification
Test value = Value of testing
Eg.
Effect_date-----Product_ID------Aname--------------Min----Target---Max
06/1/2000-------F102-------------Rugosity-------------3.5---------5---------7
06/1/2000-------F102-------------Diameter-------------5----------7---------10
06/1/2000-------F102-------------WL---------------------2----------5---------7
06/1/2000-------F103-------------WL---------------------2----------8---------10
07/1/2000------F102--------------Rugosity--------------3---------5---------7
3. Production record
Ticket_no----Product_ID: --------Production_date
..other production detail
10005---------F102------------------07/25/2000
10006---------F102------------------07/26/2000
10007---------F102------------------07/27/2000
4. Test result
Ticket_NO: Ticket number in production line
Product_ID: id that links to product table
TestDate: Testing date
XXXXX1 : Test value
.
XXXXXn: Test value
Eg.
Ticket No---------Product_ID ---------TestDate-----Rugosity---------Diameter---------WL
1005---------F102------------------08/1/2000---------5------------------7------------------5
1006---------F102------------------08/1/2000---------6------------------7------------------5.5
1007---------F102------------------08/2/2000---------5------------------7------------------5
1. How I can get specification value of the product. The specification has constraint that the effective date <= test date and it must be up to date specification.
2. How I can calculate min, avg, max value of ticket no 1005, 1006 and 1007
My designed report is
.
Product ID:
Product Name: Bead wire02
Production date: 07/25/2000 07/27/2000
Number of product = 3
------------------------------------Test result----------------------------Specification
ITEMS--------------Min---------Avg---------Max-------------Min---------Avg---------Max
Rugosity-------------5---------5.33---------6------------------3------------5-------------7
Diameter-----------7----------7------------7------------------ 5------------7------------10
WL-------------------5---------5.16---------5.5----------------2-----------5--------------7
.
I can code in VB to show on listview control but I cant do it in Crystal report.. what I can do
I would like to use parameter fields but it has a lot of fields (about 10-17 analysis in specification)
Using Formula Field Crystal Report 8.5
hi all
i want to use forumula fied in Crystal report 8.5 and i also want to use condition in formula field
any one help me
thanx in Advance
Farhaj Qazi
Sum A Formula Field At Crystal Report
Hi Dear Programmer
How are you all. I am facing a problem, that is summesion of a formula field. Here are the details
I have a database of MS access format. First I got two time there. By calculating the time I got the different. The calculation is done at Crystal Report. Now I need the sum of that field. But I can't do it by CR. Anybody here to help me by giving the formula code or other process. I try with Sub total command but failed. Giving a sample attachment.
Thanks.
Mamun
Crystal Report- Suppression Formula
i have a Crystal report which supresses the page footer section based on some condtion.I want to include a condition to supress the PF if its the Last Page.The problem is the Page numbers are reset based on group and hence i cannot use TotalPageCount to achieve this.I calculated the total number of pages manually but not able to use "Maximum" function on this formula filed.
i cannot use ON LAST RECORD) because the data based on LAst record prints on more than one page , hence if used supresses last few pages matching the LAST Record rather than supressing only the Last page
Please anyone help , its very urgent
Formula Editor In Crystal Report
How do I set the format in my formulas link editor
My field is numeric. In my formula editor I want to set the field value to string within a format.
for eg
the field value is 6
I want to set formula value to :
Tablename.fieldname = format(tableName.FiledName,"000")
I get an error here
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
How To Use Formula Functions In Crystal Report ??
Dear Friends,
I'm very much new to crystal Reports.So I dont know how to generate a report from more then one table. To generate a report i just use the formula field. But i dont know how to use the functions & formulas given in that formula field.So anybody can u you help to generate a reort.
This is my doubt
I have 3 tables like SalaryMst,SalaryTrn & Employee
1)In this salarymst have the fields like EmpCode,Basic & Mode of pay.Mode of payment either Cash or bank.
2)SalaryTrn has the filelds like EmpCode,Gross,Net & Month &year.
3)Employee as usual it has EmpCode & other Employee Details
Now i want to generate a consolidated salary report.For that i want to calculate how much amount go for the cash & bank & also i want to calculate the total of cash & bank
i dont know how to use the formula fields ..
help required....
pls help me.....
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 Formula: Length
Hi.
I am a novice virtual basic programmer. Right now, I am doing a formula for crystral reports. I'm using it to print names and lastnames from a recordset from my database. However, I have a problem. Currently, for the last name, I use the formula
Code:UpperCase ({report_definition.Lastname})
Some people in my database has about 19 letters in her last name. I need to write something similar to
Code:
If Len(Text16) >= 12 Then
Printer.Font.Size = 10
End If
If Len(Text16) >= 16 Then
Printer.Font.Size = 8
End If
If Len(Text16) >= 19 Then
Printer.Font.Size = 7
End If
Could someone translate it to a crystal formula for me?
Also, I need to insert a constant that I can put in the crystal report; eg. expires. Right now, I'm using ttx as my database for my crystal report. How can I let vb pass on the information (expiry date) to add to my crystal report?
I'm using this to transfer my whole database into the crystal report.
Code:
crystalReport.Database.SetDataSource stuDents
Thanks in advanced!
Passing Crystal Report Formula By Using Vb
had anyone has got idea how to passthrough the formual fields in crystalreport by using vb forms..
what i mean is
I want to carry the some values (forumla) from cr1 to put in cr2 report to make calculations with some value fields in cr2 and calculate the accumulated fields by using vb...
thanks
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 Sort Formula Field!
Please find attached a screen shot of my report....
I'd like to sort this report by the percentage column that i've circled in red. Is there a way to do this????
This value in red is obtained as a formula field
% answered wrongly(RED) = {#RTotal0} % (Count ({Consolidated_Audit_Questions.SubectID}, {Consolidated_Audit_Questions.SubectID}))
Rtotal0 = No of times answered wrongly
PLEASE HELP!!!
I'm using Crystal reports.NET
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
[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
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
Month Matching At Crystal Report Formula
Hi,
I want to use the formula with the crystal report.
I am using
CrysRpt1.SelectionFormula = "{format(paid_sal.Paid_date,""mm/yyyy"")}>= '" & Format(dtpfrom, "mm/yyyy") & "'"
This is giving errors of unknown field. How can I pass the SQL query with the month-year matching?
Regards
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.
Pass A Value To Crystal Report 8
Hi,
This is a question regarding Crystal Report 8
i) There's a vb form with a textbox. User would input, say "ABC" in the textbox. Then, I want to pass the "ABC" into my Crystal Report details field.
Eg:
User only have to input the "ABC" once while the name would be retrieve from the database.
Report generated:
Name Class
Alex ABC
James ABC
Sandy ABC
Can somebody help ?
Pls advice and thanks in advance
pcPirate
Pass Value To Crystal Report
hi,
i've have a table (Access 97) that contain customer information and i need to display certain customer details.
in VB 6.0 form, a text box that allow me to type a customer code and a command button that use to show the report(crystal report 9)
how i pass the text box value to the report when i click the command button ?????? plz help................
thanks
How To Set Crystal Report Formula Through Window Based Vb.net Application
Development Environment: VB.Net, Crystal Report8.0, SQL Server
I want to know how to pass a value in the formula field of crystal report while working with window based application in vb.net.
syntax: AxCrystalReport1.set_formulas(index as short,px as string)
How to define px?
Thanks & Regards,
Yachna
Pass Value From Vb Form To Crystal Report 9
Hi folks,
My apology if I have posted this in a wrong forum, which may be appropriately moved.
My post is this, I have a form in VB which allows the user to select a region from the combo. Based on the region selected the crystal report should display records [Acs 2003] for that relevant region. Iam just testing waters in CR so please be kind enough post the code & steps how to perform it or better a sample proj. I know there are somethings like parameterfield, formula field, variables in CR but I donot know how to use them.
Thanks in advance.
How Do I Pass A Crystal Report As Argument?
Im trying to pass a report to a function. If I define the argument as being CRAXDRT.Report none of the objects I have on my form are referenced anymore. Using Variant or Object does not work either. I can't actually use the name of the report either. Here's what I want to do:
VB Code:
Private Sub OneSub (param as Integer) Dim InvM1 as MyCRReport1Dim InvM2 as MyCRReport2Dim InvM3 as MyCRReport3 Select Case paramCase 0Call MyFunction(InvM1)Case 2Call MyFunction(InvM2)Case 3Call MyFunction(InvM3)End SelectEnd Sub Public Function MyFunction(InvMReport As ??) End Function
Any idea?
To Pass Parameter From Vb6 To Crystal Report
Hello Friends,
My problem is I want to accept value from user which I am nt storing in databasse. I am using inputbox to get value from user and then I want to print the same value in the crystal report. I am not using crystal report viewer, but I've used crstyal report's ocx and from there i am opening report by using printreport method of the crystal report's ocx control. plz help me.
below is my code which i m using to print report
VB Code:
With crStudList .Connect = strConn .ReportFileName = App.Path & "
eportsStudentList.rpt" .ReportTitle = "Student List" .WindowTitle = "Student List" '.SelectionFormula = "{tblStudent.RegistrationDate}>= DateValue (" & dtpFrom.Value & ") and {tblStudent.RegistrationDate}<= DateValue(" & dtpTo.Value & ")" .SelectionFormula = "{tblStudent.RegistrationDate}>=#" & Format(dStartDate, "dd/MM/yyyy") & "# and {tblStudent.RegistrationDate}<=#" & dEndDate & "#" .Destination = crptToPrinter .PrintReport End With
where crStudList the name of ocx control of crystal report
thanks
Pass Two Recordsets To Crystal Report
I have my code working fine for one ADO recordset, but I added
another query to the report and now I need to pass a second
recordset to the report before it gets created in vb. Here is my
code for one recordset. I thought if I changed the parameters I
could pass the second one but it didn't work.
VB Code:
oReport.Database.SetDataSource oRs1, 3, 1oReport.Database.SetDataSource oRs2, 3, 2
The second parameter of 3 is the datatag and the third is the tablenumber.
Any ideas on what I am doing wrong?
Thanks in advance for any assistance.
How I Can Pass ADO RecordSet To Crystal Report?
How I Can Pass ADO RecordSet to Crystal report?
IHave Crystal Report. Now I Want To Set Recordset as datasource, so I can put the records in crystal report which is in my record set? Please Give Me Brief example
How VB Pass Parameter To Crystal Report
how to pass Parameter to Seagate Crystal report by VB?
I want to pass One or More parameter to Crystal report to meet a certain critera
like i want to select some record by my application given date so report should be contains only those record sort by given date.
Fwd: How To Pass ADO Recordset To Crystal Report 7.2
---------Forwarded message---------
Date : Mon 04 Aug 10:40:24 2003
From : syed
Subject : How to Pass ADO Recordset to Crystal Report 7.2
Dear Friends
i am having problem with Hindi data. in the hindi data contains single qoutes in the string. so i was replace the string to "---" and when i am retriving this into vb again i convert into single quoutes through replace command in vb. but there is no facility in crystal report 7.2 for find andreplace the string through formula. so please suggest me its very urjent.
otherwise if i can pass ADO recordset to crystal report is there is possible then please tell me how it could be possible please
syed
|
TRACKER
