Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey, when trying to load Sage data into PowerBI using the ODBC we are getting this error:
Any ideas?
Feedback Type: Frown (Error) Error Message: Value cannot be null. Parameter name: exceptionType Stack Trace: at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeScript(Func`1 invokeScript) at Microsoft.Mashup.Client.UI.Windows.JsHostedScript.TryInvoke[T](String script, T& result) at Microsoft.Mashup.Client.UI.Windows.JsHostedScript.TryInvoke(String script) at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.SetPreview(String preview) at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.OnGetPreview(PreviewResult preview) at Microsoft.Mashup.Client.UI.Shared.Ux.Navigator.QueryNavigatorPreviewHost.<>c__DisplayClass17_0.<SetPreviewFromQuery>b__1(PreviewReference preview) at Microsoft.Mashup.Host.Document.Evaluation.PreviewEvaluationQueue.<>c__DisplayClass48_0.<OnPreviewComplete>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) Stack Trace Message: Value cannot be null. Parameter name: exceptionType Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, IUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, IWebTableImporterHost webTableImporterHost) at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query) at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries) at Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query) at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor) at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination) at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass76_1.<OnQuerySettingsResolved>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args) InnerException.Stack Trace Message: Value cannot be null. Parameter name: exceptionType InnerException.Stack Trace: Error: Value cannot be null. Parameter name: exceptionType at QueryNavigatorPreviewViewHost.prototype._onRenderPreview (ms-pbi://pbi.microsoft.com/ts/Navigator/QueryNavigatorPreviewViewHost.js:178:17) at ResultViewHost.prototype._onRefreshSuccess (ms-pbi://pbi.microsoft.com/ts/Shared/ResultViews/ResultViewHost.js:265:13) at ResultViewHost.prototype.setPreviewContent (ms-pbi://pbi.microsoft.com/ts/Shared/ResultViews/ResultViewHost.js:53:13) at QueryNavigatorPreviewViewHost.prototype.setPreview (ms-pbi://pbi.microsoft.com/ts/Navigator/QueryNavigatorPreviewViewHost.js:81:17) at eval code (eval code:1:1) InnerException.Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e) at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, IUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, IWebTableImporterHost webTableImporterHost) at Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query) at Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries) at Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query) at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor) at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination) at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass76_1.<OnQuerySettingsResolved>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args) Model Default Mode: Empty Snapshot Trace Logs: C:\Users\jono\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1036508711.zip Performance Trace Logs: C:\Users\jono\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_NewWebTableInference PBI_showIncrementalRefreshPolicy PBI_showManageAggregations PBI_improvedFilterExperience PBI_qnaLiveConnect PBI_keyDrivers Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud Formulas: section Section1; shared AUDIT_HISTORY_SPLIT = let Source = Odbc.DataSource("userid=accounts;dsn=SEL 2", [HierarchicalNavigation=true]), AUDIT_HISTORY_SPLIT_Table = Source{[Name="AUDIT_HISTORY_SPLIT",Kind="Table"]}[Data] in AUDIT_HISTORY_SPLIT_Table; shared #"NavigatorBase_151a3e0d-a52b-4142-8370-24156e6bdc07" = let Source = Odbc.DataSource("dsn=SEL 2", [HierarchicalNavigation=true]) in Source;
Hey,
Yes it is and haven't added anything at present
You'll need to enter a SQL statement for Power BI to connect, the Sage ODBC driver works fine with MS Query via Excel but with Power Query you need to be quite explicit; also in my experience attempting to retrieve [TABLE NAME].RECORD_CREATE_DATE, [TABLE NAME].RECORD_MODIFY_DATE results in errors as well, so you'll probably want to avoid them.
I'm an ex-techie for Sage and used to do report design, I don't quite know what you are attempting to get from the AUDIT_HISTORY_SPLIT table, when I queried Demo data it was blank but that could just be the Demo data.
As an example for the AUDIT_HEADER table the SQL statement you'll want to use is;
SELECT AUDIT_HEADER.TRAN_NUMBER, AUDIT_HEADER.ITEM_COUNT, AUDIT_HEADER.TYPE, AUDIT_HEADER.DATE, AUDIT_HEADER.ACCOUNT_REF, AUDIT_HEADER.SALES_PURCHASE_REF, AUDIT_HEADER.BANK_CODE, AUDIT_HEADER.BANK_NAME, AUDIT_HEADER.INV_REF, AUDIT_HEADER.INV_REF_NUMERIC, AUDIT_HEADER.USER_NAME, AUDIT_HEADER.DETAILS, AUDIT_HEADER.DUE_DATE, AUDIT_HEADER.LAST_CHARGE_DATE, AUDIT_HEADER.FINANCE_CHARGE, AUDIT_HEADER.INTEREST_RATE, AUDIT_HEADER.ELECTRONIC_TRANS, AUDIT_HEADER.DISPUTED, AUDIT_HEADER.PAID_FLAG, AUDIT_HEADER.PAID_STATUS, AUDIT_HEADER.DELETED_FLAG, AUDIT_HEADER.DATE_FLAG, AUDIT_HEADER.DATE_BF, AUDIT_HEADER.DATE_FROM, AUDIT_HEADER.DATE_TO, AUDIT_HEADER.NET_AMOUNT, AUDIT_HEADER.TAX_AMOUNT, AUDIT_HEADER.GROSS_AMOUNT, AUDIT_HEADER.BANK_AMOUNT, AUDIT_HEADER.AMOUNT_PAID, AUDIT_HEADER.PAYMENT, AUDIT_HEADER.OUTSTANDING, AUDIT_HEADER.FOREIGN_OUTSTANDING, AUDIT_HEADER.FOREIGN_NET_AMOUNT, AUDIT_HEADER.FOREIGN_TAX_AMOUNT, AUDIT_HEADER.FOREIGN_GROSS_AMOUNT, AUDIT_HEADER.FOREIGN_AMOUNT_PAID, AUDIT_HEADER.FOREIGN_BANK_AMOUNT, AUDIT_HEADER.CURRENCY, AUDIT_HEADER.CURRENCY_TYPE, AUDIT_HEADER.EURO_GROSS, AUDIT_HEADER.EURO_RATE, AUDIT_HEADER.FOREIGN_RATE, AUDIT_HEADER.IS_DISCOUNT, AUDIT_HEADER.AGED_BALANCE, AUDIT_HEADER.AGED_FUTURE, AUDIT_HEADER.AGED_CURRENT, AUDIT_HEADER.AGED_30, AUDIT_HEADER.AGED_60, AUDIT_HEADER.AGED_90, AUDIT_HEADER.AGED_OLDER, AUDIT_HEADER.AGED_CUM_CURRENT, AUDIT_HEADER.AGED_CUM_30, AUDIT_HEADER.AGED_CUM_60, AUDIT_HEADER.AGED_CUM_90, AUDIT_HEADER.FOREIGN_AGED_BALANCE, AUDIT_HEADER.FOREIGN_AGED_FUTURE, AUDIT_HEADER.FOREIGN_AGED_CURRENT, AUDIT_HEADER.FOREIGN_AGED_30, AUDIT_HEADER.FOREIGN_AGED_60, AUDIT_HEADER.FOREIGN_AGED_90, AUDIT_HEADER.FOREIGN_AGED_OLDER, AUDIT_HEADER.FOREIGN_AGED_CUM_CURRENT, AUDIT_HEADER.FOREIGN_AGED_CUM_30, AUDIT_HEADER.FOREIGN_AGED_CUM_60, AUDIT_HEADER.FOREIGN_AGED_CUM_90, AUDIT_HEADER.BANK_FLAG, AUDIT_HEADER.HEADER_NUMBER, AUDIT_HEADER.DATE_ENTERED, AUDIT_HEADER.DATE_BANK_RECONCILED, AUDIT_HEADER.CIS_RECONCILED, AUDIT_HEADER.SPS_REF, AUDIT_HEADER.DEPOSIT_DATE, AUDIT_HEADER.DEPOSIT_FLAG, AUDIT_HEADER.RECURRING_ENTRY_ID, AUDIT_HEADER.ISP_REFERENCE, AUDIT_HEADER.OVERRIDDEN_CLOSED_LEDGER_DATE, AUDIT_HEADER.COUNTRY_CODE, AUDIT_HEADER.TAX_ID, AUDIT_HEADER.REVAL_TRANSACTION_FLAG, AUDIT_HEADER.POSTED_BY_DIRECT_DEBIT_SETTLEMENT, AUDIT_HEADER.DATE_AMENDED, AUDIT_HEADER.USER_NAME_AMENDED, AUDIT_HEADER.BANK_CHARGE_ACCOUNT, AUDIT_HEADER.BANK_CHARGE_IS_CUSTOMER, AUDIT_HEADER.IS_INVOICE_PAYMENT, AUDIT_HEADER.BANK_RECONCILIATION_REF, AUDIT_HEADER.BANK_RECONCILIATION_ID, AUDIT_HEADER.RECORD_DELETED FROM AUDIT_HEADER AUDIT_HEADER ORDER BY AUDIT_HEADER.TRAN_NUMBER
The best place to find the column names for each table would probably be the Sage Report Designer software. Open a report that does something similar to what you want to achieve in Power BI, then click Report and then Joins. The Join Editor will open and you can then see all the tables that make up that report, and column names within those tables. All you would need to do is write your SQL statement to bring in the columns you want. You may also want to use the same joins in Power BI as well if you're trying to recreate the same report.
Your Solution worked for me . Thanks a lot!!!!!!!!!!!