Visual Basic :: Crystal Reports Table Linking Via Field Data

Crystal Reports Table Linking Error
Hello All

I am using Visual Basic 6 and designing my Crystal Report from inside VB.
Does anyone have any idea how to do some error trapping inside crystal reports? Here is my problem. I have a table 'Sales' with a primary key value 'SaleID, and a foreign key value 'CustID'. I also have a table 'Customers' which has a primary key 'CustID'. Now inside of crystal reports I link Sales.CustID to Customers.CustID. I am using crystal reports to generate an invoice based on the data from the sales table. The problem happens when a customer record is deleted. The sales record does not get deleted because it need to stay for accounting purposes.

But the report does not finish executing and showing all its data when the linked customer record no longer exists in the customers table.

Inside my VB6 application when the customer is deleted, the sales table is updated and 'CustID' is set to -1. I need to have crystal reports capture this -1 and display a message like "N/A" in the customer field. But this is not happening. Since I have made the link between the sales table and customers table inside crystal reports, the report displays no data.

Any ideas how I can capture the -1 condition instead of having my report die on me? Thanks in advance.

Crystal Reports Problem Linking Table
Hello friends
I have a problem in linking a table to crystal report.
the database is stored in c:payrolldatabase and report in c:payroll report

The database was created in access 97 and then converted at my clients site to access2000 now i have added a new table 'lastmonthemp' to the database in access 97 and then imported it to the database in 2000. after that the table was added to a report that already had 2 tables pfsummary and companymaster which r linked by companyname the lastmonthemp table as following fields
totalemp,joinemp,leftemp these fields have been inserted into CR but it gives error of linking when previewd in CR and no data is displayed thru my prgm.
the values r inserted in table thru prgm.
any solutions.

Linking Problem In Crystal Reports
i'm creating a report which summarises content in a employee database.the summarised content is in a columnar format , with groups of columns summarising attendence, turnover and recruitment for the specified date range.

the report is grouped by dept and then by section.
i have hidden the details sections , showing only the group footers so that i can generate the summaries.

the problem is in generating the budget summaries from the budget table.most of the detail line fields are from the attendance table , which has a record each for an employee for a specific date.

employees are budgeted for each section and then within that for each employee category such as executive, staff etc.

the budget table has the following structure
BudgetYR,Jan,feb,....Dec,Section,Category

the problem is that when i include a formula or field which has anything to do with the budget file..all the data in the report goes haywire (extremely large figures).i suspect this has to do with the structure of the budget table.cos for a particular year the budget file contains approximately 300 records.

because all the fields in the report are in the same line , this poses a problem even if i put a subreport for the budget figures.there are more than 60 sections so..there is no way i can use shared varibles.

how do i get about doing this?
thanks in advance

Linking Crystal Reports To Your Application
Hi All I am new to this, you may think who is this guy can't even link a crystal report.

My problem is as follows. I have created a really good application. but it needs reports to be generated. I have Crystal reports on my system but I do not have a clue how to link them to an application.

can anyone give me a push in the right direction.

wien

Linking Crystal Reports With MSDE Backend?!?!
Hello

I am using VB 6.0 and MSDE as my database. I am also using Crystal Reports 9. I have recently changed my project database from Access 2003 to MSDE. When I had Access as my database I had my reports connecting to the database using the Access/Excel (DAO) datasource.

Since I am no longer using access this datasource does not work. I am using OLE DB inside my app to connect to the MSDE DB, but I am not sure how to connect Crystal Reports to my MSDE DB inside the CR Designer. I have looked through the avaliable Data Sources, and when I choose OLE DB(ADO) I get a list of data sources which are used with OLE DB, and I am not sure which one to use. I have tried "Microsoft OLE DB Provider for SQL Server" and "Microsoft OLE DB Simple Provider" none of which detect my MSDE instance, and thus CR is unable to connect to my MSDE DB.

Can anyone point me in the proper direction?

Thanks in advance!

