Search results for query: *

Hi everyone. I was hoping someone might have some insight into a particular query Im trying to generate. Essentially I have a table that looks like the following: clientID startDate endDate 1 12/1/2001 12/2/2003 2 16/2/2002 23/3/2002 3 2/3/2001...

Hi, Yep, but when I enter the query: UPDATE mytableview SET field2 = 1234 WHERE field1 = 5 ... in Query Analyzer, and get the error ... Server: Msg 8115, Level 16, State 2, Procedure mytrigger, Line 14 Arithmetic overflow error converting expression to data type smalldatetime. The...

Hi, I was hoping someone could help me... I have a INSTEAD OF UPDATE trigger set up against a view: CREATE TRIGGER mytrigger ON mytableview INSTEAD OF UPDATE AS UPDATE mytable SET field1 = myfunction(inserted.field1), field2 = myfunction(inserted.field2), field3 =...

Hi, I have created a report within CR 10 that I would like to have exp[orted to a pdf document each morning via an automated process. I dont want to, each morning, manually start up CR and do a refresh, then go to file > export > pdf... Id like to have some streamline way of just creating a pdf...

Hi, I was hoping someone could help me. I have two databases that are duplicates of one another: one being the production database, and the other being the test database (the only difference is in the data they contain). When I create my reports, I build the 'Links' (via Database Expert) using...

Hi, I currently have few databases showing in Database Expert > History. Is it possible to remove certain databases from showing here? When i right-click on a database there are no 'delete/remove' options available. Any help appreciated. Cheers, Voirin

Hi, I was wondering if anyone could help me. When i go into select expert, and select a Field, then select 'is not one of' and hit the dropdown box tab, not all column variables are showing. Sometimes 1 variable is missing, other times 2 are missing. is there any way around this? Im using CR...

That did it, thanks! I needed to share variables. Thanks lbass & Madawc! cheers voirin

Hi again, I seem to have a lot of questions, and this is another! I would like to obtain a count of the number of patients in my main report. Below I have a report showing 3 distinct patients. How do I place generate this value? My 'patient' column is set to 'suppress if duplicated'. I also...

Hi, I was wondering whether it was possible to place a subreport summary in the footer of the main report? I cant quite see how to do it. Thanks! cheers, voirin

Hi, I have a main report and a subreport. They both have the same column names, and are displayed in a table. I have used the line drawing object to separate the columns with a line. How do you line up the vertical lines in the subreport to the vertical lines in the main report? Is this just a...

I managed to get around this by creating a formula field with the following: time({TIMESLOT.STARTTIME}) Then I insert this formula field in the report, group by this formula field, and suppress it. cheers, v

Thanks for the info! On a further note, I found that: File menu -> Report Options -> Convert database NULL values to default .. seem to work, however File menu -> options -> Reporting tab -> Convert database NULL values to default .. does not seem to work. Since I want this report...

Hi, I was hoping if someone could help me. I have a main report that displays appointment starttimes for patients, along side with other details. The starttime is of datatype DATETIME. Now I would like to group by this column. But I am finding that Crystal encompases all the results into a...

Hi everyone, I managed to fix the problem (solution given by Madawc - thanks!), but I don't quite understand why it's fixed (as opposed to other solutions (e.g. MisterMo - thanks!)). The solution that works is: if not isnull({PRIMARYCODE_1.DISPLAYVALUE}) and "revoked" in...

Thanks for that! However my problem still continues... i get the following output as an example: ------------+------------ Status ProductID ------------+------------ 45 73 23 Revoked 18 Withdrawn 46...

Thanks for the reply but that's not it. The reason I have "revoked" in {PRIMARYCODE_1.DISPLAYVALUE} is that I want to determine if the string "revoked" is contained in a larger string of words, for example the string "This application is revoked". This function works fine! All I want to...

Hi, I was hoping someone could help me. I have created a formula field '@mystatus' with the following (crystal syntax): if "revoked" in {PRIMARYCODE_1.DISPLAYVALUE} then "Revoked" else if "withdrawn" in {PRIMARYCODE_1.DISPLAYVALUE} then "Withdrawn" else "OK" I have applied...

Hi I have a report that is generated in tabular form. I want to get of repeating row elements. Take for example a weekly diet plan. Each row of the report represents a row of data based on data contained between linked tables. In the examples below i am using three columns: Day of week, time...

Hi, I was hoping someone could help me... I know this has an easy solution, but it isnt obvious to me... I need to create a report that requires a table being displayed with a fixed number of columns but varying number of rows (based on the output of the report). Essentially the output of my...