Search results for query: *

Each formula or database field has an object name assigned. (right click field>format field>common Tab>Object Name) Does anyone know if the text in that box is accessible in a formula? _____________________________________ Crystal Reports 2011 and XI Intersystems Cache 2012 ODBC connection

Was hoping to start a discussion regarding calculated members and embedded summaries... Initially I found them very confusing and have still only scratched the surface of how I see them to be very useful in constructing bigger and better crosstab reports. So far I have found them very useful...

Crystal 2012, Intersystems Cache DB linked two tables together on a left join Col_Inv_Stats_MTD.Collector_ID and User_Master.USERID I need all records in left table that do not have a match on the above link so my record selection says isnull({User_Master.USER_ID}) so for two reasons i needed...

This is very odd and I am hoping someone can give me some tips as to why this happens. Using Crystal 2011 and pulling data from an Intersystems Cache database. I have dealt with null values as opposed to empty spaces many times but this one has me baffled. Creating a report using the following...

What are factors which would make parameters editable in Crystal Viewer? I have to parameters in my report. one is a date parameter and the other is a number. Both have the setting "Show on (Viewer) Panel: Editable I have several reports which work correctly using Viewer but there is something...

In report options i have changed the option for grouping to be performed on the database server. When I run the report and look at report statistics it tells me the grouping and sorting was not done on the server. Is that something that needs to be setup on the server? Im going to look through...

Is anyone aware of a limitation for Crystal to read large excel files? I am suspicious that Crystal Reports (both versions XI and 2008) are not reading past around line 16,400 in a couple of large excel files I have. _____________________________________ Crystal Reports XI Developer Version...

Not sure if this is an ok forum to post this question. I need to use the Cast or Convert command so that I can link to another table. The following is the sql WITHOUT Cast or Convert and it works fine: SELECT `Sheet1_`.`clt accct`, `Sheet1_`.`Debtor`, `Sheet1_`.`client code`...

I have a report which I have used for years that exports data in CSV format to be used for importing into a third party software. Has always worked great with CR XI until I upgraded to CR 2011 where the process only exports a portion of the accounts. Approximately 80%.. That I can tell there is...

Not to ask for someones help by name ;) but LBass!!! I am having difficulty with a reset formula you have posted in the past. I have a report with 2 group levels. in group 1 footer .. I need to count how many times A is greater than B in Group Footer 1 A is a summary field and B is a static...

My table stores statistics and has two fields to use for dates. year (numeric field) and month (text field) I have no idea why they decided to store like this but thats what I have to work with. I have a report where a user enters a Through Date parameter and I need to return the previous 12...

Just learning VBA ..... I need a snippet of code that will remove blank lines from a word doc. Im working it but am on a time crunch if anyone has anything that might help. _____________________________________ Crystal Reports XI Developer Version Intersystems Cache 5.X ODBC connection

Easy question I think.... I want to do a distinct count of a formula field. // if isnull({DU_COLL_CREDIT_FOR_LEGAL_N_B.DATE_RETURNED}) = false then{DU_COLL_CREDIT_FOR_LEGAL_N_B.ACCOUNT_NUM} Distinct count gives me one more than I want because the formula returns a default. When you use...

Anyone know of an outlook addin which will allow rules to access a database to determine action on incoming emails? For example if text 1234567 is in the subject quesry database to determine who is responsible for that "case number" and forward the email to that person. Outlook version 2003...

This may not be a formula issue but what the heck... I am having issues with a report where, if there are a certain number of detail records, the group footer falls on a page by itself. I dont want that to happen. I need the group footer to always be at the end of the last details section. Is...

I have a requirement to group data in a way I have never done before. I have 2,000 records each containing a score. I need to group the data in equal groups of ten. the resulting data would need to look like this. Score number of records 0 to 218 100 219 to...

I have a scenario wher I need to compute summary information based on group level information which could change form group to group, then compute those results at the end of the report. Group Account Number: 23134 insert 1 insert 2 insert 3 insert 4 insert 5 group footer computes $1.10 to...

I am trying to output a report so that each field has specific size definitions. In other words I need the resulting output to be a fixed length file format so that it can be read by another program. Any input on the best way to accomplish this? _____________________________________ Crystal...

Anyone on this forum doing any data mining on internal historical data in the Collection Industry. Curious to see what kinds of tools are being used or are most agencies outsourcing. _____________________________________ Not the brightest Crystal Reports XI Developer Version user in the...

What is the easiest way to make a report look like a spreadsheet with all the values seperated in cells. Would you guys suggest adding boxes to all of the cells? is there an easier way? _____________________________________ Not the brightest Crystal Reports XI Developer Version user in the...