Search results for query: *

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?

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

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

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?

My database holds the DateTime value as GMT. I need to subtract 5 hours to get EST. I tried taking the date field and minus 5, but thats not working. Need to keep in mind that subtractiing 5 hours could return previous date, so there has got to be more than subtracting hours.

I am trying to set a default CharPerInch. No matter what hexadecimal or decimal value I enter, the charperinch export text window doesn't change, it remains at 12. Since going to XI (from 8.5) my text export are all messed up. I did find if I export to 25 char per inch, and view in notepad at...

Crystal XI. 1. We are using the print engine craxdrt.dll, back in 8.5 we used crpe32.dll which has since been retired. I was under the impression that the U2Fxls, U2fTxt, etc. dlls where used with the crpe32 and that the x3ftxen, etc. where used with the craxdrt.dll. Does any one know the...

Crystal XI In Crystal 8.5, I was able to manually modify my SQL WHERE clause, my typically modification was; WHERE blah blah blah //generated by Crystal Select Expert //then I manually type in the following via Show SQL Statement: AND AccountBalance.DateX = (SELECT Max(DateX) FROM...

Crystal XI - Can someone explain what the difference is between using the Select Expert (or Record Selection Formula) and using the Record Group Selection Formula? I've always just open the Select Expert and opened the Formula workshop and wrote a formula of what I want to return. Sometimes I...

I am looking for a reason to use the Running Total feature instead of inserting subtotals? Currently, all of my formulas are in the Detail section of the report and I insert subtotals into the Group(s) and Report Footer section for Grand Totals, thus I write 1 formula, whereas with a Running...

I just got Crystal XI (upgraded from 8.5) I went to training, but it was on Crystal Enterprise XI Release 2 and can't seem to find the following: 1. Does XI have the ability to Duplicate formulas, or is that an Release 2 only thing? If so, where? 2. When inserting a Subtotal, how do I...

As you are all aware about the Crystal bug using Page N of M (or any of the page functions) when exporting to PaginatedText (or Text or cvs and a few others), the output displays Page -1 of 1. I use a formula that displays the correct information, but backwards. So it would instead of showing...

Having Friday brain. I have a conditional variable that I am storing a balance in per detail line and want to show the total of all the balances for that day. I wrote (@Display is a true condition. Formula name: @holder1: Global NumberVar Balance; If {@DISPLAY} then Balance := Balance +...

I have to find out the hours/minutes/seconds difference between 2 datetimes. Any suggestions?? 12/17/2003 3:40:09AM and 12/17/2003 3:40:33AM 12/15/2003 8:15:10PM and 12/18/2003 4:01:18PM I have to show the difference as hours/minutes/seconds that have elapsed from the first datetime to the...

I am trying to display Account Data even if no items exist in an Item table. You'd think joining the Account (primary) table with a Left Out Join to the Item table would deliver the results, but its not. Not sure if its because I have Equal To Joints from the Item table to other tables, like...