Visual Basic :: Crstal Reports

Crstal Report 8.5 Problem
hi all,

i try to create a report which will only display the records i need. but it doesn't work. can someone help me.. thanks. below is my coding

Dim Report As New CrystalReport1

Private Sub Form_Load()

Dim rst As ADODB.Recordset

Set rst = New ADODB.Recordset

rst.Open "Select * from details where details.Status = 'Active'", "DSN=SubCon", adOpenStatic, adLockOptimistic

Report.Database.SetDataSource rst
Report.DiscardSavedData
CRViewer1.ReportSource = Report
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)
Set Report = Nothing
End Sub

Crstal Report Field Format
hi,
i have a long type field in my database i place it in my report i want to chage its format how can i do it. for exapmle
my field value is 65, i want that it would show that 00065. ???

thanks

Crstal - Returning Filds From A Report
How can I extract a list of the fields from a Crystal Report so the appear say in a list box so that a user could select only the ones heshe wishes to see in there custom report. thanks

Crstal Report Access Password
How do i call Cystal Report report using vb when my Microsoft Access 2000 db has password protect on it?

Crstal Repor Arabic Text And VB 6.0
Hi,
I have a crystal report in which i use a textbox with arabic text and when i tried to run that that report in crystal report 8.0 it shows me the arabic but when i tried to run that report thru vb 6.0 it shows the arabic text in un-readable shape.

Any idea how i can solve this problem

Thanks in advance

Import Data From Excel To Crstal Report ?
Hello friends

I have a huge data in my excel sheet.I want to display data from excel sheet to Cryatal report.
Basically,I want to import excel data in to seagate cryatal report.

I have tried Sql/Odbc option in the segate cryatal report but it is asking to choose Sql table.

so this option doesn't working.

In the seconf option of Data File, when i choose the excel file, I received the dll error.

Is there anybody knows about this.Please send ther solution on this if exists.

Thanks & Regs

PPCC

Crstal Report Connect With Oracle Problem
I am using Oracle 8.0.6.0.0 as my database, when I connect the crystal report through ODBC or OLE DB, I was successful to connect, however, I can't see all of the tables in the "Database Expert". I have over 30K tables in my database. Can someone help me?? Thank you!!

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

In Crystal Reports, How To Display Financial Reports (P & L, Balance Sheet Etc.) In Columnar Format
Dear All,

I am developing a Financial application using VB6, MS-Access & Crystal Reports 8.5. I am facing problems in certain reports. Some of the reports like Profit & Loss and Balance Sheet require the output to be printed in columnar format.

I have tried giving subreports for each section, i.e.; Assets & Liabilities, but then, the output is not coming in order as per the groups. The problem is even more where there are sub-sections in the right side column & left side column for example in Profit & Loss, where there are sub-sections for Gross Profit/Loss and Net Profit/Loss. In such cases, how to bring the total amount fields at the same horizontal level.
I hope someone can help me how to do the above.

Thanks in advance.

Best Regards
Mahesh

Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I have several reports that were designed in Crystal Reports that have the DB location changed during runtime. When I move my database, or choose another copy of the DB that has a lot of records in it, my reports don't fire. I need to be able to Verify the database during runtime. I'm usiung VB6.0 and CrystalReports8.5 I've tried using Crystal's "Verify On Every Print" function, but I haven't had any luck. Here is the code I am using.

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

Also, does anyone know if changing the DataFiles location during runtime also effects the subreports. I don't think it does, but any input would be appreciative.

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

Crystal Reports - Upgraded To 8.5, Now Reports Written In 8.0 Wont't Work!!!
My reports are crashing when I run them on a machine with CR8.5, but they work fine on cr8.0. They crash inside the .DiscardSavedData Routine.

Does anyone know why or what I can do...

I call the report.Printout routine and right after I call the
.DiscardSavedData. The report is still printing out in debug mode.

Please help. Is my syntax wrong. The help file says I can only use Printout and DislcardSavedData in "formatting idle" mode. I don't know what this this???? The .PrintOut routine works but not the discardsaveddata.

Thanks,

Any help is appreciated.

