Search results for query: *

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.

Thanks for this Madawc, i was hoping i could avoid bringing down all the records by using a record selection formula? The table i am pulling down can have a lot of records

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

Thanks for the feedback. I was going to create a template much as you describe. My problem is more around the fact that the report will be used against multiple databases and although the table design of these databases are the same, there are occassions where 'custom' fields are added to the...

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

Just in case anyone else gets stuck on this one this was the solution. Using the minimum\maximum formula with a condition on the group, ie Minimum({YourTable.YourField}, {YourTable.YourField}) Minimum({fld,fldcond ie the field records grouped by) Gives the earliest date for each group of...