Visual Basic :: In Crystal Reports, How To Display Financial Reports (P & L, Balance Sheet Etc.) In Columnar Format

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

Crystal Reports Format
i want to generate a autoincrement field in crystal reports how is it possible
ex format of report
date:
invoice no:

sno salesman productdesc tax rate qty amount

amount payable rs
thank u

here srno is the item no it is not stored in database
for each each invoice it shouls start from 1 and then
it should increment by one after each product
it is a preprinted format and how to filter it for a part invoice range
and after some products it should print in next page
because since this is preprinted if more items
is there and if it is not able to fit in same
bill then it should start priting the rest of items in next
bills (so after certain products in a invoice it should start printing in next bill) with crystal reports how is it possible using vb 6 application

Date Display In Crystal Reports
I havbe a report that needs to display fields from a database. While other fields display the date fields just show blank. Has any one a solution to this starnge beviour. I have check the date field actually has dates in the database for display

Display Crystal Reports *.rpt File
is it possible to display a crystal reports *.rpt file using the crystal reports activex control? i'd like to have the reports external to my app, cos there's quite a lot of them. failing that, would it be a good idea to have them all in a DLL?

Crystal Reports Number Format ?
Anybody know how to format a number as a percent in crystal reports? I hink I've tried everything but the right way yet.

Thanks Don

Time is the best teacher; unfortunately it kills all its students.

QuickReport (.QRP) Format To Crystal Reports
I am re-engineering an application originally developed using Delphi to Visual Basic. The reporting feature of the application was using a reporting component by the name of QuickReports.

Does anyone know if it is possible to convert a QuickReport (.QRP) to Crystal Reports format? Or of a standalone tool that would allow me to view the design of a QuickReport?

Also please note that I do not have any Delphi or QuickReport components installed on my PC.

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.

Make VB6 To Wait For Crystal Reports Display

VB6 and Crystal Reports 8.5

I am using the ActiveX control with standard print methods to display the crystal report.

i.e. XYZ.Action = 1  (to the Screen)

It works fine but I want the VB6 to wait until the users Xâ€™s out of the Screen Print display.  I then want to continue processing.

Question #1- How in the heck to I do that?

Question #2- Does anyone know if or what other Action =  codes are.  I have experimented with 2, 3, 4, 5 and the processing seems to be the same as 1.

Crystal Reports And Selecting Top 10 Records To Display?
Hi, I am stuck and starting to up holes in the walls of my office using my head only!!!!

I have started using Crystal report 9 and I am trying to create a report to show the top X number of accounts.
Why? Because I have a points report which I want to create a top X build up of points.

I say X because I want to pass that X number into the report. So it will give me back the top X number of records.
What I have done is select my data which gives me everything back. But how do you only get the top X (say 10for example) records from the data.

Am I making sense?
HELP PLEAse....

Display Arabic Data In Crystal Reports
hi,

how can i display arabic data in crystal reports?i have all the arabic enabled software installed.but,the arabic data is displayed as junk data in crystal reports.

regards,
sanjay

How To Display Data In SQL Server Using Crystal Reports Ver 4.6
Hi!
I have client-SQL server application. The client gets data from SQL Server. . I have a VB6 and Crystal Reports(CR) 4.6 . I use ADO codes and ADODC control to store data. But the CR 4.6 doesn't accept ADODC Data Control. I heard of using Crystal object. But i don't how to use it. Do you have sample program like that. Please help, I need this urgently.
Thanks

CecileR

Crystal Reports Date Format Issue
hi all, distraught, disgruntled and distressed. i really hope this is something simple and i've just been doing all kinds of crazy gymnastics because the trees were blocking my forest.

i'm creating a periodic report (dates given as params) but the data that i have to compare to the selected dates is of type 'number' on a remote as400.

i've been using string manipulations to get the date parts out and then the date conversion to put them back together to compare with the parameters. but at that point i get the error: "too many arguments have been given to this function". the month day and year formula fields are working properly...what gives?

