Is this a poor database design?

Setup
I am using a simple aspx page to calculate a person's tax filing status and capturing statistical information. Most of the items are drop down boxes or radio buttons but a few are checkboxes.

Question
My plan is to give each option in the check boxes its own column in the database this will lead to a table that is 70 columns wide. Is that to many? Most of the info will be very small like "yes" or "no". I will be using a stored procedure to insert the info. This will be coming down a VPN

Goal
I would like to give the admin staff here real time access to the data via link tables and such. I would like there to be only one table so it will be easy for them to pars the info quickly without needing to join tables or write unions. Ideally this would get me out of the business of creating one off reports.I would recomend a more normalized table design.

If your admin users want to view the data de-normailzed you can create a view which accomplishes this.|||Go to the SQL Server Web site and look for the SQL Server 2000 AdventureWorks, it will get you create table statements that is close to what you are looking for because I takes table Reationship to Upper and Lower bound Cardinality. The only human interpretation of Peter Chen ERD relational Algebra. Hope this helps.

Kind regards,
Gift Peddie

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, ShyamThere are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!

Is there any way to control the visibility of items in Reporting Services Toolbar ?

I want the Reporting Services toolbar to be shown in my report. But i would like only "Zoom" dropdown and not others like "Find", "refresh", "Print" etc. Is there any way for me to control this from the URL. (as work around can i specifying this in RDL )

thanks, Shyam
There are two ways of achieving this result:
1. if you use the VS 2005 report controls in server mode, you can turn on and off individual buttons in the toolbar. You can also override their default behavior.

2. if you use RS 2000 or RS 2005 out of the box, you can specify a custom stylesheet. You can customize each button individually by changing the stylesheet. There is some documentation in the readme about using custom stylesheets. Basically, you want to change the style display:inline to display:none for the items you don't want visible.

After you create the stylesheet, you can use it in one of two ways:

a. Use the rc:stylesheet property on your URL.

b. Modify the config file to treat your new stylesheet as the default for all reports.

Note that stylesheet support is not available in current SQL 2005 builds (it will be before RTM). Stylesheet support is in RS2000 (all releases) and I think the ability to change the default stylesheet was added in SP2.

Thanks

Tudor

|||Is stylesheet support available in the Sept CTP? I have been unsuccessful at implementing custom stylesheets using the documentation in the readme.|||

Hello,
I'm facing with some related problem.
If i make something invisible (say a subreport) still, the report server fires the SP for that subreport. Is there anything in config file related to set this ? let me know !

Regards,
abhay

|||

Could you possibly go into more detail how to go about turning on and off individual buttons through VS 2005 report controls in server mode?

Thanks!!