Hello,
I would like to know how to gather the current accountid for an SSRS report. I'm currently replicating the functionality of an existing report at the Account level, currently the user can generate the report from a button in the Opportunity.
The dsOpportunity dataset query type for the Opportunity looks like this;
select
Oppty.OpportunityId as [OpptyId],
getdate() as [EffectiveDate],
Acct.Name as [AccountName],
Acct.aep_UtilityAccountNumber as [AccountNumber],
Acct.Address2_Line1 as [AddressLine1],
Acct.Address2_Line2 as [AddressLine2],
Acct.Address2_Line3 as [AddressLine3],
Acct.Address2_City as [City],
Acct.Address2_StateOrProvince as [State],
Acct.Address2_PostalCode as [ZipCode],
SystemUser.FullName as UserFullName,
SystemUser.JobTitle as UserJobTitle,
Contact.FullName as ContactFullName,
Contact.JobTitle as ContactJobTitle
from FilteredOpportunity as Oppty with (nolock)
inner join FilteredAccount as Acct with (nolock) on Oppty.ParentAccountId = Acct.AccountId
inner join FilteredSystemUser as SystemUser with (nolock) on Oppty.OwnerId = SystemUser.SystemUserId
left join FilteredContact as Contact with (nolock) on Acct.PrimaryContactId = Contact.ContactId
where Oppty.OpportunityId = @OpportunityId
The report contains the OpportunityID parameter with a default value, however when I run it from the Opportunity it returns the information of the record on focus.
I added a new AccountID parameter similar to the OpportunityId paramenter and added a new dsAccount dataset,
SELECT name AS Company
FROM FilteredAccount
WHERE accountid = @AccountId
For some reason, it always pickup the default value I assigned on the report instead of the current account on focus.
I would appreciate anybody that can shed some light on this topic, i.e. what I am missing out, why this work for the opportunity and not for the account.
Thanks!
