New SSRS Web based report using Tessitura Report Procedure

> I am wondering if it is possible to use more than one procedure to make SSRS Custom report.

Definitely.

> I would like to design a Custom Order Billing Receipt using Tessitura Report Procedures  TP_INVOICE_BILLS,TP_ORDER_ACK [etc etc]

We have several custom order acknowledgments that appear under the order Print button and make use of TP_ORDER_ACK. In my custom sproc I create a temp table to store the output, then invoke the standard sproc and insert its output like so:

insert #order_ack

EXEC dbo.TP_ORDER_ACK @order_start_dt, 

    @order_end_dt, 

    @season_str, 

    @perf_start_dt,

    @perf_end_dt, 

    @mos_str, 

[etc etc]

...and from there do whatever I want. The same could be done with multiple standard sprocs and tmep tables.

Make sense?