Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by varadha72

  1. varadha72

    Multiple or nested IIF condition

    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"...
  2. varadha72

    Display field value as column layout "Across, then Down"

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

    Display field value as column layout "Across, then Down"

    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.
  4. varadha72

    Display field value as column layout "Across, then Down"

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

    Display field value as column layout "Across, then Down"

    Can someone help me here please....
  6. varadha72

    Display field value as column layout "Across, then Down"

    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...
  7. varadha72

    Two fields 2 Column report

    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...
  8. varadha72

    Trouble with exporting blank textbox to excel for number with 10 decimals

    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.
  9. varadha72

    Trouble with exporting blank textbox to excel for number with 10 decimals

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

    Trouble with exporting blank textbox to excel for number with 10 decimals

    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...
  11. varadha72

    Trouble with exporting blank textbox to excel for number with 10 decimals

    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...
  12. varadha72

    Trouble with exporting blank textbox to excel for number with 10 decimals

    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...
  13. varadha72

    Trouble with exporting blank textbox to excel for number with 10 decimals

    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...
  14. varadha72

    How to conditionally show single line or dotted line on change of group to a field

    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...
  15. varadha72

    How to conditionally show single line or dotted line on change of group to a field

    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.
See more

Part and Inventory Search

Back
Top