Search results for query: *

Hi all, I have a report in Crystal 11 where we are using multiple columns and the client requires us to return at the top of each page the first record printed and the last record printed on that page. The record set can vary in length each time the report is run. So we need to control the...

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...

Hi All I have a problem whereby I need to display all the packs contained in an order for a site. The order number is unique but contains multiple packs. I am using suppression formulas in the detail section to display as the customr requires below:- Site Order No Date Raised Packs...

Hi all I am trying to return an actual visit date that a patient visit took place. I have used the formula:- If {tbl.thisismyvisitid} then {tbl.thisismyactualdate} However I appear to generate one date time value and one date value, crystal is then seeing these as two rows of detail...

Hi All I am trying to use cascading prompts in a report but am having an annoying blip. I want to select a country or countries, which gives me a list of available sites for those countries, I then want to select the sites and the materials available for that site. However the available...

Hi Hope you can help. I have been using the cross tab that ships with Crystal, however the client requires an CSV output and I gather cross tabs do not export. What I need to do is for each instance of a material type is count the number of material ids. So my Crystal generated cross tab had...

Hi I am trying to generate a report that will show the following For all sites Total Sites Activated (Count of all records with a site status of 1) Then sites for each country Total Sites Activated (Count of all records with a site status of 1 for this country) I initially used a cross...

I need to have a function to export reports to CSV format from the web. The Export button that has been generated by crystal through the web browser does not include CSV as an export choice. Do I need to code a function button for this.

Hi Hope someone can help. I only want to display the first record from a table, the best scenario would be that all the first record items from the linked tables are only returned, if this is not possible can I write a formula that displays the first record from each table? thanks di

Hi I need to create report templates that will work across many databases. The databases all contain the same tables but occassionaly 'custom' fields will be added to the tables. Where I need to add these fields to reports how do I handle the fact that sometimes the field will not be present...

Hi All Hope you can help again. I need to create the following report Site Investigator SiteName ActDate Status 1stPat LstPat 155 Mr Bloggs Blogg Site 23/12/04 Active ? ? In the 1stPat column I need to display the 1st patient activated there is a field patients.screeningdate...

Hi. I have a main report and I am considering using on demand subreports to give the user the ability to run several reports from one area and share parameters and variables between them. If I link to a database in the main report will I need to prompt the user evertime they open one of the...

Hi all. I have a parameter where users select multiple values from field a. In the same table there is a field b and I want to display the values that correspond ie:- field a has values Form 1, Form 2, Form 3 Form 4 field b has values "this is a form that describes etc", "this is a form that...

Hi all. Hope you can help me again. I have a field which holds a string of ratio value say 2:2:1:2, this is represented as a string value. What this relates to is the ratio that should be applied for each record. So I will have 4 records in my selection. I need to compile a formula that...

Hi I have a strange thing happening in my report. I have several group headers which was working fine until I added GH4 and then for some reason this group header keeps appearing inside GH3. I do have some fields in GH3 and am suppressing the Detail section. Any ideas?

Can you have a subreport of a subreport???

Hi All, hope someone can help me again!! I need to create an array from several fields and although I know what I want to do I am struggling a bit with syntax etc. I need to loop through Field A if Null then pass to my new array, if xyz is in field B then find position and return value for...

Hi hope someone can help. I have a report which displays the design of a study by extracting the forms created its fields and their values. For each main form type there are responses, ie fax, mail, html. I am selecting records based on the main form name, I then need to display what...

I have a report where we are displaying all the fields held on a particular form, some of these fields have options which are held in a separate table. I want to display one form at a time user driven by a parameter, on the report all the fields that form has used are displayed this uses two...

I am completely new to Crystal Reports. I have linked into my data source, some of the fields have number values which signify text values in the system. What formula do I need to change these number values to the text I want, ie If field x = 1 Then "blah blah, elseif Field x = 2 then "blah...