473,835 Members | 1,813 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Excel Report stops converting currency

At some point after running this report the "Wholesale Price" column data
type in the excel spread sheet changes from Currency to General... It seems
to ba around the 300th or so row but varies... This problem only occurs if
the client is running Office XP.. And only in our production environment,
not test or dev they are supposed to identical to prod but I doubt that for
obvious reasons...

Can someone tell me why, or give some suggestions as to things to look
at.....???

ASP code;
<%@ LANGUAGE="VBSCR IPT" %>
<% Response.Conten tType = "applicatio n/vnd.ms-excel"
%>

<!--#include virtual="/Include/odbvbs.asp"-->
<!--#INCLUDE VIRTUAL="/Include/wordcap.asp"-->

<%
dim sSql, sloctn, sbrand, sfield, sdate, rs

call ConnInit(cMOTOR )

sloctn = "" & request("txtloc ")
sfield = "" & request("txtfie ld")
sdate = "" & request("txtdat e")
sbrand = "" & request("txtbra nd")

if sfield = "" then sfield = "E"

sSql = "dbo.msp_web_fl oored_units"

if sloctn = "" then
sSql = sSql & " null,"
else
sSql = sSql & " '" & sloctn & "',"
end if
if sdate = "" then
sSql = sSql & " null, '" & sfield & "'"
else
sSql = sSql & " '" & sdate & "', '" & sfield & "'"
end if
if sbrand = "" then
sSql = sSql & ", null"
else
sSql = sSql & ", '" & sbrand & "'"
end if

set rs = obMOTOR.Execute (sSql)
call QueueRS(rs)
%>

<HTML>
<HEAD>
<title>Floor Started Units Not Invoiced</title>
</HEAD>
<!--#INCLUDE VIRTUAL="/Styles/mncweb.css"-->

<body>
<%
if not rs.EOF then
%>
<table border=yes cellspacing=1 cellpadding=1
style="position :absolute;left: 0;top:0;">
<caption>
<font size=3><b>Monac o Coach Corporation<br>
<font size=2>Floor Started Units Not Invoiced</font></b></font>
</caption>
<tr class=bold>
<td align=center valign=bottom style="font-size:8pt">Order No</td>
<td align=center valign=bottom style="font-size:8pt">Unit No</td>
<td align=center valign=bottom style="font-size:8pt">Prod No</td>
<td align=center valign=bottom style="font-size:8pt">Model Type</td>
<td align=center valign=bottom style="font-size:8pt">Deale r</td>
<td align=center valign=bottom style="font-size:8pt">Floor <br>Start</td>
<td align=center valign=bottom
style="font-size:8pt">Estim ated<br>Off-Line</td>
<td align=center valign=bottom style="font-size:8pt">SickB ay</td>
<td align=center valign=bottom style="font-size:8pt">Dispa tch</td>
<td align=center valign=bottom style="font-size:8pt">Floor ed</td>
<td align=center valign=bottom style="font-size:8pt">Floor plan
Comments</td>
<td align=center valign=bottom style="font-size:8pt">Sales Comments</td>
<td align=center valign=bottom
style="font-size:8pt">Whole sale<br>Price</td>

</tr>
<%
dim ford, funit, fprod, ffloor, fsick, fdisp, fflrd, fcmnt, floc
dim fbase, fchas, fmdl, fopt, fdlr, fest, ftotsum, scmnt
dim counter
counter = 0
ftotsum = 0
ftot = 0
do while not rs.EOF
ford = "" & rs("ordno")
funit = rs("unitno")
fprod = "" & rs("prodno")
fmdl = "" & rs("model")
ffloor = "" & rs("floorst")
fest = "" & rs("eoffline")
fsick = "" & rs("sickbay")
fdisp = "" & rs("dispatch")
fflrd = "" & rs("floored")
fcmnt = "" & rs("fcomment")
floc = "" & rs("location")
fbase = rs("base")
fchas = rs("chassis")
fopt = rs("options")
fdlr = "" & rs("cusname")
scmnt = "" & rs("salescommen t")

