Search results for query: *

Thanks to both of you... my query in command object is working. I removed unwanted blank spaces and used aliases for tables and reduced the query file size to less than 64 KB.

Thank you very much for giving me inputs. I checked the size of query file and it is 66 kb. I'm trying to tweak my query and reduce the size. Will keep you posted. Thanks again .

Hi , I have written a query and I'm trying to paste it in a command object. The query gets truncated and I'm unable to paste the full query inside the command object. I manually removed the blank spaces and still doesnt fit in. Is there any restriction on the number of lines a command object...

Can anyone guide me in accessing the duration variance value from the tables. I need to know the calculation and the table fields accessed. Thanks in Advance.

Hi Can anyone guide me in the finding the tables or views accessed to calculate "Planned Value" . I need it so that i can replicate the same logic in crystal reports. Thanks

Hi K, Thanks for the solution. It worked.I will keep in mind of shared variables. Thanks Again.

Hi All, I use CR 8.5 . I need to display "line Number" column in the report which is nothing but a sequential number of the records. I used the "record number " function and generated the sequential number. I also have a subreport attached to the main report. The sequential number starts...

Thanks to all of you for the valuable inputs. K: Can You please explain me 1.how to export a Report Definition File which creates documentation for the report 2. and then link this Report Definition File file to the report. Thanks

Hi, I'm using crystal reports 8.5 and crystal enterprise 8.5. I would like to know whether it is possible to create help systems and documentation inside a crystal report. The help system and documentation should include report fields definition,purpose of this report,parameters used in the...

Is there a way to display database fields in report footer. I tried doing it and it displays only one row. Can anyone suggest how to display more than one row of record set in report footer. I'm using crystal reports version 10 Thanks

Hi, I'm using CR 8.5

Hi, I'm using a XML datasource for the report. There is a "messagetxt" field which needs to be shown as report field. The "Messagetxt" is of string datatype and has data more than 256 characters. when i run the report.. the "messagetxt" field displays only 256 characters and truncates the...

H i, Is there a limit of characters for computer name . Currently my computer name is 16 characters and while installing the computer name trunctates to 15 characters and shows in APS. Please let me know if anybody faced similar problem.. do i need to change my computer name to 15 characters...

I have created a cross tab report. The database field which is used to display as row has null values . Hence in the report i see some records with row name "NULL". i need to replace that "NULL" to "Blank" . is it possible in Cross tab. If so can you pls guide me. Thanks

what is the maximum number of triggers we can create in single Table in DB2 version 6.5 and Version 7 Thanks