Recent content by JSeidel

I have just installed a customer with crystal 8.5 designer. The customer does not have any sqlserver components installed on the machine. I have tried to open a report file on their machine and refresh the report to point to their specific db/tables but get a pdssql.dll error. I have...

Hi- I have installed crystal enterprise 9.0 but it doesn't look like it comes with the IDE. Does anyone know where I can get that from? whether it should be on the CD??

Hi all: thanks for your input - greatly appreciated.. Yes, I was talking about using stored procedures to pass parameters vs the crystal parameter component they have within their formula editor. Most of our reports are moving towards stored procedures but I do not want to limit a clients...

I am currently running CR 8.5 with the plan to move to 9.0 in the near future. I am aware of two methods of creating parameters - 1. embedding SQL parameters and having crystal call the parameters and 2. using the parameter formula editor to create them... what is better to do? I need to have...

how do I insert a memo field?

I am using CR 8.5, dev edition. Sql server dbms. I have a field that pulls notes for a record. These notes may be thousands of characters long. I have set the field to grow where "0" is the limit on "can grow"... it seems though, that it will only pull so many characters...

I am on Crystal 8.5 and I have a cross tab report where I"d like to grey out only two columns (still show the data but have the background color greyed out). eg: Temp Temp Site R.R FIO2 I only want Temmp and R.R columns greyed in background..

will this still work without subreports? the framework I push this report up to will not accept subreports and thus I need to keep this to a onesie....

I am using crystal 8.5 and this is what I have as output. Sql 2000 db. ID#: Allergy: Order No. Likes/Dislikes: Comments: Modifiers: I have it grouped by ID# because you can have many Order No. within an ID (this is OK), the problem I have is if Allergy is 1...n then it creates a...

I have one field that is creating multiple rows in the database for one account because it varies by time. I would like all values for this field to be placed in one field on the report (like a cancatenation of this field) so that I don't have multiple sections for one account because this...

I need to select records where there are null date/time but every formula I use gives me an error...is there some way I can get only those records with null date/time values??

I need to convert a field from metric to standard but the field is a ValueText field and I have to create a ToNumber formula first but when I execute I get an error - any help would be apprec

anyone know how to limit the number of cross tab columns per page? it would solve virtual page problems but I don't know how to do it...

I have a report that may span multiple virtual pages. How do I make sure that the report will always print a header and footer on the virtual page even though I don't know how many virtual pages there may be for a specific account? This is a big problem with the customer and I'm at a loss on...

I have a cross tab that will show values based on what is put into the db. I need to format only three of these values: eg: if value = ht then show "ht(cm)" - problem is, it only grabs the last value when I write if value = "ht" then "ht(cm)"; if value =...