Jeff,
Yep, I see what you mean.
Scott,
To clarify my answer, I would put the logic in the dataset, or on the SQL
Server side, rather than in the table. If the latter is not possible, then it
can be included in the dataset schema on the RS side.
This alleviates any problems with the table object in the report, and
exsposes the code early on for modification.
Thanks for clarifying the position Jeff.
Tony
[quoted text, click to view] "Jeff A. Stucker" wrote:
> I see we interpreted his question two different ways. Scott, is this a SQL
> database table or report table we're talking about?
>
> --
> Cheers,
>
> '(' Jeff A. Stucker
> \
>
> Business Intelligence
>
www.criadvantage.com > --------------------------------------
> "Logicalman" <tony9scott45us@com7cast.net34> wrote in message
> news:00539CF0-711B-430B-AB0D-310FB6B03976@microsoft.com...
> > If..Then statements are represented in TSQL as Case When statements.
> >
> > e.g. to calculate the difference in days between two columns, but only if
> > the second column has a date, then:
> >
> > CASE WHEN NOT(col2 IS NULL) THEN Datediff(d,col1,col2) ELSE NULL END AS
> > DaysTaken
> >
> > Hope this helps
> >
> > Tony
> >
> > "sbaker" wrote:
> >
> >> I am new to using Reporting services and was wondering if it is possible
> >> to
> >> use if...then statements within a table. Ultimatley, I would like to
> >> build a
> >> table that displays prior day sales, current month, current quarter, and
> >> current year sales. Any suggestions?
> >>
> >> Thanks,
> >>
> >> Scott
>
>
