Wednesday, March 28, 2012
how to assign ado.net dataset as sql report datasource
i dont find how to assign customize dataset to sql report datasource.
plz give me reply ASAPIf your talking about ASP.NET Datasets as the data source of your report you
will have to develope a Custom Data Extension bacause Reporting Services
doesn't support it.
You can find more information about it here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5ug2.asp
Maria Isabel Henao
"sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
news:C6935DE6-C28A-4064-9F33-D805F83C2CEF@.microsoft.com...
> hi,
> i dont find how to assign customize dataset to sql report datasource.
> plz give me reply ASAP|||Thx Maria,
but can i get the sample code or any running application code. i used
an article
http://msdn.microsoft.com/library/default.asp?url=/library/en-2k/html/RSDSetEx3.asp
but when i have implimented this it gives me hostname could not be parsed
error
what can i do'
"Maria Isabel Henao" wrote:
> If your talking about ASP.NET Datasets as the data source of your report you
> will have to develope a Custom Data Extension bacause Reporting Services
> doesn't support it.
> You can find more information about it here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5ug2.asp
> Maria Isabel Henao
>
> "sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
> news:C6935DE6-C28A-4064-9F33-D805F83C2CEF@.microsoft.com...
> > hi,
> >
> > i dont find how to assign customize dataset to sql report datasource.
> > plz give me reply ASAP
>
>|||Looking for the original link I used to build my own dataset extension I
found this one that might be useful for you:
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=B8468707-56EF-4864-AC51-D83FC3273FE5
"sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
news:342AD658-1664-406C-B18A-2FCBD6361BE2@.microsoft.com...
> Thx Maria,
> but can i get the sample code or any running application code. i used
> an article
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-2k/html/RSDSetEx3.asp
> but when i have implimented this it gives me hostname could not be parsed
> error
> what can i do'
>
>
> "Maria Isabel Henao" wrote:
> > If your talking about ASP.NET Datasets as the data source of your report
you
> > will have to develope a Custom Data Extension bacause Reporting Services
> > doesn't support it.
> >
> > You can find more information about it here:
> >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5ug2.asp
> >
> > Maria Isabel Henao
> >
> >
> > "sdfsdf" <sdfsdf@.discussions.microsoft.com> wrote in message
> > news:C6935DE6-C28A-4064-9F33-D805F83C2CEF@.microsoft.com...
> > > hi,
> > >
> > > i dont find how to assign customize dataset to sql report
datasource.
> > > plz give me reply ASAP
> >
> >
> >
Monday, March 19, 2012
how to add report "Templates" to list during wizard?
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.
Monday, March 12, 2012
How to add new values into a aspnet_membership?
First of all, I used createnewuserwizd in vwd05 and customize more inputbox than the default, like firstname, and lastname, now I would like to add those new values into a aspnet_membership table, I try to modified the aspnet_membership_createUser store procedure, but it doesn't work ...... Here is my aspnet_membership_createUser code:
------> Code Begin <------------
ALTER PROCEDURE
dbo.aspnet_Membership_CreateUser@.ApplicationName
nvarchar(256),@.UserName
nvarchar(256),@.Password
nvarchar(128),@.FirstName
nvarchar(128),@.PasswordSalt
nvarchar(128),@.PasswordQuestion
nvarchar(256),@.PasswordAnswer
nvarchar(128),@.IsApproved
bit,@.CurrentTimeUtc
datetime,@.CreateDate
datetime=NULL,@.UniqueEmail
int= 0,@.PasswordFormat
int= 0,@.UserId
uniqueidentifier OUTPUTAS
BEGIN
DECLARE@.ApplicationIduniqueidentifierSELECT@.ApplicationId =NULLDECLARE@.NewUserIduniqueidentifierSELECT@.NewUserId =NULLDECLARE@.IsLockedOutbitSET@.IsLockedOut = 0DECLARE@.LastLockoutDatedatetimeSET@.LastLockoutDate =CONVERT(datetime,'17540101', 112 )DECLARE@.FailedPasswordAttemptCountintSET@.FailedPasswordAttemptCount = 0DECLARE@.FailedPasswordAttemptWindowStartdatetimeSET@.FailedPasswordAttemptWindowStart =CONVERT(datetime,'17540101', 112 )DECLARE@.FailedPasswordAnswerAttemptCountintSET@.FailedPasswordAnswerAttemptCount = 0DECLARE@.FailedPasswordAnswerAttemptWindowStartdatetimeSET@.FailedPasswordAnswerAttemptWindowStart =CONVERT(datetime,'17540101', 112 )DECLARE@.NewUserCreatedbitDECLARE@.ReturnValueintSET@.ReturnValue = 0DECLARE@.ErrorCodeintSET@.ErrorCode = 0DECLARE@.TranStartedbitSET@.TranStarted = 0IF( @.@.TRANCOUNT = 0 )BEGINBEGIN TRANSACTIONSET@.TranStarted = 1ENDELSESET@.TranStarted = 0EXECdbo.aspnet_Applications_CreateApplication @.ApplicationName, @.ApplicationIdOUTPUTIF( @.@.ERROR <> 0 )BEGINSET@.ErrorCode = -1GOTOCleanupENDSET@.CreateDate = @.CurrentTimeUtcSELECT@.NewUserId = UserIdFROMdbo.aspnet_UsersWHERE LOWER(@.UserName) = LoweredUserNameAND@.ApplicationId = ApplicationIdIF( @.NewUserIdIS NULL)BEGINSET@.NewUserId = @.UserIdEXEC@.ReturnValue = dbo.aspnet_Users_CreateUser @.ApplicationId, @.UserName, 0, @.CreateDate, @.NewUserIdOUTPUTSET@.NewUserCreated = 1ENDELSEBEGINSET@.NewUserCreated = 0IF( @.NewUserId <> @.UserIdAND@.UserIdIS NOT NULL)BEGINSET@.ErrorCode = 6GOTOCleanupENDENDIF( @.@.ERROR <> 0 )BEGINSET@.ErrorCode = -1GOTOCleanupENDIF( @.ReturnValue = -1 )BEGINSET@.ErrorCode = 10GOTOCleanupENDIF(EXISTS(SELECTUserIdFROMdbo.aspnet_MembershipWHERE@.NewUserId = UserId ) )BEGINSET@.ErrorCode = 6GOTOCleanupENDSET@.UserId = @.NewUserIdIF(@.UniqueEmail = 1)BEGINIF(EXISTS(SELECT*FROMdbo.aspnet_Membership mWITH(UPDLOCK,HOLDLOCK)WHEREApplicationId = @.ApplicationIdANDLoweredEmail =LOWER(@.Email)))BEGINSET@.ErrorCode = 7GOTOCleanupENDENDIF(@.NewUserCreated = 0)BEGINUPDATEdbo.aspnet_UsersSETLastActivityDate = @.CreateDateWHERE@.UserId = UserIdIF( @.@.ERROR <> 0 )BEGINSET@.ErrorCode = -1GOTOCleanupENDENDINSERT INTOdbo.aspnet_Membership( ApplicationId,
UserId,
Password,
FirstName,
PasswordSalt,
Email,
LoweredEmail,
PasswordQuestion,
PasswordAnswer,
PasswordFormat,
IsApproved,
IsLockedOut,
CreateDate,
LastLoginDate,
LastPasswordChangedDate,
LastLockoutDate,
FailedPasswordAttemptCount,
FailedPasswordAttemptWindowStart,
FailedPasswordAnswerAttemptCount,
FailedPasswordAnswerAttemptWindowStart )
VALUES( @.ApplicationId,@.UserId,
@.Password,
@.FirstName,
@.PasswordSalt,
@.Email,
LOWER(@.Email),@.PasswordQuestion,
@.PasswordAnswer,
@.PasswordFormat,
@.IsApproved,
@.IsLockedOut,
@.CreateDate,
@.CreateDate,
@.CreateDate,
@.LastLockoutDate,
@.FailedPasswordAttemptCount,
@.FailedPasswordAttemptWindowStart,
@.FailedPasswordAnswerAttemptCount,
@.FailedPasswordAnswerAttemptWindowStart )
IF( @.@.ERROR <> 0 )BEGINSET@.ErrorCode = -1GOTOCleanupENDIF( @.TranStarted = 1 )BEGINSET@.TranStarted = 0COMMIT TRANSACTIONENDRETURN0Cleanup:
IF( @.TranStarted = 1 )BEGINSET@.TranStarted = 0ROLLBACK TRANSACTIONENDRETURN@.ErrorCodeEND
------------> Code End <----------------
Please Help me out I try everything and everything, but the right thing please help me out, I really appreciated ......
You alter the stored procedure to only add a firstname value? You haven't change the logic of the sp, right? Then what's the meaning of " it doesn't work "? No user can be added through the sp? Or any error message?|||Yeah, I tried that, too. I just posted in the FAQ about how I added a MobileId to the Comment column in the aspnet_membership. You can't do anything esle with it apparently, however you don't need to! You can add a new WizardStep and store the data on that step to a new table. i hope this helps! Check the FAQ under customized createuserwizard.|||I would have put those values in the users profile rather than membership. A user's last and first name really have nothing to do with membership. Then again, I like stuffing everything into profile.