Recent content by Montana751

Thanks for the info, worked perfectly.

Crystal XIr2 Oracle database I have many servers and databases from which reports are run and I would like to have the server name and database information from where the report was generated to display on the report. Anyone have an ideas how to do this?

I got the summary values to display in the page Headerit using 3 Cross-Tabs; one for each total I needed. Still interested in finding out how to use variables to do it though.

Crystal XI. I'm in my subreport that is grouped on a formula @GroupFormula(If Account.PoolSide = 3000 then 1, else if 3001, then 2, etc. 4 total) I need to display in the Page Header section (using the details & group footer sections, just to get the Summed Values for groups 1 & 2) the summed...

Crystal XI - SQL I need to replicate an official form, which has a diagonal line in the detail section; where some data shows to the Top Right before the line and other data displays Bottom Right under the line. The data is easy, I can't figure out how to draw the diagonal, just straight. I...

Crystal XI 1st datasource are SQL tables on Server A 2nd datasource is QuickBooks on Server B Is there a way to join these (log in, etc.) WITHOUT USING ~ a subreport ~ creating a Crystal SQL query ~ creating a SQL Union I have 3 fields that are the same in each datasource that need to be the...

Crystal XI - SQL & Oracle databases Does anyone know if there are any ramifications if I select "Convert Database NULL Values to Default". Most of the tables used in the reports allow NULLs. We've been using the producdt for 11 years and never used this feature, but I can't remember why not...

Here is the cause of my confusion: In crystal xi, I have a record sort order defined as: Group #1: Account.Name - A A - Class.Name A - Department.Fax the SQL statement Order By reads: ORDER BY AccountPool.Name, Class.Name, Department.Fax I always "assumed" that the reason we had to use the...

What is the Order of process, the Order By clause, then the Record Sort Order? Are both sort conditions being applied, just 1st at the server for the Order By, then all the records that return are sorted locally using the Record Sort Order?

Crystal XI When running Crystal - we (3rd party software application)pass infomration into the SQL query. Back in Crystal 8.5, this information would "Append" to the Where (if conditional) and Order by clauses of the Crystal SQL statement. I've noticed in Crystal XI, this is not the case, the...

Crystal XI Whenever you use a left outer join (or whatever) from the primary to a secondary table, DO YOU have to use the SAME JOIN TYPE(LO)if joining a third table to the second table? I thought I read/heard someplace this was mandatory. Can someone comfirm. thank you.

when exporting to Excel (from Crystal XI), I am prompted with the window "Excel Format Options" which allows me to identify how I want to export my file. My question is that I need default this option and set it not to display anymoore (like PromptAgain registry setting for the Text option)...

In release XI, the registry settings needed are as follows: HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Export\Text Dword - CharPerInch and HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Export\TextExport Dword - CharPerInch Dword -...

Suppress Printing If No Records - Select this option to suppress the printing of a report if that report does not contain any records. What does this mean exactly? I thought the report would not print if no records exist, but my report still prints out. Any ideas?

Figured it out, you have to use the DateAdd function DateAdd ("h",-5,{SCHEDULEDJOB.LASTEND} ) However, if you want to get all timezones, then the -5 should be replaced with a formula that identifies your current timezone and adds/subtracts from the GMT appropriately.