(crystal syntax)CDate ({@TESTYR}, {@TESTMO}, {@TESTDY})@TESTYR =
Left (Right (REPLACE(REPLACE(CSTR({WRSCONV.WRDTRC}),",",""),".",""), 6), 4)@TESTMO =
IF LEN(REPLACE(REPLACE(CSTR({WRSCONV.WRDTRC}),",",""),".","")) = 9 THEN
Left (REPLACE(REPLACE(CSTR({WRSCONV.WRDTRC}),",",""),".",""), 1)
ELSE
Left (REPLACE(REPLACE(CSTR({WRSCONV.WRDTRC}),",",""),".",""), 2)

@TESTDY =
Left (Right (REPLACE(REPLACE(CSTR({WRSCONV.WRDTRC}),",",""),".",""),8 ),2 )
(/crystal)

i'm also trying various SQL date conversions but it doesn't like this:

SUBSTRING(CAST(WRSCONV."WRDTRC" AS CHAR), 5, 4) because of the casting, i believe.

the data is coming from server at another agency, so i haven't any control over the format

am i making this more difficult than it needs to be? am i going to be embarrassed tomorrow that i even posted this because it's such a no-brainer (i hope!)?

TIA!
becky

Crystal Reports Phone Number Format
i need a format for telephone numbers. i see other ones e.g. date/time/currency etc., but i cant see either a phone number one or a custom one where i could make my own mask.

my data comes in as 1234567890 and i need it formatted like

(123) 456-7890

thanks.

Printing File Using Crystal Reports In Nlq Format
How to print a file using crystal report in a quick format
The print should be as fast as printed through a DOS editor.
Please provide a solution for this (my client wants his report to print as faster as his Tally package prints)
How to print a file using crystal report in a quick format

Crystal Reports - Change Currency Format
I've designed some reports that will be used in different areas (Ireland & UK), so my VB app needs to be able to change the report currency format at run time.

I assume you're able to do this using the Crystal Automation Engine, does anyone know of any source for this - must be something that people do quite regularly!

Any links/code appreciated

Thanks

Crystal Reports 10 Takes Too Long To Display Report
We are updating our software to use Crystal Reports version 10. We have converted our reports to version 10. When we put them into VB thay take way too long to display. We havent changed anything in our reports since version 8.5. Why should the NEW version of Crystal Reports take longer to display the reports than the old one? Has anyone else encountered this problem before?

Need Help In Using VB/VB.NET To Create Crystal Reports, Convert To Pdf Format And Email Them
I am trying to write a VB/VB.NET code to create Crystal Reports, convert to

PDF Format and email the report. I can write the VB code to create Crystal

Reports but I don't know how to use VB or VB.NET to convert to PDF Format

and email the report. Will somebody please give me a sample code or any

direction.

Thanks

Atuahene Dickson

email@removed

Convert Currency To Words (Indian Format) In Crystal Reports
Please can anyone help me how to convert number to words in Indian format in Crystal Reports.
eg. I want to convert Rs.25,12,000 as Rupees Twenty Five Lakhs Twelve thousand only.
The towords function converts into millions and billions and i want the result in Lakhs and crores.

Thanks in advance.

Crystal Reports - How To Display Text Block Stored In Blob Field.
I'm trying to display text stored in a MySQL database blob field in a crystal report. It won't display the text because crystal reports interprets the field as a picture type. So if the blob field has a graphic stored in it, then it displays just fine. The only way I can get a large block of text to display is to store it in a longtext field. The problem with this is that I want to just have one column in my table that will either store a large block of text or an image. I know MySQL allows me to do this, but crystal reports doesn't seem to know how to handle it when it comes time to display it. Does anyone know a way around this problem without creating 2 separate columns in the table?

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.

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

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?

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

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

Columnar Display In Listbox
hello all,
i am using a list box , whose values are fetched fro database...since i needed to display values of three fields in single row, i contanenated the values , with spaces i between.but thats not visually appealing at all. can someton please suggest how to display the second value(that appears a second column in the same row of the list box), such that decide its initial position to start with...depending o previous values string length and appropriate spaces i between...
i used String(any_random_number," ") to ahieve this, which is no giving me desired results.I also tried to make use of colum property of list box for this...but couldnt...

thankx in advance,
Tanu

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?