M

How To Use Crystal Reports To Make The Dynamic Reports?(I Can't Use The Design Expert To D
  How to use Crystal Reports to make the dynamic reports?(I can't use the design expert to design the report,because the data source with different fields is unknown in design time.)
     Hello all!
     I use the dynamic generating MS Access table as the Data Source of Crystal Report.
How to use the Crystal Reports to display the data of the dynamic generating MS Access table?
     Thanks All!
                                                    China

Edited by - dehuiworkroom@hotmail.com on 12/17/2003 9:37:59 PM

Change The Database Location In Crystal Reports Sub Reports From VB During Runtime
I've created a Report Viewer that displays Crystal Reports 8.5 reports. I have the DB location in Crystal Reports changed during runtime, but I can't get the location to change in the subreports at runtime as well. Also, by using my method of calling the reports, I can't get VB to pass any parameters to the Main report. Below is the code that I am using. I'm using VB 6.0 and CR 8.5

Dim MyNewKey
MyNewKey = Who.Text

' On Error GoTo KeepGoing

MyLocation = GetStringValue("HKEY_LOCAL_MACHINESoftwareAptCom", "AptCom DB Path")
strReportFile = "c:aptcom
eports eninfo.rpt"

Set CRReport = New CRAXDRT.Report
Set CrxApp = CreateObject("crystalruntime.application")
Set CRReport = CrxApp.OpenReport(strReportFile)
' Set CRReport.ParameterFields(0) = "ThisKey;" & MyNewKey & ";true"

' KeepGoing:

For Each dbTable In CRReport.Database.Tables
dbTable.SetLogOnInfo "", MyLocation, "", ""
dbTable.Location = MyLocation
dbTable.SetDataSource MyLocation
Next dbTable
CRReport.Database.Verify

CRReport.SQLQueryString = strSQL

frmReportViewer.Show
frmReportViewer.CRViewer1.ReportSource = CRReport
frmReportViewer.CRViewer1.ViewReport

Set CRReport = Nothing
Set CrxApp = Nothing
Set CRReport = Nothing

>>>>
I've tried using this method:

MyLocation = "C:mydatabase.mdb"
CRPE321.ReportFileName = "c:aptcom
eports eninfo.rpt"
CRPE321.DataFiles(0) = MyLocation
CRPE321.ParameterFields(0) = "ThisKey;" & Who.Text & ";true"
CRPE321.PrintReport

But, I can't get Crystal Reports to verify the database during runtime. The first way verifies the DB, but won't change the DB location of the subreports or pass parameters to the reports.

Any help would be appriciative.

Access Reports Vs Visual Basic Data Reports?
I need some help.

For the longest time - I've been using Access Reports that are printed on carbon copy bill of ladings and the like, etc. These reports print only the data that is based on one query. That one query is based on three text boxes on a form. The query searches whatever the user typed in those 3 text boxes and pulls all the records that match. If the user does not type anything in those 3 text boxes they automatically default to '*' in each of the text.

I want to do the same thing in Visual Basic. But I have a better idea for a search. I am using a DataGrid to list everything in a query and basically the user just highlights the row that he wants to choose. Then up top on the menu he clicks on whatever report he wants to print based on the record he/or she highlights. I know I've got to use DataGrid.Columns(0) as a criteria for a search and so I've finish what kind of SQL statement I'm going to use. As regards output, I'm unsure of what to use. I did try to pull up the actual Access Report I used before but that did not work because it would not recognize the DataGrid.Columns(0) command in the query.

I'm new to the Visual Basic Data Report - I don't see any tutorials anywhere.
I understand Crystal Reports are the old way of doing this but don't have a means to try that out.
At this point - in my development - I'm thinking I'd probably make a form that would have the same output with the text boxes tied to the datasource (recordsource would be the query) and then i'd print the form data only. But not sure how to do this either? Please help.

Thanks,

Stephen

Crystal Reports- I Need Help Running Reports With A Shared Database.
I am trying to figure out how to use a shared database in crystal reports. I have it set up for my application were I use: App.Path +
"databaseWMdbase.mdb" But in crystal reports it makes you use a drive name. I am trying to use the UNC but when I run it on the computer without the physical database it tells me Database not found... is there a way to set the Location of the database in the form load like you do with ADO? Any help or Ideas would be great.

I Hate Reports. Trash Crystal Reports, Access Instead?
I am creating an app which requires a copius amount of complicated reports. These reports would be an absolute breeze to do in access, simply create a query that does all the work then base the report on that. Instead of wasting time with Crystal Reports, I'd love to be able to create an access query and then run an access report based on that query from within my VB app. Now I have code that allows me to run an access report, but it seems to require that access is open on the users machine at that time. Is there any way I can achieve what I need without opening access each time ?

Export Reports Created Using Crystal Reports 8.5 To MS Excel
i would like to know if there is a way out to export reports created using Crystal reports 8.5 to MS Excel directly with out the user doing it manually, by coding in VB6.0.
If yes please give me the codes.

Crystal Reports Using ActiveX Viewer For URL Linked Reports
Hi,

We have a IIS service that broadcasts a virtual directory of reports so that they can be viewed using the crystal reports ActiveX viewer through an IE browser.

I am now trying to replicate this setup on another server, the IIS service is setup and URL's created for our reports. When they are selected the browser defaults to the Crystal Enterprise logon screen. Where do i change the settings so that the ActiveX viewer is used in the browser to view the report?

Many thanks,

Al

Retrieving Images In Crystal Reports And Data Reports
I am saving the image path in the database and retrieving it for display but the problem is when I want to print the image for that particular record when I am only saving the image path in the database.

If I embed the image in the database it increases the size of the database but can be used in the reports in a bounded image control.

If somebody can help me retrieve the image in a data report/crystal report by using the image path in the database that did be great.

Thanks,
Kamran

Grouping Records In Data Reports / Crystal Reports
Hi

I want to group records in my Data Report based on 2 particular fields. Just see the example below.

Below is the Table Structure and its values

UnitID Part Quantity
1 xx 5
1 xy 10
2 xx 5
2 xy 10

Now I want to result to show the summation of quantities based on the part only.

so the result should be

Part Quantity
xx 10
xy 20

It would be fine if someone can tell me how to do this in Crystal report/ VB data reports

Thanks
Kumaran

Want To Create Reports In Access And According To That Reports I Have To Generate PDF
Through my VB code i am reading an Excel sheet and dumn the data of Excel Sheet in MS Access table.This part is working fine now but the problem is this
according to a field name Vendor no i have to create MS Access report dynamically,what i mean to say that if i have 3 same vendor number so when i am inserting the Excel data in Access table at that time only i have to generate an Access report based at the vendor no and generate a PDF file for that Vendor no.All the procedure is in a loop becuase we have different vendor numbers so when the process of one vendor number completed code should search for the next vendor no and do the same process insert it into Access table,create access reports for that vendor number and make a PDF file for that vendor.Please some one help me out its very urgent.
Thanx in Advance

Anybody Know How To Get Crystal Reports 10 Reports Working In VB Studio 6?
It seems that there are a few posts regarding Crystal Reports 10...few from me. However there are 0 responses dealing with any really developer issues. Has anybody moved to using CR10 or are you people still using 8.5 or another version. Could you tell me what version you guys are using so that I will stop posting issues about CR10

Crystal Reports, Printing Data Reports
how do you filter records in Crystal Reports using a variable? I'm using Crystal Reports ver. 4.6.1 Why does a time field shown as mm/dd/yy when it should be hh:mm? Is there an easy way to print data reports with filtering or conditions in vb?

INVALID TLV RECORD - FOR VIEWING REPORTS WITH SUB REPORTS
Hell VB USERS,

I use VB6.0 and CR11.0. I am getting error message Invalid TLV record
while displaying the subreports. With CR 8.5 it was working perfectly
fine. Now, I migrated to CR11.0 and Not getting any error message in the
Developer PC. Only this error shows for users PC. I tried all the method
even I tried opening the sub report & giving connection object to
subreport, but still the error message. Is anyone tried....

Below is the code I used...

Set CrxReport = crxApplication.OpenReport(NPath &
"PMP06PerformancePSSR28.rpt")
CrxReport.DiscardSavedData
Set CrxSubreport =
CrxReport.OpenSubreport("PerformancePSSR061.rpt")
CrxSubreport.FormulaFields.GetItemByName("MONTHS"). Text
= Val(MMONTHS)
CrxReport.VerifyOnEveryPrint = True
If MLEVEL = 5 Then CrxReport.RecordSelectionFormula
= "{SALESMAN.LOGIN NAME}='" & STRWHERE2 & "'"
If MLEVEL <> 5 Then CrxReport.RecordSelectionFormula =
"{SALESMAN.Login Name}='" & STRWHERE2 & "'"
' Passing connection info to Sub Report
Set connectioninfo1 =
CrxReport.Database.Tables(1).ConnectionProperties
connectioninfo1.Item("Provider") = "SQLOLEDB"
connectioninfo1.Item("Data Source") = "servername"
connectioninfo1.Item("Initial Catalog") =
"databasename"
connectioninfo1.Item("Integrated Security") =
False
connectioninfo1.Item("User Id") = "ABCD"
connectioninfo1.Item("Password") = "ABCD"

'Psssing connection ifno to Main Report....
Set connectioninfo =
CrxReport.Database.Tables(1).ConnectionProperties
connectioninfo.Item("Provider") = "SQLOLEDB"
connectioninfo.Item("Data Source") = "servername"
connectioninfo.Item("Initial Catalog") = "database"
connectioninfo.Item("Integrated Security") = False
connectioninfo.Item("User Id") = "ABCD"
connectioninfo.Item("Password") = "ABCD"

Awaiting for the correct code or any suggetions.

Regards
Arun

Problem Accessing Reports In Crystal Reports 9.0 From VB
Hi.  I use the following code in a number of VB apps to execute Crystal Reports.  It has worked fine with CR 7.0 and CR 8.0.  Now, with upgrade to 9.0, code will not work.  Error message is "Unable to load report".

I've played around with some of the references and componenets for 9.0, but haven't had any success.  Anyone encountering same problem?  Any workaround without incorporating the crystal viewer?  Any help would be greatly appreciated.

Thanks.  TM.

-------------------------------------------------
Public Sub PrintCrystalReport(CrystalReport As Object, _
                              Optional ReportName As String, _
                              Optional criteria As String)
On Error GoTo problems
    Dim i As Integer
    Dim n As Integer
    Dim a As Integer
    Dim response As Integer

    With CrystalReport
       .Connect = "DSN=" & strCurrentServer & ";UID = crystalreports;PWD=crystalreports;DSQ=" & strCurrentDatabase
       .ReportFileName = App.Path & "Reports" & ReportName
       For i = 0 To .GetNSubreports - 1
            .SubreportToChange = .GetNthSubreportName(i)
            .Connect = "DSN = " & strCurrentServer & ";UID = crystalreports;PWD =crystalreports;DSQ = " & strCurrentDatabase & ""
       Next
       .SelectionFormula = criteria
       .WindowState = crptMaximized
       response = MsgBox("Would you like this report sent to the printer?", vbYesNo, "Send Report To Printer")
       .PrinterSelect
       If response = vbYes Then
          .Destination = crptToPrinter  'Print to the Screen
       Else
          .Destination = crptToWindow    'Print to the window
       End If
       .Action = 1
    End With
    Exit Sub
problems:
    MsgBox "There was an error trying to print this report.", vbCritical, "CRYSTAL REPORT ERROR"
    MsgBox Err.Description
End Sub

Problem With Crystal Reports 8.5 Chart Reports
Hi All,

I had a problem with crystal reports 8.5 chart reports.
Iam using chart reports and included in the setup. The application shows all other reports except the chart reports.
Can anyone help me in solving this problem.
Are there any specific dlls to be included into the setup for crystal report chart graphs?

Thanls & Regards
Osman

Crystal Reports : Page Total In Sub-Reports
I have Main-Report like this
The columns 1-3 are Sub-Report(1), Column 4 is Sub-Report(2) and Column 5 is field of Main Report only.

-------------------------------------------------------
(1)......(2).........(3)............(4)............(5)
Sl.No. Name Gross(Nov) Gross(Oct) Difference
-------------------------------------------------------
1........Mary........2300.......2200......

2........John........1500.......1400......

3........Jim.........1000.......1200......

4........Mike........3000.......3200......

.. ..... .... ....

10.......Rosy.......4000.......4500......

-----------------------------------------
Total C/F Rs. .......???........???........
-----------------------------------------

I want the Difference Amount of Column(3) and Column(4)for every Record. How to achieve this?

At the same time I also want the Page Total of Column(3) and (4)at the page footer of Main Report(not the Grand Total).

View Reports Made By Crystal Reports
Hi Dear Friends,
I am using Crystal Reports 9.0. I want to view the reports from Visual Basic. But it is giving error. Say my database name is internship.mdb. My report file name is report.
I bring a control to my form named Crystal Report Control, (Need any more?). I set the database name the property of the control and everything. But it is still giving error.
I write the code behind the button "cmdreport" "report.action=1" (This works in CR 5.0).
But giving error "Unable to load report". Any body can help me.

Thanks,

Mamun

Crystal Reports..opening Reports Runtime
hi
I want to know is there anyway where i can make a query and attach that recodset to the report .I dont know much about ttx and would like to write the code with opening a crystal report application.
I have just added a reference of Reports dll and dont want to use Crystal Report control in the project.
I have made report with ADO option.
hopefully someone helps me in this direction
Thnaking you

Reports With Only Access 2000 & Crystal Reports Without VB?
Hi,

I have not had a chance to read Crystal reports literature and I have never used it but I will ask anyway . Is it possible to create reports using only Access 2000 (as the database) and Crystal Reports (8.5) without the use of Visual Basic (6.0)? If so how and does anyone have a sample code?

Displaying Reports Dynamically With Crystal Reports 8
I've made an upgrade from CR 7 to CR 8 and as i tried my programms an error message occured. Here's the code:

public Function bOpenReport(CRVwr as CRViewer,as string, Report as string) as Boolean
on error GoTo bOpenReport_Err

set m_appTheApp = nothing
set m_appTheApp = new CRAXDRT.Application

Debug.print ReportName
set m_rpt = m_appTheApp.OpenReport(ReportName)
set m_vntRptPk = new ReportSourceRouter
m_vntRptPk.AddReport m_rpt
set m_rpt = nothing
CRVwr.ReportSource = m_vntRptPk 'Connect Control with Report

CRVwr.DisplayGroupTree = false
CRVwr.DisplayToolbar = false

CRVwr.ViewReport 'Display Control
bOpenReport = true
Exit Function
bOpenReport_Err:
Select Case Err.Number
Case -2147206452 'Datei ist schon geöffnet
CRVwr.Refresh

Case else
MsgBox Err.Description & vbCrLf & Err.Number
End Select
bOpenReport = false
End Function

With this code i could display different reports dynamically during runtime. Now with the now CRViewer Control of CR 8 the error message "Memory full" occured. After calling this function bOpenReport i have following line of code:

crvReportManager.ShowLastPage 'Show the last page of the current report in the CRViewer control

After this it reloads the report as it should do in bOpenReport without printing a error message.
But if i delete the line crvwr.showreport

in the bOpenReport function my program crashed.
Does anyone have an idea how the CR 8 CRViewer-Control displays reports dynamically?

Akademos

Invoking Active Reports(data Reports) From ASP
Hi,
I want to invoke the Active Reports(Data Reports) from my ASP Page.The

Active Reports are created in VB.Also I want to print the Reports from

my ASP Page.If anybody already done this job,Can you help me with the

Sample Code?The reports are working in VB Client.
The reports should stored in the IIS Web server M/c.I need to execute

reports from my ASP page and also I need to print the report output.

Thanks,
Palani.

Do Dynamic Reports With Vb Vs Crystal Reports
I'm interesting to do one dynamic report based on change their information along the time. It depends on the selected items... then If I select more items, the report must show more subreports. Each one of them contain the information of item selected.

Any code idea to begin ? ?... I'm coding with vb and crystal reports.
I appreciate your help.
Have a nice day.

Scheduling Reports (Crystal Reports 9 Or 10)
I have a report that I did using CR which connects to a SQL Databse via ODBC. I need it to run every day at 6:00 am and email a person. The query on the report also has to show all data from the last 24hours. Can someone please help me in the right direction??

Crystal Reports Vs Access Reports
I do not know a lot about Crystal Reports but I was wondering what some of the advantages may be for using Crystal Reports over the report feature in Access to create my reports from my Access database? Thanks!

Printing Reports From VB 6 Using Crystal Reports
I have delveloped an application for invoice generation and printing.
I have 2 tables(MS ACCESS), first will store invoice details and the second will store item details of invoice like serial no, description, qty, rate and value.
for a given invoice there will be 4-5 items.

In the crystal report(ver 7), I have linked first table containing invoice details with the second table containing invoice item details.

The item details are printed in the detail structure part of crystal report.

The problem is when I print the report, the report generates individual invoice for each item rather than one invoice for all the items.

I wish someone could rectify this error and enable me to implement the software

Regards

NSNRao

Reports In Crystal Reports, Access And VB???
Hi All,

I want to know the difference between reports in crystal-reports, Access and VB. I know that crystal reports give maximum flexibility but how to justify that which one to use?? If I'm having reports in Access then do every client machine require Access installed to run the report ??? What happens when scenario is for VB or crystal reports ?? Does anyone know about online document to read about this more ??

Thanks

Edited by - cocacola on 6/9/2004 2:03:26 PM

Refreshing Reports With Crystal Reports
I am trying to use Crystal reports that ships with VB6. I can't find much information on how to use the different methods available. I created the report and it looks fine but when I change the data that the report is based on. The report does not show the current data it only shows the data that existed when I initially created the report.

If I use the Refresh button then the data is refreshed and shows correctly. How do I get the report to refresh prior to printing? Or is there a correct way to do the coding to ensure that the data being displayed is the most correct?

Cross Tab Reports In Crystal Reports
The problem is I'm using cross tab reports. I am not able to place the fields where I want to.

When I created a basic cross tab, the fields are placed in the report header section. Now, when I insert a formula field in the report header section, it does'nt work. when I place it in the details section, it does'nt show proper results either. where do we insert formula fields in a cross tab report?

thanks

Srikanth

Active Reports-Sub Reports->how To Use Sub Reports
hi friends
i am new to active reports.
i want to make use of sub reports

i mean if i have following tables

In a one report i want to view its sub contests

example
Contract details as a Master
and its labor details and salary details as childrens

if u know any links let me know

plz reply
help me oue

Reports Reports Reports....and Email
This is my nightmare. I'm using the new Viewpro control to create, preview and print reports. I've been able to export the file to a WMF and Then covert it to a jpg in order to email the report directly from my form using the Mappi Controls.
My target user however tells me that most of their customers use content filtering software that prohibits them from receiving picture files via email. They now request that my report prints as a PDF file that automatically attach to my email. I have no idea how I'm going to do that.

Or is there any other cool way of doing reports that can be email directly from VB6 application

Crystal Reports 8: 2 Reports In One?
Hi again all,

I'm trying to essentially merge two reports in to one while keeping the format of both. For the report, there is a "Detail" report and a "Summary" report. The customer has requested that both of these reports display on the same print report. So, logically thinking, I need for it to generate the "Detail" report, then immidiately after, generate the "Summary" report, but all from the same .rpt file. Anyone have any ideas?

Crstal Reports

Hi, IS there a feature to edit records in a database through Crystal Reports in any of the latest versions of cr.I should edit record/s in Crystal Reports and it should be updated in the backend of whatever database I'm using in creating that report

Hi,
IS there a feature to edit records in a database through Crystal Reports in any of the latest versions of cr.

I should edit record/s in Crystal Reports and it should be updated in the backend of whatever database I'm using in creating that report