ftot = fbase + fchas + fopt

ftotsum = ftotsum + ftot

if unitno <> "" then
unitno = CStr(unitno)
'unitno = "'" & unitno
end if
if unitno = "" then unitno = "&nbsp;"
if fsick = "" then fsick = "&nbsp;"
if fdisp = "" then fdisp = "&nbsp;"
if fflrd = "" then fflrd = "&nbsp;"
if fest = "" then fest = "&nbsp;"
if fcmnt = "" then fcmnt = "&nbsp;"
if fmdl = "" then fmdl = "&nbsp;"
if scmnt = "" then scmnt = "&nbsp;"

%>
<tr><td align=left nowrap style="font-size:8pt"><%=fo rd%></td>
<td align=left nowrap style="font-size:8pt">'<%=f unit%></td>
<td align=left nowrap style="font-size:8pt"><%=fp rod%></td>
<td align=left nowrap style="font-size:8pt"><%=Wo rdCap(trim(fmdl ))%></td>
<td align=left nowrap style="font-size:8pt"><%=fd lr%></td>
<td align=left nowrap style="font-size:8pt"><%=ff loor%></td>
<td align=left nowrap style="font-size:8pt"><%=fe st%></td>
<td align=left nowrap style="font-size:8pt"><%=fs ick%></td>
<td align=left nowrap style="font-size:8pt"><%=fd isp%></td>
<td align=left nowrap style="font-size:8pt"><%=ff lrd%></td>
<td align=left nowrap style="font-size:8pt"><%=fc mnt%></td>
<td align=left nowrap style="font-size:8pt"><%=sc mnt%></td>
<td align=left nowrap style="font-size:8pt"><%=fo rmatcurrency(ft ot)%></td>

</tr>
<%
counter = counter + 1
rs.MoveNext
loop
%>
<tr><td align=left colspan=13 style="font-size:8pt">&nbsp ;</td>
</tr>
<tr><td align=left colspan=11 style="font-size:8pt"><b>Nu mber of
Units:</b>&nbsp;<b>&nbs p;<%= counter%></b></td>
<td align=left style="font-size:8pt"><b>To tal:</b></td>
<td align=left nowrap
style="font-size:8pt"><b><% =formatcurrency (ftotsum)%></b></td>
</tr>
</table>
<%
else
%>
<table cellspacing=1 cellpadding=1>
<tr><td>No Units Found
</td>
</tr></table>
<%
end if
rs.close
obCC%>

</BODY>
</HTML>

sp;


CREATE procedure dbo.msp_web_flo ored_units (@loc char(06) = null,
@fdate datetime = null,
@dtype char(01),
@brand char(02) = null)
as
create table #floor
(ordno int,
unitno char(20),
prodno int,
cusgrp varchar(06),
cuscd varchar(10),
floorst datetime,
sickbay datetime,
dispatch datetime,
floored datetime,
fcomment char(25),
location char(06),
eoffline datetime,
base money,
chassis money,
options money,
cusname varchar(30),
model varchar(40),
brand char(02),
salescomment varchar(20))

