Wow, that seems complicated bordering on absurd. In sql can't we do a case statement, count of sentleads where datepart(month, current date-1year) is less than the datepart(month, current date), of...

DDL

USE [Sandbox]

GO

CREATE TABLE [dbo].[Example1](

[Division] [varchar](20) NULL,

[activity_date] [date] NULL,

[SentLeads] [int] NULL,

[Referrals] [int] NULL

) ON [PRIMARY]

GO

INSERT INTO [dbo].[Example1] ([Division], [activity_date], [SentLeads], [Referrals])

VALUES (N'Central', CAST(0x2E350B00 AS Date), 13, 1),

(N'Central',...

I think what you really want is drill down functionality, which you can search on youtube and see tutorials for. It will display your subreport in context of the...

I just found answer here

http://social.msdn.microsoft.com/Forums/en-US/0c5a284a-8f4d-41a4-94cb-605dd2923e89/tablix-control-alignment

"If I understand you correctly, you want to keep report control’s width same to original size even if you insert some columns. Basically, the control will...

Yes, it worked for me, Gazereth. I deaggregated in the source dataset (by backing out one CTE in which I had been doing the calculations and putting everything into one...

if by P you mean Percentage, as in right click the cell in design mode, select Text Properties, Number,and select Percentage, it's already done. (one of the first things...

i did not think of that. but I tried

=Format((Fields!CUL1.Value) * 100,"F2")

and it didn't work.

ok, i've pulled in the second dataset with a WHERE IN clause to get the SSRS parameters value. No issues there.

Now trying to pull inthe specific value returned in...

It's dawned on me what you mean by using where clause to regulate results..and somehow doing this in ssrs made me forget basics of query. Thanks for hand up,...

in real life I have filters by division as well. I need the distinct unique leads total (at the bottom) of the report to remain at division level, while...

Gazereth,

I read your edit. Thanks.

Right now, it seems, if I use the union, I will be able to append the Total unique leads at the bottom of the report. ...

very grateful to read this. will try it

It's too tricky for a UNION because the total I need at the bottom can only be achieved with a higher level grouping

DDL

create table LeadTracker

(property_name varchar(30), lead_id int);

insert into LeadTracker...

I needed this:

=IIF((Fields!To_Your_Store.Value + Fields!Lost_to_Competitors.Value)>0 AND Fields!Leads_Sent_to_Your_Store.Value > 0,(Fields!To_Your_Store.Value + Fields!Lost_to_Competitors.Value)/Fields!Leads_Sent_to_Your_Store.Value,0)

it basically says, if the numerator is greator than zero AND the demoninator is greator than zero, then return...

Can you show me how to change the expression that I use for a column called Total Conversions? A zero can potentially appear in either of the supplied numerator...