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- 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.
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.