I am using CR 9, connecting to DB using ODBC data source. I am using an SQL command as my datasource. The problem is the length of time it is taking to run the report. I guess the SQL statement or something is not done very efficiently. The information returned is correct, but it takes a...
I am using CR 9.0. I have two tables linked using ODBC.
Table one is called POCPODF and has following fields:
PO_NUMB
PO_LINE_NUMB
ITEM
ITEM_DESC
etc.
Table two is called A1PODTL and has following fields:
PO_NUMB
PO_LINE_NUMB
PO_PRINT_CHAR
Tables are linked on PO_NUMB and PO_LINE_NUMB.
If...
I am using CR 9.0 after an upgrade from CR 8.5 with an ODBC connection to a Thoroughbred database with a Thoroughbred ODBC driver. I realize this is not a supported database...but I have been using CR against this database since CR version 5.0 with no problems.
I have reports that were...
I have created a parameter field that prompts for a range value. I need to get the beginning and ending range values in a title. I have no problem getting a discrete parameter value in a title, but can't figure out how to do the range values in a title. My parameter is {?item}. So I want my...
Is there anyway to not have the Field Explorer tree re-collapse each time you finish editing a formula from it. For example, I expand running total formulas, select and right click on formula to edit. Finish editing formula, save formula, Field explorer is collapsed again. If I want to edit...
I have three groups in my report which are currently using a unique specific order sort for each of the groups. I have a need for the second group to sort differently based on the first group.
So for example, if the first group is equal to X, the second group would sort a certain way, but if...
I upgraded my Redhat 6.2 server to Redhat 7.3. I set up a couple of file systems for export in /etc/exports. Everything exported OK and I could mount the file systems on two other unix systems (AIX and SCO). However, when I'm on the AIX or SCO box and I try to change to a directory within the...
Is there any way to handle report revision or change control in Crystal Reports v.9? I want to see the changes from one version of the report to the next. Thanks.
If someone could help me with this formula I would really appreciate it. I need to define a variable Y that sums the values from general ledger periods only for a certain group of GL accounts. The value of Y changes depending on the GL period. So what I want is:
if {?Period} = 12 then Y:=...
I am trying to create a line chart in Crystal using the following data:
I have 4 colums that are represented by unique titles coming from the data source. My rows represent total quantity moved by an operator for that time period. So it looks something like this:
Jan 1 Jan 2 Jan...
I need to round some financial numbers to thousands.
If the number is $3,998,876.00 i need it to display as $3,998.8 - any suggestions would be appreciated.
I have a datasource that consists of a single database. The database is a collection of general ledger account information and values by period. In the database are fields like:
GL-ACCT, GL-DESCRIPTION, and there are also unique fields for each accounting period of the current year and prior...
I have a redhat linux 6.2 box that is sitting on our lan. IP addresses on our LAN are 192.0.0.x. We run NT 4.0 with MS proxy installed and our users access the internet via proxy. I am trying to get the redhat linux box to see the internet. I can ping internal addresses no problem. I cannot ping...
I am a fairly new user to Front Page. One thing I have noticed is that when I set up a table and either use a background color on the table or a background color on a cell or set of cells in the table - it displays in the browser correctly, but when the page is printed, the background...
i am getting a the following root file system error when running fsck:<br>"Danger: Filesystem being checked is larger than the device in which it is stored (/dev/root). Backup filesystem and recreate as soon as possible."<br>I get this error no matter what flag i...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.