Crystal User dropped into reporting services - function Date help 1

[Jcfx]

Hello,

I've used Crystal Reports for years for my report design and this morning my boss dropped SQL 2005 on my desk, told me to instal Visual Studio and Reporting Services and start porting everything over .

I am having a heck of a time figuring out functions. I am not familiar with the .net logic/syntax. And the help files only hold enough to tease.

I am taking a simple aged receivable report based on a manual crosstab and seeing if I can duplicate it in RS 2005.

I sort of understand the basic IIF logic.
=Iif(Fields!TotalDue.Value < 10000,"Red","Black")

trying to translate that logic into a function for the 'aging bucket' of 31-60.

DocDate is a simple date field, Current is the amount remaining to be paid on an invoice.

would it be something like:
=iif(fields!Docdate.value >Today()+31 or fields!Docdate.value <Today()+60,Fields!Current.value,0.0)

I know this sort of thing is second nature to most folks, but I have a hard time wrapping my head around new syntax.

Thanks for any assistance.


Julie
CR 9,10 CE10 Sql DB

 

[xlbo]

Dates & Times in .NET are (to my mind) excessively complicated. I would be tempted to try and do this in the SQL query itself instead

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[dgillz]

Why doen't you post this in the SQL Server Reporting Services forum?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[dgillz]

Duh.....ignore my last post please....haven't had my morning coffee yet

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[xlbo]

should've mentioned this before but in the SQL, look at the DATEADD & GETDATE functions to do what you need.

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Jcfx]

thanks for the reply xlbo.

<waves at dgillz - ya I know I pester the crystal forums occasionally>

Your answer xlbo is pretty much what I've been running into with Reporting services, do all the calculations at the sql level.

We have one 'master' procedure that we base a large number of reports off of, it looks like for Reporting services we are going to have to go back to one unique procedure for each individual report.



Julie
CR 9,10 CE10 Sql DB