Search results for query: *

Are you familar with Autohotkey? If so you can create a script that will activate the record selection to a keyboard shortcut combination that you choose. For example: ^d:: IfWinNotActive, Crystal Reports - return Send !r Send +s Send +r With autohotkey and the above script, you can open the...

You could always try a clipboard manager like OrangeNote: http://orangenote.littlesoftware.ca/ That program can store any number of text strings for later retrieval, it is even searchable or use Autohotkey to create a macro to paste your formulas via a hotkey that you would want. It is...

For your CR viewer question, take a look at the Datalink Viewer by Millet Software. www.milletsoftware.com

PSQL 9. I think that I found the function: TIMESTAMPADD ( SQL_TSI_DAY, "table name"."field.name", CONVERT('0001-01-01', SQL_TIMESTAMP) ) -1

I work with an application that uses a date format of the number of days passed since 01/01/0001. Would any one know of the correct function to use to convert into a date through PSQL. I can do the conversion usind DateSerial after linked to MS SQL or MS Excel, but I was curious to see what...

I work with an application that uses the same date format. Would any one know of the correct function to use to convert into a date through PSQL. I can do the conversion usind DateSerial after linked to MS SQL or MS Excel, but I was curious to see what the equivalent would be when creating a...

Crystal Reports stopped the compiled report feature. The easiest option would be to use a Crystal Report Viewer. Ido Millet makes an excellent viewer and report distribution software. www.milletsoftware.com

I have Crystal 11.0.0.2422 and 11.5.8.826 (Release 2) on one workstation (MS Vista) and I get the same issue using a Pervasive issue datasource. I also had a report using Access that while I can select the dynamic parameter, Crystal Reports crashes while refreshing. On another workstation(MS...

I would take a look at what classes Ken Hamady offers. http://www.kenhamady.com/

I run into the same issue. It appears that Crystal remembers where you have opened a box from the previous time. For Example, if you go to create a formula and open the formula editor on your 2nd Monitor, Crystal will open it there the next time as well. It does this even if you don't have...

If the service pack does not work, try installing the OLE DB for FoxPro and connecting through that way instead of ODBC. http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en

You could take a look at .rpt Inspector from Software Forces. http://www.softwareforces.com/Product/ri/pro/3/rptinspector.htm

lbass Worked fine. thanks!

Crystal XI Report is off of MS Excel Data Currently have a report that lists employee records of hires. The report lists employees that could have worked for several different companies. I need to suppress records where all of the records indicate that the employee is terminated. The key...

I think that you have a few options for this. 1. You can use Visual Cut as synapsevampire stated. It is a really good product, some of my clients are using it. It will schedule reports to be run and exported to PDF. http://www.milletsoftware.com 2. With Crystal Reports XI you have a...

Lbass: Perfect! I don't know why I didn't think of that. Must be tired. Thanks to you and synapsevampire

synapsevampire: Ok, I found the issue. The counter does not reset. The formula in the group footer was dividing 320 total hours by 41 (which was the total # of pay dates in history). I need to figure out a way to divide the 320 total by the number 4 or for the total number of pay dates if...

Sorry: I noticed that you did include the average calculation. It doesn't seem correct yet. I am looking into it. The first employee had 80 hours each period. It correctly totaled to 320 hours but the average calculation in the footer only displays 7.80.

synapsevampire: Thanks! The counting works correctly. I need to create the average now. I am going to try a few tweaks to the formulas to get it to divide by the total number that is in the counter, unless you have any other suggestions. Regards, Jamey Becker

Using Crystal Reports 11 Pervasive Database I need to create a fomula for a client and I could use a little assistance. This is based on a table that has a record of employee hours worked based on pay dates. I need to calculate the average hours worked based on the previous 4 pay dates from a...