how to design the Report server.

Raja P
Raja P used Ask the Experts™
on
I would like setup Web setup by using SQL2008 Report server for Inventory purpose?

Any idea how to step the front view by using SQL2008 design tool for Inventory?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Christopher KileSenior Software Analyst

Commented:
What do you want?  a report on inventory from an existing table, or an inventory management system?

Author

Commented:
yes..I want Report on Inventory from Existing Table
Christopher KileSenior Software Analyst

Commented:
OK, and you want to use SQL Server Reporting Services specifically to create this report?  Or do you just want to display data from the table within a Web application?
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I want to display the data from the table within a Web application
Christopher KileSenior Software Analyst

Commented:
How would you like to display the data from the table?  In a grid showing as many records as you have space to display, a detail view with only one record at a time visible, a simple dump of the data, or something else entirely?

Author

Commented:
I have 15 Colum which need to display Many records in same page.
Senior Software Analyst
Commented:
Not a problem.  I've done some research, and it seems you can display a SQL Server Reporting Services (SSRS) report on the web using the built-in web server in SQL Server (SS) itself, if you're running SS 2005 or more.

First, is Reporting Services set up on your database server? Is Report Manager set up properly?  Consult your DBA and please let us know.  You will also need to know the URL of your Report Manager; this is where reports are built and displayed.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial