Search results for query: *

hi, i have an outer join in my report. for example: WHERE TABLE1."COL1" = TABLE2."COL1"(+) AND TABLE1."COL2" = TABLE2."COL2"(+) and, i'm using the select expert to add these to my where clause: {TABLE2.COL3} = abc however, when doing an...

Hi, I have 3 tables: Trans_tbl xid data1 data2 1 abc def 1 ghi klm 2 nop qrs Amount_tbl xid amt1 amt2 1 10 20 2 30 40 Summary_tbl xid tier mins fee 1 1 14 1 1 2 15 7 1 3 12 9 2 1 9 4 2 2 7 3 Prior to adding Summary_tbl to my report, I...

Hi, By parent/child, I mean something hierachical like account and sub-account. I have data like the following. When parent and child are the same and you don't see any other rows, it means this parent basically does not have children. Parent and child are key/id columns. Amount is just a...

i'm using powerdesinger 7.5. i'm generating ddl for mysql 3.22. under the "generate database" option, in the "keys & indexes" tab, i have "create foreign key" option checked. it doesn't seem to generate any foreign key ddl for me. when i change the database to...

hi, i was wondering if it's possible for crytal reports (8.0.1) to save/create a report (executable?) so that a non-developer (my admin) can run a report that i've created in crw. i don't want to install the crw developer's client on my admin's computer. i just want her to be able to run...

Hi, I found this: http://support.crystaldecisions.com/library/kbase/articles/c2007671.asp Seems like a really difficult way to change a string to Title Case, don't you think? Do you know if Crystal is going to have a TitleCase function in the near future? Thanks. mnguyen_va@yahoo.com

hi, the data in my database is stored in all uppercase. is there a way to display this field in my crystal reports in Title Case? is there a way to change UPPER to lower? UPPER to Title Case? UPPER to Sentence case? thanks. mnguyen_va@yahoo.com

Hi, I have two tables: ACCOUNT id amount CREDIT id credit_amount_aaa credit_amount_bbb The join is: SELECT account.id , account.amount , credit.credit_amount_aaa , credit.credit_amount_bbb FROM account , credit WHERE account.id = credit.id(+) I have id in section a...

Is there a size limitation for a saved report (when saving data with report)? Is there a page limitation for a saved report (when saving data with report)? Is there a record limiation for a saved report (when saving data with report)? Along these same lines, is there a setting somewhere that...

Can Crystal Reports 8.0 export to PDF format? Thanks :-) mnguyen_va@yahoo.com

Hi, I'd like to do alternative graying of my detailed data (for easier reading). Here is some sample data: id col1 col2 col3 -- ---- ---- ---- 1 abc def ghi 2 bcd efg hik 2 bcd efg ikl 3 cde fgh ikl 3 cde ghi klm 3 def ghi lmn 4 abc def ghi In this example, I want all the...

Hi, Here is some sample report data (example 1): id col1 col2 col3 col4 -- ---- ---- ---- ---- 1 abc def ghi jkl 1 abc def hij jkl 1 abc def ijk jkl 2 abc def ghi jkl 2 abc def klm jkl I would like it to look like this instead (example 2): id col1 col2 col3 col4 -- ---- ----...

Hi, I'm trying to print an address. i.e. Company_name Address_line1 Address_line2 Address_line3 City, State zip5-zip4 How do I suppress address_line3 if it is null? And, by suppress, I mean don't have a blank line where address_line3 should be, but instead, move city/state/zip line up. You...

Hi. I have a table that contains account_id and dollar amounts. I am basically trying to generate a bill per account. How can I get Crystal Reports 8.0 to create a new report (page break) per account? Right now, if I just put account in my report, I can group by account. As I mentioned, I...