Search results for query: *

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.

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

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.

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

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

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