Find Field Parameters In Crystal Reports Using VB
I have a query that returns 800 reports and I want to find the fields associated with each of those reports. How should I go about coding this into vb?
Set return = store.query("SELECT SI_NAME, SI_ID, SI_FILEs, SI_PROGID FROM CI_InfoObjects WHERE (SI_PROGID = 'crystalenterprise.report')")
if return.count > 0 then
For each item in return
objexcel.cells(i, 1).value = item.id
objexcel.cells(i, 2).value = item.title
I have returned the ID and Title, so now how do i get every field? Please Help!
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Crystal Reports Parameters
Hi All,
I know that you can use parameters to filter the records in Crystal Reports but is there a way to use a parameter for an ORDER BY statement?
Crystal Reports Parameters
I have 4 tables containing records which can be linked by a common identifier ("WU_id"). I have a form which the user can enter data specific to any one of those records.
I am attempting to build a Crystal report which will run for only that specific "WU_id" for which the user is interested (which-ever "WU_id" the user is currently updating on the form).
How do I call on a Crystal Report involving data from multiple tables limited to one specific identifier?
Ugh...
Crystal Reports Parameters
I have a crystal report that is called from a vb app using stored procedures in SQL Server 7.0. When I call the report I get a tabulated form asking me for values for these parameters. How can I pass them from the form without being prompted? I tried using:
grptreport1.ParameterFields(1) = _
"@vcCompanyCode;gstrCompanyCode;True"
grptreport1.ParameterFields(2) = _
"@iRMAnumber;gstrRMAnumber;True"
but I get an error saying "Object doesn't support this property or method". Any ideas?
Parameters In Crystal Reports
Hi, all
I use the crystal report with VB 6 and I have one report with 3 subreports.
Each band works with a stored procedure.
The stored procedures haves the follow parameters:
Subreport 1 - SPU_STATEMENT1 1122 <<<<< Just one parameter
Subreport 2 - SPU_STATEMENT2 1122, '12/31/2005' <<<<< Two parameters, one integer and one date
Subreport 3 - SPU_STATEMENT3 1122 <<<<< Just one parameter
Now, I need the VB 6 application suply these parameters to the report, when I click in one button.
How do I make this?
Thanks since now,
Alex
Using Parameters In Crystal Reports
Hi!
I' m not very familiar with crystal reports, and this may seem very stupid to you, but how can I use parameters to display a report that counts and summarises some data in a table and show only those that match a specific date interval.With data report I managed to do this but now I need to do it with crystal reports. There is a field in the table that contains the date on wich the record was updated but i can't use this in the report since it contains a cross-tab filled with numbers.
Thanks for the reply!
Crystal Reports With Parameters
How can i create a crystal report with stored procdure (SQL) having numaric, string(varchar), and datetime parameters.
And after creating this report how can i call this report from Visual Basic 6.0 by passing parameters dinamically.
e.g Procedure is consist of three parameters, (i) int, varchar(8), datetime etc
Please help me...
Thank you
Crystal Reports Parameters...
I have a Stored Procedure which I am using for my database for Crystal Reports. Which I am calling from my visual basic application. Lets say that I have 4 parameters and I only need to use 1, 2, 3, or maybe all 4 of them. How can I pass 2 out of the 4 parameters without having the parameter messagebox open up to the end user?
John-
Passing Parameters To Crystal Reports
Hi guys..hope you can help with this one.
My interface is basically a bunch of checkboxes. The user selects the ones he/she wants to see in a report. Does anyone know, how can I pass the selected items to Crystal Reports?
Send Parameters To Crystal Reports From Vb6
hello
i want to send values to the parameters in crystal reports 9 from vb,can any one help me with the code.
i tried the following code:
VB Code:
Dim Report As ais_billreportDim PARAM As CRAXDRT.ParameterFieldDefinitionDim PARAMS As CRAXDRT.ParameterFieldDefinitions Set Report = New ais_billreport' Report.Database.Tables(1).SetLogOnInfo "", "aiswaria.mdb", "", ""' Set PARAMS = Report.ParameterFields' For Each PARAM In PARAMS' With PARAM' Select Case .ParameterFieldName' Case "frmbillno"' .SetCurrentValue FROMBILLNO' Case "tobillno"' .SetCurrentValue TOBILLNO' End Select' End With' Next' frm_report.CRViewer91.ReportSource = Report
\\\\\
i get error in
Set PARAMS = Report.ParameterFields
plse help me
Thanks in advance
Crystal Reports And VB Question (parameters)
I have a report that is run and saved with
data.. I am trying to access the values of
the reports parameters using VB.. but when I
cycle through the parameters in the report..
all the values of them are blank.. but if I
open the RPT file in crystal and click the
refresh button, it asks if I want to enter
new values or use the current parameter
values.. so I know the report still has
those values in it.
also the .IsCurrentValueSet = true for the parameter... so I should be able to get its value...
Crystal Reports 'Incorrect Log On Parameters'
Hello,
I am running version 4 of crystal reports (which came with VB). I've been successful in using the following code to preview a crystal report based off a table, but for some reason when the report is based on a query I get the run-time error '20536'. Error reads unable to connect: "Incorrect log on parameters"
'Report selection.
ValWtchrpt.ReportFileName = REPORTS_PATH & "valwtch.RPT"
'Selection criteria.
ValWtchrpt.SelectionFormula = ""
'Create report.
ValWtchrpt.Action = 1
ValWtchrpt is the name of the control and valwtch.RPT is the report.
Appreciate any help. My reports are all done. I just need to be able to preview/print from VB. Thanks.
Send Parameters To Crystal Reports
how can i send parameters to crystal report via vb.
i don't mean formula , i mean to keep an empty label in the report and trou the vb write somthing there.
like writing some details about the report.
Passing Parameters To Crystal Reports 6
Hi again!
I want to find out how to pass parameters to Crystal Reports from a SQL database through VB 6. I am doing reports for my app and I need to know where to begin.
Sample code would be great if you have it. Thanks in advance for your help.
Pass Parameters To Crystal Reports?
Hi,
I'm using Visual Basic 6.0 and Seagate Crystal Reports 8. I want to view a report called from Visual Basic. The report is made in Crystal Reports and has some parameters. Now, my question is: How can I pass parameters through Visual Basic to call my report.
Second problem: I open my report in the ActiveX viewer an I get the first page from my report. If I try to refresh my parameters, or if I try to go to the second page, I get the error : "Server has not yet been opened".
Please, need urgent help, desperate!!
Thanks very much,
Billy.
[Edited by Billy on 11-27-2000 at 02:46 AM]
Parameters Are Not Being Passed To Crystal Reports
refer to FAQ222-2067 posted on the 20th of June 02.
I still maintain that I need to know how to pass the value of a parameter to crystal reports.
I have a stored procedure in sql server 7.0 and created a parameter collection to create the required parameter in Visual Basic 6.0 environment, but if I may ask does the code below store my output?
if yes, how do I now pass prmOutput to crystal reports?
what code snippet will do the job please?
Set prmOutput = .CreateParameter("@cname", adVarWChar, adParamOutput, 255)
Help Using Crystal Reports And Sending Parameters
I am using VB6 and Crystal Reports 4.6
Does anybody know how to send parameters to a parameter query report created in Crystal Reports using VB?
I wish to know the syntax , there are 3 parameters i wish to send each gain their values from controls on my vb form.
Thanks
VBA Passing Parameters To Crystal Reports
I have an application in VBA (Excel2000) which opens and exports a report from Crystal Reports (8.5). The Crystal has a Parameter Field which I to update from within the VBA application in Excel. Does any one know how to pass the value of a variable in VBA to the Paremeter field in Crystal
I'd appreciate any help
Thanks and regards
Michael Bond
Crystal Reports 7, Dataenvironmet, Parameters
Hi,
I have a form with a combobox, and a command in my dataenvironment which get's passed the value the user selects in the combobox.. For example the user selects apples and the command selects all records from table pies that has apples in the main ingredient field (no, this is not what my app does, just an example)...
The problem I am having is I want to write a report based on this command, but I can't figure out how to add a command to a crystal report that has a parameter.
I often feel I am parked diagonally in a parallel universe
Send Parameters To Crystal Reports
how can i send parameters to crystal report via vb.
i don't mean formula , i mean to keep an empty label in the report and trou the vb write somthing there.
like writing some details about the report.
Stop Crystal Reports Display Parameters
Dear All,
Is there a way to stop displaying the Crystal Report "Paramter" window when running the report ?
because I am passing this paramter from the VB application directly.
Many Thansk in advance.
Setting Logon Info And Parameters In SubReports For Crystal Reports
Need some help!
I have create a CR8.5 report that has two embedded subreports which are not linked to the main report. When calling the main report from VB6 I set the logon info and parameters. However I am unsure of how to set the logon info and parameters for the two subreports. All reports are based on Stored Procedure in a MS SQL DB. Some code examples would be helpful.
Parameters Passing From Visual Basic Form To Crystal Reports
Sir
Can u suggest me some coding for passing one or more parameters from visual basic form to crystal reports
for example i have designed a application for our library in which there is a for which contains combo box in which lis if all authors is displayed
as soon as user selects an author and clicks on display
an crystal report
containg
accno/ TITLE/ SUBJECT/PUBLICATION/PRICE
should be displayed
and he should be able to take a print out
now at present i am displaying it in flexgrid
so the user has to notwe down the details of his search
sir can u suggest me some code
i am using coding connection
ie din db as new adodb.connection
so i request u for help
The Field Is Not Known With Crystal Reports 10
I have integrated a crystal report (v10) vs visual basic.
My report has one subreport... I have linked this one with the report main. The first time I execute the report is ok. All information attached is displayed sucessfully. However, if I execute it again with the same or different data (filter with combo boxes) crystal reports shows me the next error: 'The field is not known' associated with CRViewer1.ViewReport method
Do you have any idea about this error?
Any suggestion will be appreciated.
Thanks
Crystal Reports Formula Field
Hi
I got a database column which has number values like
480, 495 , 615, 630
which is equivalent to
480 = 8am (which is like 480/60=8)
495 = 8.15am
615 = 10.00am
630 = 10.15 am
i get this values from ctDEdit control, which gives numbers for time.
Now i have to show this number values as time in crystal reports. so i thought of having a formula field.
its easy to get hours and minutes from this number:
its goes like this
(615/60)=10.25
so 10 is hours
(25*60)=1500, here 15 is minutes.
can any one please help me to do this in a formula field, ie to show the time as 10.15am for number 615.
i hope im clear.
thanks
kumaarrv
Hide Field With Crystal Reports
How do I do if I want to hide a specific field in a report.
I'm going to use my own parameterized queries so I will be able to send boolean values to the report from the application during run-time.
The problem is how to design the report.
Do I have to group that specific field to able to hide it in the report?
Crystal Reports, Hide A Field
Hi, How can I hide a field in crystal reports 8.0 to print it only in the last page of the report, is there a way to do it without using sections?
Thanks
Long Field In Crystal Reports
I have a string selected from a database table, and it can get really long.
Is there any way to automatically wrap the string once it exceeds certain length?
Can anybody help?
Crystal Reports - Null Field
Im using the crystal reports wizard to connect to an access database. Currently the report is returing everything in my access table.
I only want it to return items with a NULL value in my field called "DATE".
Therefore IF my field called "date" has a NULL value then i want to see these records.
Does anyone know how to do this within the crystal report wizard??
Using The Parameter Field In Crystal Reports
I know how to use the parameter function in Crystal but how do I place the parameters entered on the report. I've tried pulling the parameter expression on the report but when the report is run and parameters are entered the field on the report is blank.
Crystal Reports Date/Field
I am currently using a Crystal Report (8.0) which has ADO connection to MS Access 97 database.
I have a Date/Time field (Short format) in my database which contains the date/time 1/23/03 10:43:45 AM. For some reason the Crystal report shows this as being PM not AM.
Is it because I am using a short date? Anyone...
Max Field Size In Crystal Reports
does Crystal Reports impose a maximum field size? I have a Comments field that holds 500 chars but the report only shows 256 characters.
help.
thanks in advance.
Date Field - Crystal Reports
I have a report in Crystal Reports which works fine, except in a PC. In that machine the report prints well, except the date fields that appeared in an empty way. I've worked with Regional Settings, fonts, pass the date to string, but the report doesn't work.
Have you experienced something similar? Have you any suggestion I could follow in order to solve the problem?
Thanks in advance!
Setting Field Value In Crystal Reports
Hi,
I am using a crystal repirt designer (crystal 8) in VB6 - the ICRDesigner. I have placed fields in the Details section of the report designer (a part of the VB application) but I want to assign values to these fields at runtime. Does anyone know the syntax for this. I have used
CrystalReport1.Field1.Value = rsScotiaParameter!LetterDate
but I get an error ...
please help.
Field Formatting In Crystal Reports
I have a field in a table (used in my report) that is "010422". It is a date.. but saved as a string. How do I convert this to look like: "01/04/22" on my report.
Same with time .. I have 140232.. and i want it to look like 14:02:32.
sa
OLE Object Field To Crystal Reports
Hello,
I have the Image(OLE Object field ) sitting in access 97 table, and I am using crystal reports to print out the Image.
I am linking the crystal reports to the table by the normal way(normal text field way) and it doesn't seem to work. Beacuse of OLE Object field, I wonder if there is special way to deal with it.
Thank you very much.
Crystal Reports Field Suppression
Hi all - in my report, the details section can show up to 8 fields. The fields are aligned atop each other, like so:
field1
field2
field3
field4
field5
field6
field7
field8
I suppress the fields if they are null. The problem is that the report appears very disorganized and has too much white space. I need to be able to modify the positions of the fields so that they appear consecutively. Example: if fields 2 and 5 are suppressed, I want the report's details section to show like this:
field1
field3
field4
field6
field7
field8
but instead it comes out like this:
field1
field3
field4
field6
field7
field8
and the spaces make it look horrible! How to fix this?
Autoincrement Field In Crystal Reports
i want a auto increment filed in crystal report
for ex in innoice
the format
no product
1 dwe
2 dww
the values for no filed are auto generated and for each invoice it should start from 1
Crystal Reports-field Object-
i hope to modify a file (*.rpt)-crystal reports V8.5-,I can change the textObject and the fieldobject , but if this textobject contain a fieldobject i can't read this field???
ex:
la date [?du] a [?au]->text object contain fields
then program return:la date[] a []
and i can't read {?du} {?au}!!!
Crystal Reports-Multiple Values For One Field
I have a VB6 program that contains a form that allows the user to select 3 different criteria. These criteria in turn are used by the program to pass an sql statement to the crystal report 7 object within the vb program.
The problem I am having is that I need to pull data from two different tables within the same Access database. The first table is the main table with information on machines (i.e. IPAddress, name, location, repairtime etc). The second table is linked via a generic ID number field, and contains the names of the maintenance personnel who repaired the machine. In some cases, there are several people working on one machine. I am currently using the sql statements to pull information from an Access query that combines the two tables. The problem is that if there is more than one maintenance person who repaired the machine, the query will list that record several times.
Any suggestions on how to get around this? I want all of the names to show on the report for any given ID number.
Not Able To Sum The Field In Crystal Reports 9 Formula Editor
Friends,
The below formula is not working. Please point me where iam making mistake.
=========================================
whileprintingrecords;
global numbervar tottrd;
numbervar cnttottrd;
if
(
{Admin.OTC}="001"
or
{Admin.COEN} in
["Chargeable Labour + Chargable Spares",
"Chargeable Labour + Free Spares",
"Chargeable Spares + Free Labour"]
)
then
cnttottrd := {PAYMENTS.PAIDAMT}
else
cnttottrd := 0;
tottrd := tottrd + cnttottrd
=========================================
if i change
cnttottrd := {PAYMENTS.PAIDAMT}
to
cnttottrd := 1
then its working.......
Please treat this as urgent.
Thanks & Regards
Sathyguy
|
TRACKER
