Go Down

### Topic: Help with writing Crystal Report function(s) (Read 603 times)previous topic - next topic

#### mbxs3

##### Nov 16, 2015, 02:54 am
I am trying to write a custom crystal report that I will use to quickly report on pricing for my business. I sell advertising space where the price varies depending on the day of the week and the time slot that the ad will run. I have created a SQL database and populated it with my pricing data. The way I would like my report to work is as follows:

Report Input Parameters:

1)Ad slot time (can be 1 time slot or as many as 40 time slots. Ex: 8:30, 9:45)
2)Date ad will start (Ex. 12/01/2015)
3)Date ad will end (Ex. 12/31/2015)

Report Output:

8:30 Ad Slot Price for 12/01/2015 through 12/31/2015 = \$X.XX
9:45 Ad Slot Price for 12/01/2015 through 12/31/2015 = \$X.XX
Total Price for all Selected Ad Slots for 12/01/2015 through 12/31/2015 = \$XX.XX

QUESTION/ISSUE DESCRIPTION BELOW:

I am currently stuck on writing a function that will take all of my ad slot times from my first input parameter so that I can use them in calculating the price of each ad slot for the selected date range. I believe I need a dynamic array to hold all of the selected times but am having trouble finding examples on what this might look like.

#### Robin2

#1
##### Nov 16, 2015, 09:49 am
What has this got to do with an Arduino?

...R
Two or three hours spent thinking and reading documentation solves most programming problems.

#### weedpharma

#2
##### Nov 16, 2015, 01:13 pm
I was going to say the same but read the description of this section, "anything and everything".

Weedpharma

#### Robin2

#3
##### Nov 16, 2015, 05:04 pm
I was going to say the same but read the description of this section, "anything and everything".
Let's apply a bit of common sense and assume it means "anything and everything" about Arduinos and the Arduino system.

Or perhaps we can include discussion about shoeing horses or harvesting wheat

...R
Two or three hours spent thinking and reading documentation solves most programming problems.

#### weedpharma

#4
##### Nov 17, 2015, 02:02 am
Or perhaps we can include discussion about shoeing horses or harvesting wheat

...R
Now that you mention it, I have a problem where my tractor tyre has a slow leak. What is the best way to fix it?

Weedpharma

#### MorganS

#5
##### Dec 03, 2015, 06:12 am
A pitchfork. Turn that slow leak into a fast one, so you have to get it fixed.
"The problem is in the code you didn't post."

Go Up