Search results for query: *

Hi, I am having a problem in creating a report meeting my criteria: I am using crystal reports 8.5 The tables I am using for the report are: 1. Employee 2. Assignments The primary field in the employee table is ID The primary field in the Assignments table is ID. both are linked. The Data in...

Hi, I am having a problem in creating a report meeting my criteria: I am using crystal reports 8.5 The tables I am using for the report are: 1. Employee 2. Assignments The primary field in the employee table is ID The primary field in the Assignments table is ID. both are linked. The Data in...

Hi, I have my data like this in the report. id Function 1 200 1 201 1 201 1 202 1 203 2 200 2 201 2 201 2 202 2 203 3 201 3 202 3 203 I would like to have the data like this: 1 2 Report footer: should have count of all id's the criteria to pick up the data...

Hi, I have some data like this: name id abc 1 abc 2 abc 1 abc 1 i would like to display the records based on the criteria: I want to have only id:1 but if that name has other id's also along with id:1 , then i dont need that data or entire group with name:abc in that...

hi, i have a mailing label report. It aligns and prints well when i run as a standalone report. But when i run this mailing label report through web, the alignment is changing ie., it is not printing exactly on the label that it was run as a standalone report. How can i fix it? thanks pandy

Hi, I am using Crystal REports version 9.0. I think in this version we dont have report types that are in previous versions. If i want to create a form letter or any other report type that were in previous version, how to create in this version 9.0? does anybody has any ideas? any help is...

Hi, I have a "Status" field in the request table. The data in the status field is: requested program manager approved assigned research etc., the user wants the sort order: assigned,research,program manager approved and requested. How is it possible? when i use the status field for sorting...

Hi, I created a string parameter with options "Allow multiple values", "Discrete VAlues". When I select single value or add multiple values, the record selection is working fine and filtering the records based on the parameter selection. But when i try to print the selected parameter value(s)...

Hi, I created a crystal report(ver9,0)off oracle(9i) database. Everytime i run the report, the report is prompting for userid/password. Is there anyway i can enter once and avoid prompting userid/password everytime. And also, i see the following 3 drivers with which i can create a DSN off...

Hi, I have a question on the record selection formula we use in the crystal reports. Record selection filters the database records. Will it be done at the back end or in the crystal report? Will it bring only the filtered records into the crystal or will it bring all the records into the...

Hi, I want to sort my date field by time earliest..ie., 7 am , 8 am, 12 pm etc.,any ideas? thanks

Hi, I have some reports which are working under existing database. I have updated my database by adding/deleting some fields etc. Now I want to modify the existing reports to work on the new/updated database. What are the steps Ineed to consider before doing changes to the reports. Both...

Hi, Can anybody help me to the solve the following error: ODBC error : Error while executing the query. Error: JOIN/ON clause refers to "employee" which is not part of JOIN. This report works to be fine. Suddenly im getting this error. It worked well so far. I did not change...

Hi, I am looking for any mapping tools that automatically changes the location of the database. thanks

Hi , I have a field which displays a number. Depending on a specific condition it should display a color(Font color or Background color). Any ideas please... thanks

I have a report with table employee with fields a,b,c. I changed the location for this report to another table with the table named employee with fields a,c. When I check from the Set Location, it is showing the changed database. But when i go and check the table in visual linking expert, it...

I am getting the following error: Program Error: crw32.exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being created. I am using crystal 8.5. please help.

Hi all, I am looking any mass mapping tools so that my reports can be mapped to another database. thanks pandy