Showing posts with label building. Show all posts
Showing posts with label building. Show all posts

Monday, March 19, 2012

how to add report "Templates" to list during wizard?

Hi, I'd like to customize the new report wizard to save me time in building reports.

I know that with most of VS there are files I can copy and edit to do that for new projects, forms, classes etc...

where are they for new reports?Hi,

Well, it actually depends on what you are naming "templates" in the Wizard.

1- If you are referring to the Styles you see at the very end of the wizard, you can add new styles editing the following XML file:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\StyleTemplates.xml

AND the equivalent ones located in the "resource" subfolders like:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

Of course, make a copy of each file before editing them.

the only caveat is that I do not know where the "preview" image is stored, therefore your style is "blind". May be you can invest some time to find out or someone can jump in with that info.

2- On the other side, if you refer to the "Table/Matrix" and "Stepped" Wizard tab, I gues it is hardcoded.

3- If you refer to the "item types" you can add when adding a new item (not in the wizard, therefore). You can follow Russell Christopher's in http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Hope this helps,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana|||

Jordi Rambla wrote:

Hi,

Well, it actually depends on what you are naming "templates" in the Wizard.

1- If you are referring to the Styles you see at the very end of the wizard, you can add new styles editing the following XML file:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\StyleTemplates.xml

AND the equivalent ones located in the "resource" subfolders like:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

Of course, make a copy of each file before editing them.

the only caveat is that I do not know where the "preview" image is stored, therefore your style is "blind". May be you can invest some time to find out or someone can jump in with that info.

2- On the other side, if you refer to the "Table/Matrix" and "Stepped" Wizard tab, I gues it is hardcoded.

3- If you refer to the "item types" you can add when adding a new item (not in the wizard, therefore). You can follow Russell Christopher's in http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Hope this helps,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana

Yeah, I dug out my copy of the hitchhikers guide to sql rs 2000 and it has this info from the 2000 version and looks like it's almost the same in 2005.

by the way what I have is about 10-15 reports created by another dev where he created each one with a common look, font, page head, foot, title etc...
and the boss likes the look. that guy is now gone -- took a different job.
so I want to capture as much of his settings as I can so that when I create a new report I do not have to spend to much time just chnaging colors and fonts to match what he did.

Friday, March 9, 2012

How to Add ASPNET account to your database

This is the error message "Login failed for user 'SUSHMA\ASPNET'. "

I am Building a Data Form that displays data from a single table- the Customers table in the Northwind sample Database.

I have Visual Studio.Net 1.0 and SQL Server 2000.

So I feel that I need to add an ASPNET account to my database.

Please could someone tell me if this could solve the problem, if so

please could you tell me how to Add an ASPNET account to my database?

Thank you

This thread has instructions on how to grant database access to a user account.
http://forums.asp.net/875897/ShowPost.aspx
|||

Hi,

Use Enterprise Manager (in SQL Server) to look at the users and groups for the database in question. If you don't see ASPNET there, you can add it, if it is there, it may be that it doesn't have sufficient permissions to do what you are asking it to do. The other thing to check applies if you are using IIS 6 (Win2k3 Server). In this case, ASP.NET uses NETWORK SERVICE, rather than ASPNET as the default worker process.

Hope it helps.

Wednesday, March 7, 2012

How to add a line chart while building report

This is my first time with Reporting Services. I was using the wizard and it
only had the options of Matrix or tabular.
I want to add a line chart instead. How can I do so ?
ThanksInstead of using the report wizard, create a blank report. Then add a chart
from the toolbox.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Hassan" <hassan@.test.com> wrote in message
news:OAbD2FjYIHA.6140@.TK2MSFTNGP02.phx.gbl...
> This is my first time with Reporting Services. I was using the wizard and
> it only had the options of Matrix or tabular.
> I want to add a line chart instead. How can I do so ?
> Thanks