Search results for query: *

Hi All, I am currently trying to modify a subreport on a main report. Because of the scenario, I think I need to create 2nd level of subreport into 1st level of subreport. Here is my scenario: Main Report ----------- All Shipping information and orders list associated with it. 1st level of...

Hi All, I have developed a CR report in version 8.5, which has form (set of lines and Text)and couple of fields. Usually this report will be printed on laser printer. Now there is a need to print on pre-printed label on dot-matrix printer. So I need to suppress the form and just print the...

I figured out today, why I don't see the inserted field from added table doesn't show up in 'Show SQL query'. The reason was added table is not linked properly with othe existing table when I added new tables.

Have any one experienced this problem?. Crystal Guru's shed some light on it.

Hi All, Using Crystal Report 8.5 & MS-SQL Server Per requirement, I have created a report, which has 3 sub report. Main report and 3 subreports has stored procedure as datasource. First two subreports are Identical. To get different name I saved subrpts with two different name and Inserted...

Using Crystal Report 8.5. I have a requirement to display group's running total value on Report Header Section. I have tried using the same sum of running total field in report header, it just display 0 (zero). But running total at group footer shows value. How do I achieve displaying this...

Using Crystal Report 8.5 I have a report. I need to add one more column from table which is already chosen. I did the following: Insert Menu --> Field Obj ---> added the field from "Database field". If I preview report doesn't display data for the new field I added. I checked...

It worked. Great Thank you Brian and SV

Hi All, Using Cry 8.5. Scenario: Detail Band: ------------ Detail Band Begins here 1st line -- table.field1 table.field2 table.field3 2nd line -- table.field5 Detail Band Ends here When table.field5 is blank I need to hide 2nd line of space used in detail band. I have set...

Hi Brian, My bad, I had GroupName(Group 1) instead of table.group_field. Just replaced table.group_field with GroupName, it works fine now. Thanks again. Keepup your good work. RK

Brian, Thanks for your response. When I created the formula, I am getting error: "The summary / running total field could not be created". Col A is varchar type. Group column also varchar type. How do I overcome from this error message. I have tried VAL() and ToNumber() ...

Hi All, Scenario : Report with 2 level groups. I need to display one column (say Col A) value at 1st row and last row on the header. Eg: Col A - value at 1st row : F111 Col A - value at last row : L999 Header ------ Number (F111 thru L999) Detail ------ F111 - Row 1 S222 - Row 2 T333 -...

Hi All, Scenario : Report with 2 level groups. I need to display one column (say Col A) value at 1st row and last row on the header. Eg: Col A - value at 1st row : F111 Col A - value at last row : L999 Header ------ Number (F111 thru L999) Detail ------ Row 1 Row 2 - - - Row 9 Thanks in...

Thank you Lisa. It worked.

Hi All, Using Crystal Report Version 8.5.0.217. I have created a Crystal Report with 3 groups. I have two text object for a one field. Depends upon number of rows in detail band I want to hide one text obj. ie. If detail band row count = 1 hide 1st text, else (>1) hide 2nd text. I have...