Search results for query: *

I have a report that posts info for departments on a monthly basis. Here is my problem, December 2002 info is posting as Dec-2003 causing it to come after Jan-2003. This did not post like this untill Jan-2003 info posted, somehow changing Dec-2002 to Dec-2003. I group by my field status.date...

I have reports that I would like to have refresh nightly so that when the customer looks at the reports in the morning they are updated. Also I want to hide the refresh button on the web viewer so that they not be banging the server all day long manually refreshing every 30 seconds. Sorry for...

I have and application that I do not want end users to have access to the refresh button on the CR??? Otherwise our server will be getting slammed with end users refreshing every 5 seconds. Thanks, John

I have a cascasing list of Groups, showing a company heirarchy from the President to the agents. I am creating a report that shows everyone in the chain of command above the agent that submitts an idea. I have suppressed the groups if the group is empty, but I would like to be able to put a...

I have a report with 9 groups that show a organizational workflow hierarchy. For example, shows president and everyone under him, then Directors and everyone under them.....all the way to the person who first submitted the idea. My question is that sometimes ideas come from interns, which goes...

I am finding this to be very frustrating. When I create a report using CR8, save it, run it everything is fine. Now, if I want to add a something to the report, say a field, when the report refreshes I loose all of my design mods and have to basically start over from scratch. Is there a way...

I am creating a formula to put into a cross-tab that will show a %. I am using the following formula. CDbl ({Total_View.total}) I am running into 2 problems: 1. When I try to use the above formula in the report detail section, it returns with the error message of "String is...

I have a column that I want to show total count and % of total count for each column header. Is this possible? Example: I have headers of Submitted, Under Review, Completed. Now I want the Submitted column split in two for the total # Submitted and % of total Submitted. Then the same for...

I have a chart that is a "Trend" Line chart. It shows data month to month. I have the "on change of" as field "Date". "Date" shows in month-year format (Mar-2002). The problem is that when the the chart is previewed, it goes in assending order...

I am creating a report that I need to return the # of days till a project is due. I have this currently: if CurrentDate - DTSToDateTime ({reports.modifieddate})>120 then "Past Due" else "OK" I want to change the "Past Due" part to " This is due in x...

I don't want anything to show on report if on refresh the "discrete value" is not "added" to the "value box". What to do? Formula? Thanks, John

I am creating a parameter to do a sort on 3 columns, with the end user having the ability to select the primary field to sort upon. I have created a formula: If{?Sort}="B" then {All_Ideas_for_Crystal.BURUcon} Else if {?Sort}="S" then {All_Ideas_for_Crystal.Status}...

I am a novice CR developer and have a project that intails giving the end user the ability to sort by any group over the web to create individual reports. I am using information out of a Lotus Notes Database. My question is this, I would like to have the group tree show and have each of the...

I am thinking of using Crystal Reports to link to a Lotus Notes DB and have not been able find any information on how to pull information from the Lotus Notes DB to CR. Help appreciated. thanks

Has anyone had any experiences integrating CR with Lotus Notes? Trying to extract data from LN to CR for hard data output. Minimal CR experience and any tips or pitfalls to look for would be appreciated. Thanks