if @loc is not null
begin
insert #floor
SELECT dbo.HR_ORDDET.O RDD_ORD_NO,
dbo.HR_ORDDET.O RDD_UNIT_NO,
dbo.HR_ORDDET.P ROD_NO,
dbo.ord.ord_cus _grp,
dbo.ord.ord_cus _cd,
dbo.HR_ORDDET.O RDD_FLOOR_START _DT,
dbo.HR_ORDDET.O RDD_SICKBAY_DT,
dbo.HR_ORDDET.O RDD_DISPATCH_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_CMN T,
dbo.HR_ORDDET.O RDD_SCHEDULED_L OCATION,
dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT,
IsNull(dbo.HR_O RDDET.ORDD_BASE _PRICE, 0.00) AS ORDD_BASE_PRICE ,
IsNull(dbo.HR_O RDDET.ORDD_CHAS SIS_PRICE, 0.00) AS
ORDD_CHASSIS_PR ICE,
IsNull(dbo.HR_O RDDET.ORDD_OPTI ON_PRICE, 0.00) AS
ORDD_OPTION_PRI CE,
null,
null,
dbo.model_maste r.mm_corp_cd,
dbo.ord.ord_cus _ord
FROM dbo.HR_ORDDET (nolock)
INNER JOIN dbo.ord (nolock) on dbo.HR_ORDDET.O RDD_ORD_CO =
dbo.ord.ord_com pany and dbo.HR_ORDDET.O RDD_ORD_NO = dbo.ord.ord_no
INNER JOIN dbo.model_maste r (nolock) on dbo.HR_ORDDET.O RDD_UNIT_NO =
dbo.model_maste r.sku_cd
WHERE ( (@dtype = 'E' and dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT is not
null) or
(@dtype = 'F' and dbo.HR_ORDDET.O RDD_FLOOR_START _DT is not null))
and dbo.HR_ORDDET.O RDD_INVOICED_DT is null
and dbo.HR_ORDDET.O RDD_SCHEDULED_L OCATION = @loc

end
else
begin
insert #floor
SELECT dbo.HR_ORDDET.O RDD_ORD_NO,
dbo.HR_ORDDET.O RDD_UNIT_NO,
dbo.HR_ORDDET.P ROD_NO,
dbo.ord.ord_cus _grp,
dbo.ord.ord_cus _cd,
dbo.HR_ORDDET.O RDD_FLOOR_START _DT,
dbo.HR_ORDDET.O RDD_SICKBAY_DT,
dbo.HR_ORDDET.O RDD_DISPATCH_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_CMN T,
dbo.HR_ORDDET.O RDD_SCHEDULED_L OCATION,
dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT,
IsNull(dbo.HR_O RDDET.ORDD_BASE _PRICE, 0.00) AS ORDD_BASE_PRICE ,
IsNull(dbo.HR_O RDDET.ORDD_CHAS SIS_PRICE, 0.00) AS
ORDD_CHASSIS_PR ICE,
IsNull(dbo.HR_O RDDET.ORDD_OPTI ON_PRICE, 0.00) AS
ORDD_OPTION_PRI CE,
null,
null,
dbo.model_maste r.mm_corp_cd,
dbo.ord.ord_cus _ord
FROM dbo.HR_ORDDET (nolock)
INNER JOIN dbo.ord (nolock) ON dbo.HR_ORDDET.O RDD_ORD_CO =
dbo.ord.ord_com pany and dbo.HR_ORDDET.O RDD_ORD_NO = dbo.ord.ord_no
INNER JOIN dbo.model_maste r (nolock) ON dbo.HR_ORDDET.O RDD_UNIT_NO =
dbo.model_maste r.sku_cd
WHERE ( (@dtype = 'E' and dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT is not
null) or
(@dtype = 'F' and dbo.HR_ORDDET.O RDD_FLOOR_START _DT is not null) )
and dbo.HR_ORDDET.O RDD_INVOICED_DT is null

end

if @fdate is not null
begin
if @dtype = 'E'
begin
delete #floor
where eoffline >= @fdate
end
else if @dtype = 'F'
begin
delete #floor
where floorst >= @fdate
end
end

update #floor
set cusname = b.cus_name
from #floor a (nolock)
inner join customer b (nolock)
on a.cuscd = b.cus_cd
and a.cusgrp = b.cus_grp_cd

update #floor
set model = b.model_desc

from #floor a (nolock)
inner join model b (nolock)
on substring(a.uni tno,5,4) = b.model_code

if @brand is null
begin
select *
from #floor
order by location, cusname, model
end
else if @brand in ('HR','BC','SC' )
begin
select *
from #floor
where brand = @brand
order by location, cusname, model
end
else if @brand = 'MC'
begin
select *
from #floor
where brand = 'MC'
and substring(unitn o,5,4) > '1500'
order by location, cusname, model
end
else if @brand = 'MK'
begin
select *
from #floor
where brand = 'MC'
and substring(unitn o,5,4) < '1500'
order by location, cusname, model
end