Crystal Reports: Highlight Field Based On Value Of Other Field
Is this possible in Crystal Reports? I'd like to colour the values in {ado.NetWt} red where the value in {ado.LBound} > 0....a forecolor property or something?

Problem Linking Crystal Reports To Access Database Thru VB
Hey Guyz,

Wats happening?

I'm having sum problems here that i hope one of u's can solve!!!

First of all I'm using Crystal Reports V 7.0 [Way Too Pove 2 buy da new version ] and I do not have the Crviewer.dll reference either.

Now what I want to do is I have a Crystal Report file, which should print a report on the given input by the user. The database is version 2000 Access, and has 12 recordsets (12 months of the year: January thru December)

How it should work is that for each month the user specifies I want a report with the data for that month ONLY!!!

So how do i link all 12 recordsets to this one report.

Also, if you could help me with another problem:
Again 2 do with Crystal Reports. I want the Username of the user printed on the form along with the month for which the user wants to print the report for (Note: It might not be the current month!)

Can you please please please help me coz i'm stuck here and cannot move forward, and i don't have much experienc with Crystal Reports, and there is no where on the web where i can learn it PROPERLEY!!! :@

So anykind of input from u's is highly appreciated.

ThanX in Advance,

RVI

Crystal Reports: Dbase Iv Files Not Linking Properly
Guys, I have two dbf files that I want to generate a report out of in Crystal Reports 8.5. They are linked on the field: ID, both of which are same type and same length and the correct data is in there. It's a one to many relationship on the field ID. (The first table holds one unique value for ID and the second table has many IDs.) When I set up the report though, it's not giving me right information. Is there something special I have to do when using dbaseIV? I've never used CR with dbaseIV tables before...

Linking Table Fields To Crystal Report
Hi,
I would like to link the newly added/changed fields in my table to the report.

Pl advise a way to do that.

I 'm using Crystal report V 7.0 and the back end is SYBASE.

Linking Data Reports To Flexgrids As Source Data?
I need to create a report, however the data that the report needs to use resides in a disconneted recordset which is linked to a datagrid on another form. it's not stored in a table anywhere. the recordset data is generated at runtime so there is no way for me to query the data from an external table.

can I somehow link the data report to the disconnected recordset?

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

Crystal Reports Field Suppression
How do you check whether a field is suppressed or not in the formula editor?

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

Crystal Reports 4.6 - Field Justification
Hi friends,

How can I justify a text or memo field on a Crystal report ?

Thanks for any help,
Fernando.

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

Crystal Reports - Sorting A Formula Field
Hi,

I've got a formula field on my report: -

Code:
//@SumQty
Sum({SALES_VIEW.SUM_QTY}, {SALES_VIEW.AR_DESCRIPTION})
I want to sort the report using this field, but can't seem to find a way.

Is it possible to do this?

Regards

Word Wrap On Field In Vb Crystal Reports 8.5
Hi,
I'm very new to vb crystal reports 8.5 and have to generate a mailing label report where in I need to word wrap on the fields as it is creating spaces if either the database field is null and does not word wrap.

Also give some links to learn and explore vb crstal reports 8.5

Thanks a million....in advance

Using A Memo Field In An Expression In Crystal Reports
I need to use a memo field in an expression in a crystal report, but can't. I know there is some problem with memo fields, but how can I get around this?

Using A Parameter Field In Crystal Reports - Very Easy One
I am new to Crystal Reports. I need to filter a query
with a where clause. I guess I need to insert a
parameter field here. I've tried but failed a couple
of times to get that thing to use. Can someone here
walk me through the process of successfully creating
and using a parameter field in Crystal Reports. To
make it easier, let me imagine a situation where I
have a table called [My Friends] and I need to
retrieve all the friends of mine who stay in Delhi. So
I need a query something like:

select * from [My Friends] where [City] = 'Delhi'

Now I create a simple report using the Report Expert
where I select one table [My Friends] and all the
fields and I have the report in front of me, showing
all my friends and their addresses, wherever they
live. Now, I need to place this filter. Please take it
from here.

