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

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

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

Hi, would anyone know how to create a user within Oracle Enterprise Manager to allow full READ access for report generation. What I mean is that I have created a bunch of reports for our users. The only part of the report they require access to is the "Select Expert". Once they specify the...

Hi, we recently had Crystal Reports v10 installed on all the user computers. I have created a template report which I would like our users to access and generate their own report from. The only variable the user has to supply is a date range to generate the report. This is accessible via Report...

Hi everyone. Thanks for all the previous help since as I am new to Crystal! One other question... I am using a Select Expert to generate a report of data between two date ranges i.e. table.date is between 1/04/2005 12:00:00AM and 1/05/2005 11:59:59PM What I would like to know is how do i...

Hi I have a few issues to resolve with crystal reports (v8.5). I was hoping someone could help me. 1. I have a Formula Field that i would like to delete. However when i try and delete it, it says that the field is being used in the report, and to delete it i must remove all references to this...

Hi im new to Crystal reports v8. I have a few questions as I'm relativley new to this application. Sorry if my lingo is incorrect: 1. I have set up a report that uses 'Expert Select' on a particular column - to filter away any rows containing non-positive numbers in that particular column. The...

Hi, is it possible to do mail relay on the ISA server using one NIC? The present network has a PIX utilising 3 of its ethernet ports: outside, DMZ and inside. The ISA server sits wholly in the DMZ The mail server sits wholly in the 'inside'. We want to have smtp mail coming from the 'outside'...