Search results for query: *

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

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

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

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

I am using Crystal XI against an Oracle 10g db... Is there any way to make columns smaller in crosstabs? I am getting the information I want, but I cannot make the crosstab small enough to be of any value. All of the columns are way bigger than the data they hold. Thanks! - Jayme

Hi There! I am using Crystal reports XI - Does anyone know if and how you change the labels on legends on charts & graphs? I can't seem to figure it out! thanks, jayme

Hi There! I am using Crystal Reports XI with Oracle 10g DB - OLE DB Provider :) I am using analytical functions in my sql, and I am getting errors. The code is kinda boggy, so before I post it, I want to know if it is ok for me to use analytical functions?!? I am using First_Value &...

Hi there! I am using Crystal Reports XI, with Oracle 10g database... I am having a problem with a parameter: {?Date_From} Our users input parameters in a Flex application. The parameters are then passed through to Crystal Reports. If the user does not select anything for {?Date_From}...

Hi There! I am using Crystal Reports XI... How do I define a multi select parameter in the Command select statement in the Database Expert? Thanks! - Jayme

Hi There! I am using crystal reports xi... I am trying to put a parameter in my select statement in the command, but I keep getting an invalid character... The multi-select parameter is called ?Delv_Status. It filters the field Status_Id. If the user enters nothing (blank) then all fields...

I am using crystal reports XI. I have a report that lists parent packages with their package types, and children packages with thier package types: Parent Package: 7865 Type: SYS Child Package: 8979 Type: ROS Parent Package: 8934 Type: SYS Child Package: 9653...

Hi There! I am using Crystal XI. I have a parameter called "?Discipline Group". The user is allowed to select multiple values for this parameter. If the user selects ?Discipline_Group = "Engineering" and "Construction", I would like the first page of the report to have the following...

Hi there. I am using crystal reports xi. how do i program in select expert for a field to match to all values if nothing is chosen for a parameter? Example - I have a parameter {?Discipline_Group} I would like to have Discipline_Group in the report display for all selected...

Hi! I am using Crystal Reports XI, and have CRChart for XI... I am creating both a line chart and bar chart. my fields are: FINISH_DATE, SCHEDULE_PERCENT_COMPLETE, FORECAST_PERCENT_COMPLETE, ACTUAL_PERCENT_COMPLETE Each FINISH_DATE (x-axis) has a SCHEDULE_PERCENT_COMPLETE...

I am using crystal XI, oracle 10g, and OLEDB driver... I am using a stored procedure to set a username that designates what data that user is allowed to access. Therefore, if there is no username set, there will be no data returned. I drag and drop the stored procedure in the database...