Search results for query: *

Thanks - I was able to set up my append queries, but could you please elaborate on using the After Insert Event? Thanks so much, Jayme

Hi there, I have three tables: tbl_Team tbl_Performance tbl_Score The relationship is 1:1 tbl_Team:tbl_Performance, and 1:1 tbl_Team:tbl_Score. It needs to be setup this way b/c different users have different permissions on these tables. All 3 tables have Team_ID as a primary key. I want a...

Hi, Is there any way to set the data source dynamically by using a form with a drop down list (so that a business person could do it) We have Development, Test, and Production databases. User names and passwords are different for each. I would like to set up the Access front end so that it...

I used Crystal Reports and pulled over tables in the Database Expert, then linked them. Then I added filter criteria to the Select Expert Formula. I ran my report. (Report B) It took over 5 minutes. I took the query generated above by Crystal Reports in the Show SQL Query. I placed it in a...

Thanks for the suggestion about stored procedures... Hearing that someone else has slow reports using the Crystal GUI vs. writing a SQL command confirms that I am on the right track here... I am dissapointed - I didn't realize there was a performance issue until it was too late - I have 50...

Both queries take the same amount of time to run in TOAD... So I don't understand why they would take a different amount of time during Reading Records... The inner joins that you see are actually done behind the scenes in the view that I created, RPT_PSDMEASSUM. I renamed RPT_PSDMEASSUM in...

As for the difference in timing, what does "When running the SQL that the report generates directly in Oracle ( from SqlPLus), it returns all the records I expect and it runs in less than 5 seconds for both reports." mean in technical terms?" It means that I take the SQL from "Show SQL Query"...

In the toolbar, I click on "Report" and "Performance Information" is one of the menu options. If I click on "Performance Timing" it tells me how long everything takes. Both reports are EXACTLY the same - I had started the report by doing a SQL command with no parameters in it, then putting...

I am using Crystal XI, with Oracle 10g DB. I am trying to tune up the performance of a report. According to the performance information and the notes that appear at the bottom of Crystal while my report is running, the access of the database and the amount of time it takes to run my query are...

I probably should have been more descriptive from the beginning, sorry: Our data is based on a recursive relationship that builds a tree. Only the leaves of the tree have project types associated with them, not the branches. Leaves can have more than one project type. There are several...

how do i change what is there?

Yes this part I understand... The trouble is, I need to do my filtering before I build my tree using the connect by statement in the command object. So my parameters are listed inside of the command object. Once I build this tree, I am trying to link it to the main report. Since I have my...

Hi there! I am using Crystal Reports XI with Oracle 10g DB... I would like to know how to pass in a field from a main report and use it in the command object of a subreport as a parameter. I am building a tree with SQL from the DB inside the subreport command object, so I need to filter the...

I am using Crystal XI with Oracle 10g DB... My report lists dates along with thier associated measurements and categories in a table called "MEASUREMENT_PERIODS". Each Date can be specified as "Client", "Management", "Other", no category at all, or any combination of the categories. I have a...

I think this is getting at what I need... Except that a date can be anything the engineer sets it too - could be every three days, every week, every other week, or completely random if they feel like it. For the very last date, I am just running another command statement that uses an...

Hi there! I am using crystal xi against oracle 10g db. Each task is assigned to a location & level. Each task has several hundred dates - the dates are the same for one task as they are for another. For each task at each date, 2 measurements are taken. These are taken cumulatively, so the...

Hi there! I am using Crystal XI... I understand how to either display a cell margin or not display it at all in a cross tab - but is there any way I can display the cell margin and adjust its size? thanks! - jayme

That would return Package A 4/5/2005 Package B 4/10/2005 Which is not what I want... Thank you though

Hi there! I am using CR XI and an Oracle DB. I am grouping by package, and each package has several dates as details... Package A 2/19/2005 3/12/2005 4/5/2005 5/10/2005 Package B 4/10/2005 6/12/2005 8/15/2005 Package C 1/2/2005 1/23/2005 2/4/2005...

Hello there! I am using crystal reports xi on a oracle 10g db. Hello there! I am using crystal reports xi on a oracle 10g db. i have all of the information i need in a crosstab. however, people would like to see the groups listed above the data with no totals associated with it, and then...