sql server reporting services: reporting and invoices -- sql server reporting services

Re: reporting and invoices

WebBuilder451
5/26/2006 9:59:02 AM

Thanks for responding,
I haven't even gone as far create my first report yet, but your answer gives
me incentive to look deeper.
I have a followup question. Can a report be called from a stored proc? This
is (i hate to admit) an entire accounting system writtern in web technology.
And it, the report, will need to be called from a web browser and printed
from a web browser unless i create a custom procedure to allow for printer
selection from the same. (a, yes that right, a BROWSER) Hey it wern't my
bright idea, but is this possible?
THANKS!!
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[quoted text, click to view]

Re: reporting and invoices

Tim Dot NoSpam
5/26/2006 10:49:09 AM

I was just thinking about this this morning. Historically, I've used
Crystal Reports to generate invoices. I still believe that Crystal's layout
capabilities surpass RS, BUT...

The sky's the limit really. If you have an inkling of creative design
capability, you can use a plain old table and spice it up with some
background images to create the eye candy. At the end of the day, the
important part of the invoice is still a couple of tables. As an example,
create a table in RS and make sure you have a skinny column on the left and
right side of the table. In the corners, add background images that have
rounded corners on them. Voila! You now have rounded corners on your table.

My hay penny.

-Tim

[quoted text, click to view]

Re: reporting and invoices

Tim Dot NoSpam
5/27/2006 9:33:00 PM

I think it would be the other way around. Wouldn't you want your web
application to call the report which in turn called the stored procedure to
provide it the data for the invoice? I know, I 'm being a Mister
Smartypants. Sorry.

Reporting Services comes with a great report viewer control that you can
drop onto a web page, specify a report (local or via a reporting services
service), and view. You could also call RS from a code behind to produce
PDFs if you want (or Excel, HTML, MHTML, XML...).

Someone has recently created a "render to printer" rendering extension as
well if you need to automate invoice creation.

-Tim

[quoted text, click to view]

Re: reporting and invoices

WebBuilder451
5/28/2006 8:04:01 AM

thanks,
I appreciate your answer. I'm using pdf generation via ColdFusion now. I
works ok but i'm converting HTML to pdf so its difficult to modify an invoice
report once i get it right. If the viewer is how it's done then that how i'd
do it.

thanks
kes
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.