Open Forum

Actually you do not need it if you specify those all those ten ending variables as null. Example:  @I_cEndCustomerNumber = ' ', If you look at the sproc, there is an "if then" statement that says for each range ending variable if the input value is ...

Thank you Thaddeus,  Both of your suggestion are a huge help.  I can now run the HATB. What is the parameter value 'þþþþþþþþþþþþþþþ'? ------------------------------ Rick Roen Seeds by Design Willows CA ------------------------------

One other thing to help you out here Rick, Th input parameters for the HATB report are stored by index (RTGRSBIN) in the RM00700. So if your user sets their report options in the window and saves it into the RM00700 then you can get the inputs there ...

Richard, You must provide all the inputs: Here is an example that will return a record set. In my case 544 rows based on parameters input USE [TWO] GO DECLARE @return_value int EXEC @return_value = [dbo].[seermHATBSRSWrapper] @I_dAgingDate = N'2020-12-31 ...

I'm wondering if anyone knows how I could summarize my rows on my ME P&L report by the first segment.  Below is an example of what we're seeing, and the preference would to have all accounts starting with 7920 to present on the same row.  Does anyone ...

There are about 35 input params for this sp, but they all have default values.  When I fill out a few, like below, I still get no results. Any idea of what I need to enter for the other params? ------------------------------ Rick Roen Seeds by Design ...

Check to make sure you are filling out the parameters correctly. Thanks, and with Kindest Regards, ...

I have run this stored procedure and it returns with a value of 0.  Note: I used just a few of the input params like date range.   It seems like the SP is writing the results to a temp table: "CREATE TABLE #RMHATBAP( [APFRDCNM] [char](21) NOT NULL, [APFRDCTY] ...