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!

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

Search results for query: *

  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"

    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...
  6. 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...
  7. 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.
  8. 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.
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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.
  15. varadha72

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

    Hi can someone help me here. Group Header: I have a group created called "Account" (each account has several funds)and suppressed. In detail Section I have fields FundName and Amount only 2 fields. Fund Name Amount Formatting Pattern AccountA 100 Top:Line, bottom: dotted AccountA 200...
  16. varadha72

    Too few parameters Expected 1 error

    Also when I executed the same query in Access, the query is taking a long time to execute. When I remove the having clause and place it in Where clause, the query execution is quick. Please suggest if I could use the parameters in Where clause instead of Having clause.
  17. varadha72

    Too few parameters Expected 1 error

    Hi dhookom thanks for your response. I tried my code with your suggestion, but I still getting the same error- Too few Parameters. The query result in the debug window is as below- SELECT DISTINCT (T.File_Name), M.FileNameForForm, T.row_count, T.exception_count, Min(T.run_Date) AS rundate...
  18. varadha72

    Too few parameters Expected 1 error

    I tried this query also, but I getting the error "Too Few Parameters. Expected 1. Error. Please help. RunSQL = "SELECT DISTINCT (T.File_Name), M.FileNameForForm, T.row_count, T.exception_count," & _ "Min(T.run_Date) AS rundate, M.sortorder " & _ "FROM dbo_SOURCE_RUN_DATA...
  19. varadha72

    Too few parameters Expected 1 error

    My Apologies the Query is; RunSQL = "SELECT DISTINCT (T.File_Name), M.FileNameForForm, T.row_count, T.exception_count, Min(T.run_Date) AS rundate, M.sortorder FROM dbo_SOURCE_RUN_DATA AS T, Master AS M, dbo_SOURCE_RUN_DATA AS A WHERE '(((T.file_name) Like '*' & M.filename & '*') And...

Part and Inventory Search

Back
Top