GO
Jul 19 '05 #1
1 1991
I figured out what's happening... The data in an unrelated column contains a
"-" sign when Excel encounters and I assume tries to determine its datatype
it can't continue and fails to determine the correct data type for the
remaining columns and rows...

This seems to be a Microsoft bug in Office XP... Does anyone know of this...
Where can I submit...?

"alien2_51" <da********@n.o .s.p.a.m.monaco coach.com> wrote in message
news:##******** ******@TK2MSFTN GP10.phx.gbl...
At some point after running this report the "Wholesale Price" column data
type in the excel spread sheet changes from Currency to General... It seems to ba around the 300th or so row but varies... This problem only occurs if
the client is running Office XP.. And only in our production environment,
not test or dev they are supposed to identical to prod but I doubt that for obvious reasons...

Can someone tell me why, or give some suggestions as to things to look
at.....???

ASP code;
<%@ LANGUAGE="VBSCR IPT" %>
<% Response.Conten tType = "applicatio n/vnd.ms-excel"
%>

<!--#include virtual="/Include/odbvbs.asp"-->
<!--#INCLUDE VIRTUAL="/Include/wordcap.asp"-->

<%
dim sSql, sloctn, sbrand, sfield, sdate, rs

call ConnInit(cMOTOR )

sloctn = "" & request("txtloc ")
sfield = "" & request("txtfie ld")
sdate = "" & request("txtdat e")
sbrand = "" & request("txtbra nd")

if sfield = "" then sfield = "E"

sSql = "dbo.msp_web_fl oored_units"

if sloctn = "" then
sSql = sSql & " null,"
else
sSql = sSql & " '" & sloctn & "',"
end if
if sdate = "" then
sSql = sSql & " null, '" & sfield & "'"
else
sSql = sSql & " '" & sdate & "', '" & sfield & "'"
end if
if sbrand = "" then
sSql = sSql & ", null"
else
sSql = sSql & ", '" & sbrand & "'"
end if

set rs = obMOTOR.Execute (sSql)
call QueueRS(rs)
%>

<HTML>
<HEAD>
<title>Floor Started Units Not Invoiced</title>
</HEAD>
<!--#INCLUDE VIRTUAL="/Styles/mncweb.css"-->

<body>
<%
if not rs.EOF then
%>
<table border=yes cellspacing=1 cellpadding=1
style="position :absolute;left: 0;top:0;">
<caption>
<font size=3><b>Monac o Coach Corporation<br>
<font size=2>Floor Started Units Not Invoiced</font></b></font> </caption>
<tr class=bold>
<td align=center valign=bottom style="font-size:8pt">Order No</td>
<td align=center valign=bottom style="font-size:8pt">Unit No</td>
<td align=center valign=bottom style="font-size:8pt">Prod No</td>
<td align=center valign=bottom style="font-size:8pt">Model Type</td>
<td align=center valign=bottom style="font-size:8pt">Deale r</td>
<td align=center valign=bottom style="font-size:8pt">Floor <br>Start</td>
<td align=center valign=bottom
style="font-size:8pt">Estim ated<br>Off-Line</td>
<td align=center valign=bottom style="font-size:8pt">SickB ay</td>
<td align=center valign=bottom style="font-size:8pt">Dispa tch</td>
<td align=center valign=bottom style="font-size:8pt">Floor ed</td>
<td align=center valign=bottom style="font-size:8pt">Floor plan
Comments</td>
<td align=center valign=bottom style="font-size:8pt">Sales Comments</td>
<td align=center valign=bottom
style="font-size:8pt">Whole sale<br>Price</td>

