Click here to Skip to main content
15,922,584 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionCreateObject("WindowsInstaller.Installer") Error Pin
Sysdoc262821-Feb-06 12:18
Sysdoc262821-Feb-06 12:18 
Questioncreating multiple dataset based on query Pin
uglyeyes21-Feb-06 12:00
uglyeyes21-Feb-06 12:00 
AnswerRe: creating multiple dataset based on query Pin
ne0h21-Feb-06 21:16
ne0h21-Feb-06 21:16 
QuestionVlookup function like excel Pin
Sergi2521-Feb-06 11:41
Sergi2521-Feb-06 11:41 
AnswerRe: Vlookup function like excel Pin
Ray Cassick21-Feb-06 11:48
Ray Cassick21-Feb-06 11:48 
QuestionInheritence, disallow ShowDialog() Pin
K. Shaffer21-Feb-06 8:59
K. Shaffer21-Feb-06 8:59 
AnswerRe: Inheritence, disallow ShowDialog() Pin
K. Shaffer21-Feb-06 9:09
K. Shaffer21-Feb-06 9:09 
QuestionVS 2003 to VS 2005 Crystal Reports Hell problems Pin
nordico2521-Feb-06 7:41
nordico2521-Feb-06 7:41 
I use DB2 under AS/400 and the “SLTFORMULARIO_MG” stored procedure really exists.

Ok... because we don’t have that much time to spend, I tried another solution. I did remove the link between the stored procedure and the RPT file and so, I did set up one xml datasouce. So, I putted the stored procedure returns into a dataset and did use as:

<br />
oRpt = New ReportDocument<br />
	oRpt.Load(_sFileRPT)<br />
<br />
       oRpt.SetDataSource(_dtDados)<br />

Ok, the code ran nice and quickly, but because I can go to heave straightway. I still have a problem when using formulae to perform calculation. I got this damn error:

MENSAGEM DE ERRO: 
A number, or currency amount is required here.
Error in File C:\DOCUME~1\BRRIOW~1\ASPNET\LOCALS~1\Temp\PEDIDO_SA {8885AC00-192E-4A1D-9E2A-A38289AEA818}.rpt:
Error in formula  <UNITxVALOR>. 
' ({SLTFORMULARIO_SA.PRECO_UNIT}) * {SLTFORMULARIO_SA.QTD_PEDIDA} '
A number, or currency amount is required here.

STACK TRACE: 
   at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
   at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)



Right, Right, I did many tests and when I changed the code from:

({SLTFORMULARIO_SA.PRECO_UNIT}) * {SLTFORMULARIO_SA.QTD_PEDIDA}

To:

({SLTFORMULARIO_SA.PRECO_UNIT}) + {SLTFORMULARIO_SA.QTD_PEDIDA}


It was fine, except from the fact that it was catenated instead of added.


Anyone could, please, help me up?
QuestionCrystal reports via VB.Net Pin
directred21-Feb-06 7:29
directred21-Feb-06 7:29 
QuestionSending HTML emails with MAPI (VB6) Pin
ThePmanLives21-Feb-06 5:47
ThePmanLives21-Feb-06 5:47 
Questionsearching through a site Pin
teuneboon21-Feb-06 4:38
teuneboon21-Feb-06 4:38 
AnswerRe: searching through a site Pin
Divya Rathi22-Feb-06 3:55
Divya Rathi22-Feb-06 3:55 
QuestionUsing a digital camera in my VB project Pin
marclenoir200521-Feb-06 4:16
marclenoir200521-Feb-06 4:16 
QuestionIs there a way to do a spell check on a text box Pin
New_Coder21-Feb-06 3:59
New_Coder21-Feb-06 3:59 
AnswerRe: Is there a way to do a spell check on a text box Pin
uglyeyes21-Feb-06 12:05
uglyeyes21-Feb-06 12:05 
GeneralRe: Is there a way to do a spell check on a text box Pin
New_Coder21-Feb-06 12:12
New_Coder21-Feb-06 12:12 
Questionhow can we use ms agent control in a vb windows application? Pin
kamalika_kk21-Feb-06 3:54
kamalika_kk21-Feb-06 3:54 
AnswerRe: how can we use ms agent control in a vb windows application? Pin
Steve Pullan21-Feb-06 13:46
Steve Pullan21-Feb-06 13:46 
Questionusername filepath Pin
racebit21-Feb-06 3:10
racebit21-Feb-06 3:10 
AnswerRe: username filepath Pin
Dave Kreskowiak21-Feb-06 6:02
mveDave Kreskowiak21-Feb-06 6:02 
Questionwindows application Pin
illamamatha21-Feb-06 1:48
illamamatha21-Feb-06 1:48 
AnswerRe: windows application Pin
sathish s21-Feb-06 2:03
sathish s21-Feb-06 2:03 
QuestionMetafile & Drag/Drop Pin
A L21-Feb-06 0:22
A L21-Feb-06 0:22 
QuestionTransparent Bitmaps Pin
Chatura Dilan20-Feb-06 23:07
Chatura Dilan20-Feb-06 23:07 
QuestionConvert into VB Pin
Chiari20-Feb-06 21:48
Chiari20-Feb-06 21:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.