Crystal V9 Range selection

Hi all,

I have installed SP3. whilst in the development environment, I have created a simple report that just lists everything from a single table. This works fine.

I then introduced a range parameter on one of my fields. then go to preview and enter a valid range, but the results still show all records???

Cant believe this is a enuine bug, as it's pretty fundemental. What am I doing wrong?What datatype it is? I tried with date range. It works fine.|||the field type is a character string and the database is an Access 2000 one.

The values are 2 characters like:

LA LB LC LD LE ......and so on.

when I enter a start of LB and and end LD for instane, it returns All|||check ur selection formula.|||I have now removed all parameter fields and will walk you through what I am doing.

I have the field explorer open and have right clicked on the parameter fields and selected new.

this displays a create parameter field dialog box I then enter a value in the name and propting text values leaving value type as string. I change options to range values then press the button set default values. I ensure that the table is correct and then set the browse field with the column from the table that I want to filter on. Then in the left hand pane it displays all values relating to that column. I press the >> button to make all values the default I then set the order to alphabetical ascending i then press ok. it goes back to the previous dialog and I leave allow editing of default values checked and press ok.

My parameter field now exists in the field explorer window under parameters. I drag this to the report header, and press preview I'm them prompted for a start and end of range which I enter, I then press ok, and then I'm returned all values.

???:confused:|||Everythings looks correct.

The last step is, you have to write the record selection formula.

Goto Report menu, select "SelectFourmula" and then "Record..."

This will opens the edit formula window.

Here select your database field and then give in condition which will be suitable for range values and then select ur parameter field.
This looks like

{table.column} in {?parameter}

now save and close this.

Refrsh the report|||Ah....thx the manual doesn't mention the last bit. It works now.

Crystal Reports Version Selection

I have ten users who need to access a single server operating crystal. Currently looking at around 200 reports max being generated (not per day). I was wondering what the latest version available to me would be suitable which can manage atleast 10 concurrently. Also does MSDE come with it and is it sufficient to handle this small solution. Have searched the net but not exactly sure what Im looking for.

CheersSearch here
http://support.businessobjects.com/

Crystal Reports +Selection of a particular section

Hi
I am new to .NET and my first assignment is to make to develop Crystal Reports for an applicaiton.This is a pure windows based application.
I have different types of data to be printed based on the selection in a check box.

Can I make a section added by me "visible" based on the data that i checked to be pritned.If so ,please help me with some sampel code.Visible I mean ,the checked data should be shown after I run the application

Hope to hear from some one soon.I spent the whole day searching for some tips!!!Hi,

At first create one Project and add one form into the project...... add option controls to it and add 1 button control to it and name it as generate report..in Generate report click event add this code.....Don't forget to get Crystal Report Viewer on to the form....

Declaration section.........

Public ReportType As String
Public FAErlangs As New FA_ErlangProjections
Public FARProjections As New FA_RadiosProjection
Public FATProjections As New FA_TimeslotsProjection

in button click event......

If optTrafficProjections.Checked = True Then
CrystalReportViewer1.ReportSource = FAErlangs
CrystalReportViewer1.EnableDrillDown = False
ElseIf optFARProj.Checked = True Then
CrystalReportViewer1.ReportSource = FARProjections
CrystalReportViewer1.EnableDrillDown = False
ElseIf optFATProj.Checked = True Then
CrystalReportViewer1.ReportSource = FATProjections
CrystalReportViewer1.EnableDrillDown = False
End If

hope this works for you...... if you have any questions mail me at garlapati76@.yahoo.com.

Thanks.sql

Crystal Report Printing

I m using vb and crystal report. i m calling crystal report through vb i want to give a print selection option to user how can i do this ? pls help me its very very urgent for meCR.EnablePopupMenu = True
CR.EnablePrintButton = True

where CR is the Crystal Report viewer

Crystal Formula - SQL

I started with this selection criteria:

({@.Meditech Date to PC Date} in {?Beginning Date} to {?Ending Date})

Then I did this:

{@.Meditech Date to PC Date} in {?Beginning Date} to {?Ending Date} and
({LabSpecLPatientIndex.Prefixes} in ["IM", "R"] and {LabLSpecResultTests.Result} <> "")

I got data just fine on that.

Then I further altered it with this:

({@.Meditech Date to PC Date} in {?Beginning Date} to {?Ending Date}) and
(({LabSpecLPatientIndex.Prefixes} ="IM" and {LabLSpecResultTests.Test} = "902.9550"
and {LabLSpecResultTests.Result} <> "") or ({LabSpecLPatientIndex.Prefixes} ="R" and
{LabLSpecResultTests.Result} <> ""))

And I get no data. What did I miss? I want all records with between those dates, that have prefixes = IM or R that have results (not null results). If the prefix = IM, then I only want it if Test = "902.9550" ...but I want all records with a Prefix R.

TIA.
Briana{@.Meditech Date to PC Date} in {?Beginning Date} to {?Ending Date} and
({LabSpecLPatientIndex.Prefixes} in ["IM", "R"] and {LabLSpecResultTests.Result} <> "") and {LabLSpecResultTests.Test} = "902.9550"