</tr>
<%
dim ford, funit, fprod, ffloor, fsick, fdisp, fflrd, fcmnt, floc
dim fbase, fchas, fmdl, fopt, fdlr, fest, ftotsum, scmnt
dim counter
counter = 0
ftotsum = 0
ftot = 0
do while not rs.EOF
ford = "" & rs("ordno")
funit = rs("unitno")
fprod = "" & rs("prodno")
fmdl = "" & rs("model")
ffloor = "" & rs("floorst")
fest = "" & rs("eoffline")
fsick = "" & rs("sickbay")
fdisp = "" & rs("dispatch")
fflrd = "" & rs("floored")
fcmnt = "" & rs("fcomment")
floc = "" & rs("location")
fbase = rs("base")
fchas = rs("chassis")
fopt = rs("options")
fdlr = "" & rs("cusname")
scmnt = "" & rs("salescommen t")

ftot = fbase + fchas + fopt

ftotsum = ftotsum + ftot

if unitno <> "" then
unitno = CStr(unitno)
'unitno = "'" & unitno
end if
if unitno = "" then unitno = "&nbsp;"
if fsick = "" then fsick = "&nbsp;"
if fdisp = "" then fdisp = "&nbsp;"
if fflrd = "" then fflrd = "&nbsp;"
if fest = "" then fest = "&nbsp;"
if fcmnt = "" then fcmnt = "&nbsp;"
if fmdl = "" then fmdl = "&nbsp;"
if scmnt = "" then scmnt = "&nbsp;"

%>
<tr><td align=left nowrap style="font-size:8pt"><%=fo rd%></td>
<td align=left nowrap style="font-size:8pt">'<%=f unit%></td>
<td align=left nowrap style="font-size:8pt"><%=fp rod%></td>
<td align=left nowrap style="font-size:8pt"><%=Wo rdCap(trim(fmdl ))%></td> <td align=left nowrap style="font-size:8pt"><%=fd lr%></td>
<td align=left nowrap style="font-size:8pt"><%=ff loor%></td>
<td align=left nowrap style="font-size:8pt"><%=fe st%></td>
<td align=left nowrap style="font-size:8pt"><%=fs ick%></td>
<td align=left nowrap style="font-size:8pt"><%=fd isp%></td>
<td align=left nowrap style="font-size:8pt"><%=ff lrd%></td>
<td align=left nowrap style="font-size:8pt"><%=fc mnt%></td>
<td align=left nowrap style="font-size:8pt"><%=sc mnt%></td>
<td align=left nowrap style="font-size:8pt"><%=fo rmatcurrency(ft ot)%></td>
</tr>
<%
counter = counter + 1
rs.MoveNext
loop
%>
<tr><td align=left colspan=13 style="font-size:8pt">&nbsp ;</td>
</tr>
<tr><td align=left colspan=11 style="font-size:8pt"><b>Nu mber of
Units:</b>&nbsp;<b>&nbs p;<%= counter%></b></td>
<td align=left style="font-size:8pt"><b>To tal:</b></td>
<td align=left nowrap
style="font-size:8pt"><b><% =formatcurrency (ftotsum)%></b></td>
</tr>
</table>
<%
else
%>
<table cellspacing=1 cellpadding=1>
<tr><td>No Units Found
</td>
</tr></table>
<%
end if
rs.close
obCC%>

</BODY>
</HTML>

sp;


CREATE procedure dbo.msp_web_flo ored_units (@loc char(06) = null,
@fdate datetime = null,
@dtype char(01),
@brand char(02) = null)
as
create table #floor
(ordno int,
unitno char(20),
prodno int,
cusgrp varchar(06),
cuscd varchar(10),
floorst datetime,
sickbay datetime,
dispatch datetime,
floored datetime,
fcomment char(25),
location char(06),
eoffline datetime,
base money,
chassis money,
options money,
cusname varchar(30),
model varchar(40),
brand char(02),
salescomment varchar(20))

