I am using crystal report 8.5 which I ran through DataFlex 7 version.Trying to print label size 3x1 with Avery 5163 to print 10 labels per page .And printing direction is Down then Across.
My problem is it is working fine in the desktop computer but when trying to print from labtop(window xp)...
I want to export to excel so that user can input some data.That is the basic idea.
I don't know whether it is a good idea.I found in some section(crystal report) the field are having different field width under the same column.
I am not aware of macro would you please tell me more in details...
I am trying to export Crystal report 8.5 to Excel. What are the options I should choose to get the same format and layout.And also I need to get the company logo(picture) in the excel. Right now I am not getting the image. Any help is appreciated.
Thank you
The report I am working returns more then one record because of the linkage.
group1 ord number--order#1
group2 itemno
lineno quantity color
1 10 1
1 10 1
1 10 1
group2 itemno
lineNo Quantity color
2...
hi fisheromacse,
The formula(crystal report sum) says
@sum
sum({table.physical_qty},{table.itemid})
It should work but it is returning double the value for example: 20 it prints 40.
hi lbass,
My report data look like this
itemid aaa
tagno physical_qty computer
1000 100...
This is my layout of my report
Group by Location
Grp by itemid
grp by tagno
displayed fields {table.physical_qty} and {table.computer_calculated qty}
in grp footer of tagno i display {table.physical_qty} and {table.computer_calculated qty}. I want to suppress the grp if the sum of...
hi lbass,
I get blank col in case of 'pic' but the summary field is loaded.
with condition --table.field <> pic
like
-------(blank)
------
5
5
5
5
From customize style i check 'suppressed the empty row and col'
Thank you
Hi lbass ,
Sorry Still i have problem.
I told wrong it should be like this
Row field --table.cust name
column field ---table.item
summary-- sum of total quantity
I created this formula
if {table.field} = "pic" then
" "
else
{table.field}
i used this formula as my column field
and add this...
I am using cross tab in the footer of report section
column field --table.cust name
row field ---table.item
summary-- sum of total quantity
I hope it helps
Thank you
thank you so much
Now
if {table.field} in ["pic","frame"] then
"pic/frame" else
{table.field}
Thank you so much lBass.
now I get
pic/Frame
10
10
instead of
pic/Frame
5
5
In a cross tab I have this as a result
pic frame mirror stand
cust1 5 5 1 2
cust2 5 5 3 1
but I want to print pic and mirror together as 5(count of the record),since they are one item.
How do I do that?
i want something like this
pic/frame mirror...
I using this function StringToCode39 to convert my number to barcode. My question is about the font size. Can I have any font size or it will truncate my barcode if i increase it.I am using it in the label format, so maximum how much i can increase the size.
I am wondering whether the font...
In the main report I am placing my subreport in the group footer.And my subreport goes more then one page . I need header for each page.I have one group in the subreport. I have text field in the report header of the subreport. Like
item# order# desc
---- ------ -----
Group...
Sorry ..the sort I need is
1
3
44
54
54a
54B
56
56B
60
so on..
I tried this logic
@FSort
end:=right(sNo,1);
if not isnumeric(end) then
sWinNo:=trim(replace(sNo,end,""));
else
sWinNo;
and used Fsort field to sort
and printed {table.sno } field
but the field printed number first 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.