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
Hey Nathan,
It's my understanding that we can only use InfoMaker for that at this time.
Hopefully I'm wrong though! I'd love it if someone corrected me. :)
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."
:-(