I NEED HELP

Question

I NEED HELP

jespinozac1978

SSC Journeyman

Points: 82
More actions
October 31, 2016 at 5:12 pm

#400965

good, I need help, I'm starting to use reporting services, and do not know some details, I have done basic reports.
I have a field in the database called current balance, and a golf date of purchase, I need to validate a textbox, this amount appears to me, after 1-60 days after the move to the new box and clean the above, after passing 60 days, passing the data to the text box 61-90 days.
I appreciate the help you can give me.
regards;

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63506 More actions · Answer 1

Where to start...

you need to get the age of each sale (or whatever it is) in days, so you can put them into [1-30], [31-60], [61-90] days old bins...

I'm calculating the time since a hire date:

CalcDaysAgo =DATEDIFF(DateInterval.Day, Fields!HireDate.Value, Today)

then I'm putting those into bins

BinsForDays =IIF(Fields!CalcDaysAgo.Value>1000,"Really Old",IIF(Fields!CalcDaysAgo.Value>=500,"Old","Kinda New"))

So you would need to create a calculated field to determine age. (use first formula as an example).

Then you would need to group those into bins. .. (second formula).

And then you could count/sum them in your report.

DamianC SSCrazy Eights Points: 8023 More actions · Answer 2

You could also calculate this in an aggregated table that way there's no calculations in the report

I've used this technique a number of times in the past and it works well for me

So, create a table with the buckets as attributes

Build the table daily (or however frequently you require)

Create the report using this table

- Damian

naomidavison10 SSC Journeyman Points: 83 More actions · Answer 3

Begin messaging him yet again. Ask him how matters had been going as of late and that you essentially men will need to event to make up for stuff. Essay Writing Service[/url] run eats with him or something and notice the way it is going. On the off chance that you may have an association you then will need to seek after the association.