Search results for query: *

Hi Guys, this is probably an easy one, but I'm not sure how to quickly add in the information without having to create a table to hold the data. In the system I'm working with people are able to enter Holidays in a text field. Either 01/01/2011 for a specific date. or 01/01/XXXX if the date...

Dear all, I figured out how to do it. Actually there are two ways to go about it. 1) By using a stored procedure and passing the values through to a subreport (this wasn't an option for me as I had to use the calculation in a subreport as well) 2) By using a function and creating a SQL...

Hi Brian, yes it does import the stored procedure, but I want the parameters to be linked to a result set. ie. Task 1 Task 2 # workingdays Job 1 1-1-11 3-3-11 50 Job 2 7-1-11 3-3-11 45 Job 3 9-2-11 9-3-11 35 Job 4 4-3-11 1-5-11 50 So the task 1 and...

I have created a stored procedure which calculates the # working days between 2 dates taking into account a table with non working Holidays. In Crystal I want the result set of a report showing details to pass in two dates and get the result from the procedure to show the correct working days...

I need to create a crosstab that calculates the time between completion of tasks in a crosstab. see example below: task task 1 task2 task3 task4 date completed 26-May 15-Jun 25-Jun 20-Jul time between tasks 20 10 25 How do I calculate the time between...

Hello All, I have a question. Currently I have built an excel list which creates hundreds of URLS based on the products our company sells (Deeplinks to products on our website) however I am not sure if all these links are actually valid/exist. is there a way within this excel sheet I can check...

Hi Ben, thanks for your help. It seems we could use SQL 2008 for our proximity calculations. However we still need a way to draw vectors/polygons to mark beaches, or other areas of interest. what do you recommend I use for this? Thanks, Erik

I am working on a new project at work where I believe we need a GIS system. However I am getting a bit lost with all the different systems out there. As I am new to GIS I was hoping I could get some help here. The requirements we need are pretty basic, so I don't think we need a very expensive...

Thanks Both, this was really helpful it works now! kind regards, Erik Withoud

I figured it out. The version of progress being used does not allow this action. an upgrade to version 9 is scheduled in the near future.

Sorry for the confusion. 5 Y's equals 3 spaces, 6 Y's equals 2 spaces. so for instance 4M5T -14240-EDB becomes 4M5T///14240EDB and 3M5T -14A280-AB becomes 3M5T//14A280AB (/ are spaces) Does this make it clear? Thanks for your help.

Hello, I have a question for excel. I am using a pdf scrubbing software to get PDF data. However the data generated is not the same as is usable for our system. Therefore it needs to be adjusted. The data looks as follows cell 1 Cell 2 our system XXX -YYYYYY-ZZ(Z)...

I have a problem with getting a variable length field to display properly in Crystal Reports 10. I am working with CR10. Calling on a progress (mfg/pro) Database using ODBC (Datadirect 4.0). In the database I have some fields that have a variable length. When these are passed to Crystal it...

Should I maybe post this in the progress section as well or is that not allowed?

Normally if you would query the data in progress it will only show the 8 characters. However what I've seen done in progress is the recoding of the format of the normal Schema. So when a variable is set-up as X(8) you can recode it to X(40) and then query it, this way it shows much more...

I have a problem with getting a variable length field to display properly in Crystal Reports 10. I am working with CR10. Calling on a progress Database using ODBC (Datadirect 4.0). In the database I have some fields that have a variable length. When these are passed to Crystal it will show as...