Search results for query: *

I am using CR 8.5. My report connected to Oracle database using ODBC. My problem is that when I refresh report with new paramaters(I have 5 parameters) it's show me the same data, it looks like the SQl Query is not updating. The "Save Data with report" option is unchecked. This is...

Tibi, Do you have a sample application with Mapi controls that I can see? Actually, I am exporting a report to a text file,and sending it as an attachment, but I would like to see a sample program that sending an e-mail using Mapi controls. Thanks, Stella

1127, Thanks for your response. I am using a crystal report properties to send an e-mails. CrystalReport1.PrintFileType = crptText CrystalReport1.Destination =crptMapi CrystalReport1.EMailToList = strEmail (variable that hold all recipient names) CrystalReport1.PrintReport My question...

I have a VB application that sends an e-mail. My problem is when the recipient name in a database different from name in MS Outlook it will not send an e-mail to that person. What I want to accomplish is that I want to generate an error when this occurs and create a .log file that has a...

Is it possible to create one Installation Package(with only one Setup.exe) that will work for all Access 2000 applications? If the answer is "yes" then please give me an idea how can I do that. Thanks in advance 8-)

David, thanks for you response! I didn't understand why are you telling to remove table from report. I cannot do that. Is there a way to login to ODBC datasource and set that as default, so when I run my report it will not ask me every time to put a login parameters. Thanks, Stella

I am using ODBC to connect CR v5 and Oracle 7 database. Every time when I run a report it's pop up the "Logon Parameters" screen. Is there any way bypass it or set default parameters for Server, Database, User name and Password? Thanks, Stella

I am using ODBC to connect CR v5 and Oracle 7 database. Every time when I run a report it's pop up the "Logon Parameters" screen. Is there any way to set default parameters for Server, Database, User name and Password? Thanks, Stella

Thanks Ken it's working now. Stella

Ken, Could you tell me, after upgrade V5 to 8.5 am I going to have a problem with running totals formulas that I created manually in v5? Also, where I can download a distribution expert for v8.5? Do you know a file name for the calendar control that come in V8.5? Thanks, Stella

Thaks for your response. I distributed the report using Report Distribution Expert. It might be other applications on Client PCs that use CR, but I don't know which and they too. Also, I want to ask you, if I will upgrade my CR V5 to V 8.5 will it be a calendar control for Date Parameters? Is...

I am using CR V5. I distributed report to 3 users. Two of them getting calendar control to select the dates(parameters) they need and one just have a text box and have to type dates. I don't understand why the 3rd user not gettting the same calendar control? Please let me know how can I fix that...

Ken, It worked! Thanks a lot! You are GENIUS!!! Stella

I did put a condition to check for a first record in a second formula and I am getting the same incorect result. My Grouped fields are: Group #1 - Region Group#2 - Branch Group#3 - Sales Rep Group#4 - Customer All of the groups have running total formulas. So,I cannot make the Sum(grand total)...

Ken thanks for your response. I need to use running totals because I am suppressing duplicate records and I have to exclude them from totals. INSERT -> GRAND TOTAL for {C_ILSOBG.DIFF_QTY} will not work because it will add all values (from all groups) of that column. I need to get a SUM only...

I am using CR V5 and I have a problem getting Grand totals.The Grand Total field should be placed in Report Footer. I created Running Total Formulas for Customer, Brunch and Region. For a Grand totals I need to get the SUM of the Region only because Brunch total already includes total for...

Ken, Thanks for your responce! Ok, it's a little confusing because I didn't write all details. I am going to exlain everything from the beginning. I suppressed duplicates by writing a formula in details section under suppress: WhilePrintingRecords; If {C_ILSOBG.SO} = Previous ({C_ILSOBG.SO})...

Ken, I am using CR V5. I have 3 running totals formulas using variables listed above. Those formulas working right only for a 1 group in a report. I have 5 groups. What should I do to make them work for other 4 groups? thanks, Stella

Got it. Thanks a lot for your help. Stella

Thanks Ken, I got my totals, but I have 5 groups in a report. Do I need to have separate formulas for each group to get conditional totals? Thanks, Stella