Recent content by varadha72

Hi Folks I need some help here. IIf( Price.[FileName] ="Price" and [SubmissionType]="Add", "467", IIf( Price.[FileName] ="Price" and [SubmissionType]="Change", "467", IIf( Price.[FileName] ="Rate" and [SubmissionType]="Add", "209", IIf( Price.[FileName] ="Rate" and [SubmissionType]="Change"...

Dhookom, The width of my report is 8". I right click on the report and select "OPEN".

Dhookom- Yes I stacked means one column. Zelgar- If your answer is probably I dont have enough data. Then please tell me what should I do, when I have only 4 rows of data and how could I control the limit to display in each column such that first column shows 2 and second column 2.

I mean although I select Column Layout as 'Across, then Down, yet the report appears to show them as stacked data.

Can someone help me here please....

Hi, Can someone guide me here please. I have two DB fields (SQL Server Query) : Title......Name Manager....John Pricer.....Smith Support....Mary IT.........Alex Now I need this to appear in my report as below, I mean as in 2 columns without headers. I tried setting this by going to: page...

Hi, Can someone guide me here please. I have two fields: Title......Name Manager....John Pricer.....Smith Support....Mary IT.........Alex Now I need this to appear in my report as below, I mean as in 2 columns without headers. I tried going to page setup-->Column-->GRID settings-->no of columns...

I do have the formatting. The formatting is present in the worksheet after being exported from crystal reports. The formatting include top and bottom lines.

The user would key in the Worksheet after exporting from Crystal Reports as Excel.

What I meant by my previous statement is that, the formatting are working good. All that I am having trouble is only with the blankfield1 and 2. They are blank textboxes. The blankfield1 and blankfield2 are just textboxes spaced enough to hold 12 characters. After export I need to see the data...

Header: Name......Class....CUSIP.....Income.........Dividend...... Detail: Name......Class....CUSIP.....Blankfield1....blankfield2... Formatting- TOP: if (Count ({F.short_name}, {F.short_name}))=1 then crSingleLIne else if (Count ({F.short_name}, {F.short_name}))=2 then (if {#RTotal0}=1...

Hi SkipVought, Thanks for your reply, but the problem here is I need formatting for each of these fields. i.e. I have to show single line when there is change in name, and if the name is same in subsequent rows, then I need to show dotted lines. So if I export to CSV or tab delimited, I loose...

Hi, Can someone help me here. My report layout is DB field with some textboxes. The report needs to be exported to Excel format. In excel where the blank textboxes are, the user must be able to key in a 10 decimal value data. So I inserted a textbox in the detail section next to the Name...

Sorry it should have been "top and bottom". Anyways I figured it out. I used running total and got it done. if count{Group.FUND_name}=1 then crSingleLIne else if (Count {Group.FUND_name})=2 then (if {#RTotal0}=1 then crSingleline else crDottedLIne) else if (Count ({Group.FUND_name}))>=2...

Hi Charliy, I tried the way you suggested, but here is what is happening- when there is a change in group, then the first fund is showing line in the top bottom, when there is more than one fund in that account. Please help.