if @loc is not null
begin
insert #floor
SELECT dbo.HR_ORDDET.O RDD_ORD_NO,
dbo.HR_ORDDET.O RDD_UNIT_NO,
dbo.HR_ORDDET.P ROD_NO,
dbo.ord.ord_cus _grp,
dbo.ord.ord_cus _cd,
dbo.HR_ORDDET.O RDD_FLOOR_START _DT,
dbo.HR_ORDDET.O RDD_SICKBAY_DT,
dbo.HR_ORDDET.O RDD_DISPATCH_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_CMN T,
dbo.HR_ORDDET.O RDD_SCHEDULED_L OCATION,
dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT,
IsNull(dbo.HR_O RDDET.ORDD_BASE _PRICE, 0.00) AS ORDD_BASE_PRICE ,
IsNull(dbo.HR_O RDDET.ORDD_CHAS SIS_PRICE, 0.00) AS
ORDD_CHASSIS_PR ICE,
IsNull(dbo.HR_O RDDET.ORDD_OPTI ON_PRICE, 0.00) AS
ORDD_OPTION_PRI CE,
null,
null,
dbo.model_maste r.mm_corp_cd,
dbo.ord.ord_cus _ord
FROM dbo.HR_ORDDET (nolock)
INNER JOIN dbo.ord (nolock) on dbo.HR_ORDDET.O RDD_ORD_CO =
dbo.ord.ord_com pany and dbo.HR_ORDDET.O RDD_ORD_NO = dbo.ord.ord_no
INNER JOIN dbo.model_maste r (nolock) on dbo.HR_ORDDET.O RDD_UNIT_NO =
dbo.model_maste r.sku_cd
WHERE ( (@dtype = 'E' and dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT is not
null) or
(@dtype = 'F' and dbo.HR_ORDDET.O RDD_FLOOR_START _DT is not null))
and dbo.HR_ORDDET.O RDD_INVOICED_DT is null
and dbo.HR_ORDDET.O RDD_SCHEDULED_L OCATION = @loc

end
else
begin
insert #floor
SELECT dbo.HR_ORDDET.O RDD_ORD_NO,
dbo.HR_ORDDET.O RDD_UNIT_NO,
dbo.HR_ORDDET.P ROD_NO,
dbo.ord.ord_cus _grp,
dbo.ord.ord_cus _cd,
dbo.HR_ORDDET.O RDD_FLOOR_START _DT,
dbo.HR_ORDDET.O RDD_SICKBAY_DT,
dbo.HR_ORDDET.O RDD_DISPATCH_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_DT ,
dbo.HR_ORDDET.O RDD_FLOORED_CMN T,
dbo.HR_ORDDET.O RDD_SCHEDULED_L OCATION,
dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT,
IsNull(dbo.HR_O RDDET.ORDD_BASE _PRICE, 0.00) AS ORDD_BASE_PRICE ,
IsNull(dbo.HR_O RDDET.ORDD_CHAS SIS_PRICE, 0.00) AS
ORDD_CHASSIS_PR ICE,
IsNull(dbo.HR_O RDDET.ORDD_OPTI ON_PRICE, 0.00) AS
ORDD_OPTION_PRI CE,
null,
null,
dbo.model_maste r.mm_corp_cd,
dbo.ord.ord_cus _ord
FROM dbo.HR_ORDDET (nolock)
INNER JOIN dbo.ord (nolock) ON dbo.HR_ORDDET.O RDD_ORD_CO =
dbo.ord.ord_com pany and dbo.HR_ORDDET.O RDD_ORD_NO = dbo.ord.ord_no
INNER JOIN dbo.model_maste r (nolock) ON dbo.HR_ORDDET.O RDD_UNIT_NO =
dbo.model_maste r.sku_cd
WHERE ( (@dtype = 'E' and dbo.HR_ORDDET.O RDD_EST_OFFLINE _DT is not
null) or
(@dtype = 'F' and dbo.HR_ORDDET.O RDD_FLOOR_START _DT is not null) )
and dbo.HR_ORDDET.O RDD_INVOICED_DT is null

end

