Recent content by griffter

Hi Thanks for the response As you thought the client requires to display at the top of each page a From: 'code number x' To: 'code number y' heading showing the first code number printed in the list on that page and the last code number printed in the list on that page. (code number being the...

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

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

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

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

Many thanks for all your help

Hi LB I think I am trying to crack a nut with a hammer here. I have created a formula field that returns only the date and used that in the report, the client is not interested in the time element. Just need to make the field read, dd,mmm,yy now!!

Thanks LB for this help. I have tried to use your formula but it is still not quite right. I am losing my first date which I want to retain. I should mention that the data is grouped by the order no. I have tried using groupnumber>1 with your formula to get around this but it still won't...

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.

I am using version 11.