reporting

[xcao]

I have a web form that collects data and insert into sql server 2005.
Since our staff may need later change or enter data into database, so I creatred an Access database using oDBC connection to sql server.

Then the main purpose is to create reports upon the data.
at first I plan to use Access report, but find there is no things like bulletin lists, and tables. But in my report, I need them.
I wonder if it is availabe in Sql server reporting service.
Or maybe I should all do this in reporting services, but reporting service is read-only.
So our staff can not control the data like in Access forms, tables etc.
Or should I create use Access for forms, and reporting serivice for reporting?

What is the best solution for this?
Thanks

 

[HiTechCoach]

I have a web form that collects data and insert into sql server 2005.
Since our staff may need later change or enter data into database, so I creatred an Access database using oDBC connection to sql server.

Then the main purpose is to create reports upon the data.
at first I plan to use Access report, but find there is no things like bulletin lists, and tables. But in my report, I need them.
I wonder if it is availabe in Sql server reporting service.
Or maybe I should all do this in reporting services, but reporting service is read-only.
So our staff can not control the data like in Access forms, tables etc.
Or should I create use Access for forms, and reporting serivice for reporting?

What is the best solution for this?
Thanks

Access have a very powerful report design. I use it a lot to create reports form SQL database

I create what looks like tables and bulleted list (like in word) in my Access reports.

Do you have much experience with Access and creating reports?

 

[xcao]

I do have some experience using reporting in access.
But for tables do I have to draw the table using lines?