if @fdate is not null
begin
if @dtype = 'E'
begin
delete #floor
where eoffline >= @fdate
end
else if @dtype = 'F'
begin
delete #floor
where floorst >= @fdate
end
end

update #floor
set cusname = b.cus_name
from #floor a (nolock)
inner join customer b (nolock)
on a.cuscd = b.cus_cd
and a.cusgrp = b.cus_grp_cd

update #floor
set model = b.model_desc

from #floor a (nolock)
inner join model b (nolock)
on substring(a.uni tno,5,4) = b.model_code

if @brand is null
begin
select *
from #floor
order by location, cusname, model
end
else if @brand in ('HR','BC','SC' )
begin
select *
from #floor
where brand = @brand
order by location, cusname, model
end
else if @brand = 'MC'
begin
select *
from #floor
where brand = 'MC'
and substring(unitn o,5,4) > '1500'
order by location, cusname, model
end
else if @brand = 'MK'
begin
select *
from #floor
where brand = 'MC'
and substring(unitn o,5,4) < '1500'
order by location, cusname, model
end


GO

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2033
by: middletree | last post by:
I did a search in this forum, as well as at www.asp.faq.com, and MSDN, and would like to know how to use ASP to build a report and create an .xls file as a result. I've seen lots of tutorials that are for developers who know some basics that I don't know. Assuming I know ASP, and can use Excel the normal way, can anyone point me to a tutorial or set of instructions that will get me up and running?
2
1792
by: mr.kuhl | last post by:
I thought I would contribute a solution for once. We have a standard SUSE LAMP (Linux Apache Mysql PHP) server running some custom apps, of which one component is dumping reports out to excel. We are running this with https and all was good for a few months. IE6 and Firefox worked fine. One day around the end of July 2005, IE6 stops doing the excel part.. Excel errors out with a "Could not open 'https://blah.com?report.php'" . ...
9
4037
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then need to input this in an Access database, where I do a comparison with the Actual cost. The table “TblBudget” in Access is made of 4 fields, namely: (1) CostElement (2) CostCenter (3) Month (4) Amount$. At the moment this method is very cumbersome....
4
7458
by: chengsi | last post by:
I have based a report on a crosstab query. This query has eliminated all formats, i.e. all fields including those containing numbers are now stored as text. Is there a way that i can get Access to reformat these 'text' fields as currency or standard 1,234,567 notation on the final report? Thanks.
10
3128
by: Esmael | last post by:
Hi to all, /*****************************/ OS-WIn XP SP2 VB6 SP6 /*****************************/ Is their anyone who can help me with this: Source code written on VB6.
15
5365
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post by:
Hi All, We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007 (Office 2007) for one of web application. This web application is using Excel (Pivot Table) reports. With Excel 2003 application (Reports) works ok. But when Office 2003 is upgraded to Office 2007 Excel reports stops working. It Log the error “Exception from HRESULT: 0x800A03EC.” In database.
0
1880
by: amiga500 | last post by:
Hello, I am developing a crystal report called Expense Report (I am not an expert Crystal Report designer) if someone could help me in this problem I would be greatly appreciate it. The report would be as follows: Description Sun Mon
15
9447
by: patf | last post by:
Hi - experienced programmer but this is my first Python program. This URL will retrieve an excel spreadsheet containing (that day's) msci stock index returns. http://www.mscibarra.com/webapp/indexperf/excel?priceLevel=0&scope=0&currency=15&style=C&size=36&market=1897&asOf=Jul+25%2C+2008&export=Excel_IEIPerfRegional Want to write python to download and save the file. So far I've arrived at this:
3
11650
by: nandithadevaraj | last post by:
When exporting a report to excel, is it possible to keep the properties around numeric values? More specifically - when exporting a report into excel, all of the numbers in a currency column are stored as text once placed into excel. Is there a way to keep them as a currency value? Regards, Nanditha
0
9810
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of...
0
10815
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10236
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7768
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6968
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5639
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5805
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3997
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3092
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.