Question Status

Suggested Answer
N-khawaja asked a question on 16 Sep 2014 11:43 PM

How could i install HITB Report on SSRS?

Reply
Suggested Answer
Harry Lee responded on 17 Sep 2014 12:47 AM

Try creating an SSRS report using the following SQL query:

Declare @ReportStartDate varchar(10)

Declare @ReportStopDate varchar(10)

Set @ReportStartDate = 'YYYY-MM-DD'

Set @ReportStopDate = 'YYYY-MM-DD'

select

rtrim(hi.ITEMNMBR) Item_Number,

rtrim(im.ITEMDESC) Item_Description,

sum (hi.TRXQTYInBase) Quantity,  --Transaction Quantity for this transaction in Base Units of Measure

sum (hi.EXTDCOST) Extended_Value  --The Extended Cost from the HITB table

from dbo.SEE30303 hi (NOLOCK) --HITB Table (holds all transaction date for Historical Aged Trial Balance Reporting)

LEFT JOIN IV00101 im (NOLOCK) ON hi.itemnmbr = im.itemnmbr --Joining this table provides Link to Item Description

where hi.GLPOSTDT between @ReportStartDate and @ReportStopDate --Start Date should be hard coded (system start date)

group by hi.ITEMNMBR, im.ITEMDESC

order by hi.ITEMNMBR

Reply
Suggested Answer
Natarajan SankaraNarayanan responded on 17 Sep 2014 2:06 AM

Khawaja,

Have you deployed Standard SSRS reports from GP through Reporting Tools Setup?

If you have deployed the reports then you can find the below reports in Inventory folder

1) HITB Detail

2) HITB Summary by Item

3) HITB Summery by Account

Reply
Suggested Answer
Natarajan SankaraNarayanan responded on 17 Sep 2014 2:19 AM

Khawaja,

If you created Custom SSRS HITB report then, you need to upload the report rdl file to the Reporting Manager's Inventory folder(location where all the reports deployed).

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 17 Sep 2014 2:51 AM

Please have a look on the below links to deploy the SSRS reports and runt the HITB reports if you not deployed the SSRS reprots.

www.azurecurve.co.uk/.../how-to-deploy-ssrs-reports-in-microsoft-dynamics-gp-2010-r2

channel9.msdn.com/.../01

Hope this helps!!!

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply
N-khawaja responded on 17 Sep 2014 4:16 AM

Thanks for your kind response on post

Reply
Suggested Answer
Harry Lee responded on 17 Sep 2014 12:47 AM

Try creating an SSRS report using the following SQL query:

Declare @ReportStartDate varchar(10)

Declare @ReportStopDate varchar(10)

Set @ReportStartDate = 'YYYY-MM-DD'

Set @ReportStopDate = 'YYYY-MM-DD'

select

rtrim(hi.ITEMNMBR) Item_Number,

rtrim(im.ITEMDESC) Item_Description,

sum (hi.TRXQTYInBase) Quantity,  --Transaction Quantity for this transaction in Base Units of Measure

sum (hi.EXTDCOST) Extended_Value  --The Extended Cost from the HITB table

from dbo.SEE30303 hi (NOLOCK) --HITB Table (holds all transaction date for Historical Aged Trial Balance Reporting)

LEFT JOIN IV00101 im (NOLOCK) ON hi.itemnmbr = im.itemnmbr --Joining this table provides Link to Item Description

where hi.GLPOSTDT between @ReportStartDate and @ReportStopDate --Start Date should be hard coded (system start date)

group by hi.ITEMNMBR, im.ITEMDESC

order by hi.ITEMNMBR

Reply
Suggested Answer
Natarajan SankaraNarayanan responded on 17 Sep 2014 2:06 AM

Khawaja,

Have you deployed Standard SSRS reports from GP through Reporting Tools Setup?

If you have deployed the reports then you can find the below reports in Inventory folder

1) HITB Detail

2) HITB Summary by Item

3) HITB Summery by Account

Reply
Suggested Answer
Natarajan SankaraNarayanan responded on 17 Sep 2014 2:19 AM

Khawaja,

If you created Custom SSRS HITB report then, you need to upload the report rdl file to the Reporting Manager's Inventory folder(location where all the reports deployed).

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 17 Sep 2014 2:51 AM

Please have a look on the below links to deploy the SSRS reports and runt the HITB reports if you not deployed the SSRS reprots.

www.azurecurve.co.uk/.../how-to-deploy-ssrs-reports-in-microsoft-dynamics-gp-2010-r2

channel9.msdn.com/.../01

Hope this helps!!!

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply