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
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
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.
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. :-)
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?
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."
:-(