• Replies 6 replies
  • Subscribers 340 subscribers
  • Views 85 views
  • Users 0 members are here
Related

SSRS Formats in T_FORMAT_INFO

Nathan Wigham
$organization

Hello all.

I'm starting to think about moving our Gift Certificate and Subscription Renewal formats from InfoMaker to SSRS.  I created one to test, but I'm getting stuck when I add it to T_FORMAT_INFO, specifically on the [D Object] column.  Can I enter a path to the folder on the Report Server where the SSRS object lives?  Do I need the file extension?  Can SSRS formats be added here, or is this just for InfoMaker format?

Thanks!

Nathan

Parents
  • $organization

    Hi Nathan!

    I have the same understanding as Beth - T_FORMAT_INFO only plays with Infomaker I think. But in the meantime we've still developed an SSRS report that can act as a receipt for individual orders - as well as be run "in bulk" similar to the Order Acknowledgement/Confirmation reports. Maybe you could do something similar? Just reference the same Tessitura stored procedure in the SSRS dataset - and use the results to make a new report.

    While you have to get out of an order and into Reports/Utilities to run these, they are at least customizable, and much much prettier (at least in our case!). I do long for the day when that SSRS format will be available from the Print Order/ Acknowledgment pulldown in ticketing... :)

    Beth

  • $organization in reply to Beth Gilliland

    Thank you, Beths!  I was afraid that was the answer, just had to ask.  One of these days we'll get that feature, I'm sure.

    Nathan

  • $organization in reply to Nathan Wigham

    Similarly to Beth, we ran a completely SSRS custom sub renewal invoice report this year, with no entry in T_FORMAT_INFO. It includes a little update to date_last_ren_notice_generd in t_cust_subscription_summary so there is if I recall correctly nothing missing from the background of a run of a standard renewal invoice report.

    I long to be able to run anything that includes parameters from the Print -> Ack button. :-)

  • $organization in reply to Chris Jensen

     

    I also long for the day we can run an SSRS report from the order Print button!

    I take it this feature is not there yet?

Reply Children
  • $organization in reply to Dara Hogan

    Unknown said:

     

    I also long for the day we can run an SSRS report from the order Print button!

    I take it this feature is not there yet?

    You are correct. From the v12.5.1 docs:

    "D Object – The file name of the InfoMaker form. The D Object should be the name of the object in the pbl file, with no file extension."

    :-(