Parameter Limits

[griffter]

I have a report which returns patients, the report returns all the data required until I try to add a parameter to select Patient Records. For some reason the parameter does not return all the patient records to select from, is there some kind of limitation as to the amount of records the parameter selection field can hold

 

[griffter]

I should add that the available values dialogue box is where all the values are not being returned even though without the parameter the query returns all the records???

 

[Madawc]

Are you doing a left-outer link, and selecting on the second record? That's one cause.

Otherwise please post your selection statements, and also the SQL, Database > Show SQL or similar.

It helps to give your Crystal version

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[synapsevampire]

If you mean that you're trying to prepopulate default values in a parameter dropdown list, this may be what you want:

http://support.businessobjects.com/library/kbase/articles/c2014948.asp

Please remember to post your software version and database.

-k

 

[griffter]

Sorry for the lack of detail. I am using Crystal version 11.

I am not pre-populating the Available Select List in the parameter dialogue box this is being done using the Crystal Parameter builder itself.

The data is being retrieved via a view and the select statement is as follows:-

SELECT
Country = s.SiteAddress6,
Site = s.CentreID,
Investigator = s.Investigator,
[Patient Status] = CASE WHEN p.StatusID = 1 THEN 'Screened'
WHEN p.StatusID=6 AND P.DiscComp=2 THEN 'Completed'
WHEN p.StatusID=6 AND P.DiscComp=1 THEN 'Dropped'
WHEN p.StatusID=6 AND P.DiscComp IS NULL THEN 'Dropped'
WHEN p.StatusID=3 THEN 'Screen Failure'
WHEN p.StatusID=5 THEN 'Randomised'END,
PatientNumber = p.Code,
VisitDescription = lt.[Source],
VisitDate = pv.ActualDate,
KitNumberDispensed = (SELECT dbo.ufn_GetAllMaterialsForThisVisitCommaSeparated(p.PatientID, vd.[Sequence]))

FROM tblSites s

JOIN tblPatients p
ON s.SiteID = p.SiteID

LEFT OUTER JOIN tblPatientVisits pv
ON p.PatientID = pv.PatientID

LEFT OUTER JOIN tblVisitDesign vd
ON pv.VisitID = vd.VisitID

LEFT OUTER JOIN tblPatientVisitMaterials pvm
ON pv.PatientVisitID = pvm.PatientVisitID

LEFT OUTER JOIN tblMaterials m
ON pvm.MaterialID = m.MaterialID

LEFT JOIN FCS_FACTS_DB1.Security.dbo.tblLocaleText lt
ON vd.DescriptionTextID = lt.TextID
AND lt.LanguageID = 1
AND lt.TypeID = 0

WHERE pv.ActualDate IS NOT NULL

As stated all the data I am expecting is returned to the report until I introduce a parameter on Patient Code, there are some 3,000 patients in the database. I am wondering what type of object is used to hold the "Available Values" and whether there is a limit to what it can hold.

Regards.


Di

 

[IdoMillet]

Did you bother following the link to the article provided by synapsevampire?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com