I need to compare the value of 2 fields to see if the value(s)change when I read the next record. If the first field remains the same but the second field changes I need to know - would probably display a value of 1 if it changed. I am not sure how to set the variables up so they correctly...
I created a new ODBC DSN and was then able to connect and see the tables. Not sure why the first DSN didn't work. It works with the application but not with Crystal Reports.
I am creating Crystal Reports using Version 11 and connecting to a SQL database. I can see the server and the database and tables, views, and stored procedures but when I click on tables all I get is dtproperties and not the tables. What do I need to do or change in order to see the tables? I...
I am using ODBC to connect. It is a SQL database. There are at least 2 different databases being used - one in test and the other in production. I would like to verify which database the report being generated is using.
Code and description are not in the same database. I did get some assistance and it seems to be working. The explanation was that you need to use the "filter" and made the "code" in the original database file equal the "code" in the hotfile and then the description will come in. I have not...
I have created a report using a database table and appropriate fields. One field is a code and I need the description to be included. I have created a "hot file" that has the code and description. I have added those two fields to the report and associated the code field in the "hot file" to...
I have created a report and would like to print out the selection "criteria". I am using a formula with "selection" but when I print out "selection" I only get the first 128 or so characters.
For instance I would like to have the following selection criteria...
I need to remove the street address (number) from an address field and only print the text part of the address. I have done this in foxpro and dbase by locating the first "blank" in the address and then printing/listing the rest of the address. I assume this is how I would have to do...
I have created a report using a formula that evalutes a previous record against the present record. The report comes out with the properly selected records. Now I want to create a pivot table based on these selected records. However, when I generate the pivot table it includes all of the data...
I am working with a sql table that contains times of transports. I want to compare each record with the previous record to see if it occured with 30 minutes. I have the times coverted to seconds and have created a variable to examine the previous record against the present record. It appears...
I need to compare activity totals from a month of last year to the same month of this year (ie November 2000 compared to November 2001). I have not been able to find an example of how to do this. I can do each month separately and then export them to an Excel spreadsheet but I would think 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.