I have been doing odbc queries through Excel for several years but I have never worked with sql and the sp_reports. How can I find out the correct info to enter in my sql such as:
sp_report BalanceSheetBudgetVsActual show Amount_Title, Budget_Title, Difference_Title, Percent_Title, Text, Label, Amount, Budget, Difference, Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts', SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'
How do you know what to enter after the name of the sp_report?
Thank you for your help,
Angela
|