Ценник с маркетинговой ценой и сроками проведения акции : Супермаг Плюс (Супермаг 2000)

SELECT	t_pr.article article,
			t_pr.name name,
			t_pr.cardcomment cardcomment,
			t_pr.country country,
			t_pr.price price,
			sp.itemprice price_ma,
			t_pr.qtyprint qtyprint,
			t_pr.unitname unitname,
			t_pr.isscale isscale,
			t_pr.plu plu,
			d.id ma_id,
			TRUNC (au.datebegin) ma_datebegin,
			TRUNC (au.dateend) ma_dateend
	 FROM supermag.svpricecard t_pr,
			supermag.smdocuments d,
			supermag.smspec sp,
			supermag.smauctions au
	WHERE t_pr.article = sp.article
			AND d.doctype = 'MA'
			AND d.id = sp.docid
			AND d.doctype = sp.doctype
			AND t_pr.article = sp.article
			AND d.id = au.id
			AND d.doctype = au.doctype
			AND d.docstate = 2
			AND au.datebegin >= TRUNC (SYSDATE)
			AND :P_LOC IN (SELECT locid
					  FROM supermag.smauctionatoms am
					 WHERE am.aucid = d.id AND am.doctype = d.doctype)
ORDER BY ma_id, article;

2015.01.12 (Monday) 10:56:29
----- Прерывание работы программы -----
сообщение: "Неправильный результат из-за исключения, возникшего во время операции.  См. описание исключения в InnerException."
исключение: System.Reflection.TargetInvocationException
источник: System
метод: Void RaiseExceptionIfNecessary()
   в System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
   в Sm.Core.RunWorkerCompletedEventArgs`1.get_Result()
   в Sm.FastReports.Domain.FastReportDomainPanel.<>c__DisplayClass2.<RunSingleReport>b__0(Object sender, RunWorkerCompletedEventArgs`1 e)
----- Причина исключения, уровень вложения 1 -----
сообщение: "TextFixedPrice: Error in expression: MA.PRICE"
исключение: System.Exception
источник: FastReport.Engine
метод: System.String CalcAndFormatExpression(System.String, Int32)
   в FastReport.TextObjectBase.CalcAndFormatExpression(String expression, Int32 expressionIndex)
   в FastReport.TextObject.GetData()
   в FastReport.BandBase.GetData()
   в FastReport.Engine.ReportEngine.PrepareBand(BandBase band, Boolean getData)
   в FastReport.Engine.ReportEngine.AddToOutputBand(BandBase band, Boolean getData)
   в FastReport.Engine.ReportEngine.ShowBand(BandBase band, Boolean getData)
   в FastReport.Engine.ReportEngine.ShowBand(BandBase band, BandBase outputBand, Single offsetX, Single offsetY)
   в FastReport.Engine.ReportEngine.RenderBandAcrossThenDown(DataBand dataBand, Int32 rowCount)
   в FastReport.Engine.ReportEngine.RenderMultiColumnBand(DataBand dataBand, Int32 rowCount)
   в FastReport.Engine.ReportEngine.ShowDataBand(DataBand dataBand, Int32 rowCount)
   в FastReport.Engine.ReportEngine.RunDataBand(DataBand dataBand, Int32 rowCount, Boolean keepFirstRow, Boolean keepLastRow)
   в FastReport.Engine.ReportEngine.RunDataBand(DataBand dataBand)
   в FastReport.Engine.ReportEngine.RunBands(BandCollection bands)
   в FastReport.Engine.ReportEngine.RunReportPage(ReportPage page)
   в FastReport.Engine.ReportEngine.RunReportPages()
   в FastReport.Engine.ReportEngine.RunReportPages(ReportPage page)
   в FastReport.Engine.ReportEngine.Run(Boolean runDialogs, Boolean append, ReportPage page)
   в FastReport.Report.Prepare(Boolean append)
   в Sm.FastReports.Domain.FastReportDomainModel.ExecuteReport(Report report, String reportFile, List`1 commonParameters, List`1 objectParameters, Int32 moduleRole, Int32 functionRole)
   в Sm.FastReports.Domain.FastReportDomainPanel.Report_DoWork(Object sender, TaskWorkEventArgs`3 e)
   в Sm.Core.TaskWorker`3.OnDoWork(DoWorkEventArgs e)
   в Sm.Core.TaskWorkerBase.InternalBackgroundWorker.OnDoWork(DoWorkEventArgs e)
   в System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)