Sathyaish Chakravarthy

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!

Extension Of Details Field In Crystal Reports
hai hai hai every one

hope u all r fine

im back here to eat ur heads

ok im asking a solution from u all as

how to extend the details section of crystal reports? the problem does not ends here as i want to place a footer message in the footer section of reports. so now my problem is that footer runs for all the pages. but i wanted it ti be displayed for only the last page if the report is more then a single page.

hope u can help me

thanks

nithi

with regards Nithi

There are no such things as applied sciences, only applications of science.
- Louis Pasteur

How To Creating Hyperlink In Crystal Reports On A Field
Hi everybody,

I have a problem regarding crystal report i have to tables tblMailInfo and tblAttachments.
I have designed a main report selecting fields from tblMailInfo, the problem is that i want to create a hyperlink
on the MailID field so that when i click this field a new report opens displaying the attachements for that MailID from tblAttachments
Please help me in this problem with code if any one have.

Crystal Reports Formula Field Charting
I am not a Crystal expert, I normally would be using VB but this project requires a report written in Crystal and I have no access to VB. Any suggestions would be great.

I have a report with a field: {StartTime} that is being pulled from a subreport: ASubrpt.rpt.

I the main report I have a formula field: {RoundedTime} that rounds the time from {StartTime} in ASubrpt to the nearest minute by fives. (example 7:22 would be 7:20).

Now, I need to graph and cross tab the count of records on the change of {RoundedTime}.

Please advise. I have even tried using the Charting on Print-Time Formulas pdf from Business Objects.

If there was a way to format the StartTime field in ASubrpt to be rounded and then create the chart in the subreport then I could insert it into the main report, but I do now know if you can format the time like that w/o a formula field. And then would it even be chartable?

Thanks in advance!

URGENT: Crystal Reports And BLOB Field.
Hi guys,

its little urgent!

i wish to embedd a blob field which stores a picture in my crystal report in detail-tab. somehow its not been displayed... kindly help me for this problem.

well, all i have done is ... set up the connection for the report, and put the picture field on the report in detail tab.

plz helpppppppppppppppppppppppp

butterfly.

Daring ideas are like chessmen moved forward. They may be beaten, but they may start a winning game.

Crystal Reports 9: Formula Field Alignment
I have the following Formula Field in the detail section of a report…
If IsNull({ado.AMOUNT}) = False Then
   Formula = {ado.amount}
Else
   Formula = 0.00
End if

The Horizontal Alignment for the field is set to “Right”. For some reason when ado.AMOUNT is Null the zero value of the formula is displayed to the right but it is off by one position to the left.
See Example
AMOUNT
      $0.00
      $10.00

Anyone know why this is happen?

Formatting Date Field In Crystal Reports
I am using SQL Server as my database and I have a date/time field in the database. I am using a command object to pull information from the SQL Server database and displaying it in report form using Crystal Reports 8. My problem is that I only want the date displayed in the date field in Crystal Reports. I do not know how to format the incoming date/time to just display the date. Any help will be greatly appreciated.

Thanks,
jen_tech

Replace Database Field In Crystal Reports
I've linked the crystal report to a database, now i need some help in manipulating the database field. For example,the field consists of "P" (stands for PASS) or "F" (stands for fail) but i want to display PASS / FAIL instead of P/F ...can someone help me on this? do i need to use a formula or something? i'm very very new to crystal reports... Thankx

emails will be welcomed. pls email to this address zijing@singnet.com.sg

Data Reports Active Reports Or Crystal Reports
Hi all

I am really stuck here and i need help urgently
I have to call three tables in a row to print a single invoice entry
noe the problem is if the do it by calling single tables then there is a problem that it is nopt going to print the last order which is filled.Is there is any way it can be done through using sql command or something.
Secondly if i use max order in sql then i would not be in a position to print order after searching for it

Thanx

Need To Understand Data Reports - Heard That Crystal Reports Were Slow
I have two questions:

