Search results for query: *

Hi everyone, I am doing a report that will create letters. I wanted to add a blank page to the letter that will end with the odd page number since we be printing as double-sided. I need the blank page for the letters that end with the odd number like 1, 3, 5, 7 and so on. If I don't have the...

Hello all, I am doing a report with 3 groups, with Crystal Reports when you group a field it's automatically sort that field. So, I have this calculated field display in the group header 3 that I can't sort in ascending order. Here is the sample of my report: Commercial General(1) 10 John...

Hello everyone, I want to configure the replication by going to Enterprise Manager -> Replicate Date -> Configure Replication. SQL Server will display the wizard and as soon as I clicked Next the error message "SQL Server Enterprise Manager could not complete the wizzard because...

Hello, I have this note field in my report but it is taking too much space in the report since it has too many spaces in between. Sample notes 02.01.03 cs Adj. to cl#2002112506800028 was denied as ooa. Per Penny ipa resp. on 2002 claims. 02.01.03 cs Erd date...

I have this if-else statement if not isnull(ProcedureCode) then ( ProcedureCode; ProcedureDecription; ) else "" and it would print out only the ProcedureDescription. Could someone help me with this? (I don't want to concatenate them into one string because I want both in 2...

Hi everyone, I am trying to set the masking a parameter field but it only works with the "Discrete value" and not with the "Multiple values"....Could anyone help me on this? Thanks!!! cdnamm

Hi everyone, I want to use MS Access 2000 as a front-end to update and delete data from Microsoft SQL Serer 7.0 but I couldn't. Here is the error message from MS Access 2000: "Operation must use an updateable query" or "Cannot delete the specified table" Could anyone help...

Hello all, I got this problem that I couldn't figure out. My report is showing the extra page header on the last page causing one extra page displayed on the report with no records but the page header. Thanks! cdnamm

Hi all, I need to suppress the records if the Dates of Service in the detail line are not the same. Could anyone help me? Thanks!

Hello, I want to export a report in CR 8.5 to quickbooks. Is it possible? Thank you in advance! cdnamm

I want to concatenate the diagnosis code (if more than 1) in the detail tables into one string and put it on a group footer, but my string would only get the diagnosis code of the last detail record only.