Recent content by jbecker614

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...