1.) I was going to take a step forward to learn how to use crystal reports but I heard that on a website they are viciously slow. Is that true or is there a way around that with coding?

2.) I have been using Access reports through Visual Basic 6.0 with the following code - thanks for the tremondous help of everyone on this website:

Code:
appAccess.OpenCurrentDatabase SERVER & "disp-1_be.mdb"
appAccess.DoCmd.Maximize
appAccess.DoCmd.OpenReport "oalog", acPreview
appAccess.Visible = True

The reports work great UNTIL I came accross a situation where the report is based off of the data entry of the user. oalog is a monthly report and in the query it automatically pulls the current month with the following query:

Code:
SELECT oalogallmonths.ctsbranch, Count(oalogallmonths.Amount) AS [Total Of Amount], oalogallmonths.GivebyName, oalogallmonths.United, oalogallmonths.Mayflower, oalogallmonths.Other, oalogallmonths.Tord, oalogallmonths.CURRENTDATE, oalogallmonths.Amount, oalogallmonths.Month1, oalogallmonths.ORDER
FROM months, oalogallmonths
WHERE (((months.monthID)=[oalogallmonths].[Amount]))
GROUP BY oalogallmonths.ctsbranch, oalogallmonths.GivebyName, oalogallmonths.United, oalogallmonths.Mayflower, oalogallmonths.Other, oalogallmonths.Tord, oalogallmonths.CURRENTDATE, oalogallmonths.Amount, oalogallmonths.Month1, oalogallmonths.ORDER
HAVING (((oalogallmonths.Amount)=11;

If you notice the records are pulled HAVING the 11th month in there.

If I want the user to ENTER the month I know that I must change the last line to:

Code:
HAVING (((oalogallmonths.Amount)=[ENTER MONTH]));

But a user might type January or 12/2003, etc...

so I made a combobox named ListMonth of the 12 months.
Then I made the change from:

Code:
HAVING (((oalogallmonths.Amount)=11;
to

Code:
HAVING (((oalogallmonths.Amount)=ListMonth.ListIndex + 1));

The only problem is that I keep getting a message box asking for ListMonth.ListIndex + 1.

My question is in the above code that defines appAccess.DoCmd.OpenReport "oalog"...
is there a way to change the RecordSource of the report to pull from my own query instead of the Access Query?

Thanks,
Stephen

Hide/Suppress A Field/column In Crystal Reports
Hi,

I'm working on an application that displays a report.

Code:
Dim Report As New CrystalReport

Option Explicit

Private Sub Form_Load()

Dim CRXReport As CRAXDRT.Report
Dim crxApp As CRAXDRT.Application

Screen.MousePointer = vbHourglass

Set crxApp = New CRAXDRT.Application
Set CRXReport = crxApp.OpenReport("C:Program FilesBusiness ObjectsCrystal Reports 11SamplesenReportsTCPOSArticleSales.rpt", 1)

CRViewer1.ReportSource = CRXReport
CRViewer1.ViewReport

Screen.MousePointer = vbDefault

End Sub

Private Sub Form_Resize()

CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth

End Sub

Private Sub Form_Unload(Cancel As Integer)

End

End Sub
The report I'm showing has 7 columns, the 7th I'd like to show/hide depending on the users choice.

I've looked through the help files, and on this site, but can't find an example or answer.

Is there a way through code to do this?

Regards

Crystal Reports: Slant/make Diagonal Field
Can anyone tell me if there is a way to display a field in Crystal Reports on a slant?

How To Split One Field In 2 Columns Group In Crystal Reports ?[Need Help]
hi,
i need help in crystal reports 9 .i want the following task to do in cr9.

i have one field in table which is named as allowance status which contains only 2 values , 'Addition' and 'Deduction' in it.Allowance name field depends on status field. All i want is to show this field's values grouped in horizontal position like following:

Additions Deductions

EPF Salary Advance
... ....

means Addition allowance on the left side and deduction allowance on the right only on one field.
Can any one help me in this regard ?

Thanx in Advance