Search results for query: *

After speaking to Business Objects, they determined that the problem lies in the ODBC connection. We seem to have trouble with blob and memo fields.

I am using an ODBC connection to an Oracle database. I have created over 200 reports off of this database and this is my first memo field.

I am writing a report in Crystal Reports 10 which needs to pull in a memo field. When I preview the report, the field is only showing the first two characters. For example, the data should say "RIGHT SIDE" but it's only showing "RI". I have verified with the DBA that the data is correct for...

After further review, this is great for getting the week number. However, for example, although Dec. 21 falls into the 4th week, it is still the 3rd Wednesday of the month. This formula is pulling in a 4 rather than a 3 in this example.

Awesome! Thanks!

I am looking for a formula that calculates the week number of the month by day. For example, Wednesday, December 21 is the 3rd Wednesday of the month (3) and Thursday, December 22 is the 4th Thursday of the month (4), etc... Any help would be appreciated.

I will give that a shot. Thanks for you help!

I am using the code provided by Business Objects for Crystal Report Viewer. <%@ LANGUAGE="VBSCRIPT" %> <%reportname = "report.rpt"%> <!-- #include file="AlwaysRequiredSteps.asp" --> <!-- #include file="MoreRequiredSteps.asp" --> <!-- #include file="SmartViewerActiveX.asp" --> The shortcut...

This error occurs even when the report is not changed. I have many people viewing this report at the same time and they do open it when needed. Actually, a .rpt file is the only format that will overwrite the old file while it is opened by a user through Crystal Active X Viewer. Every desktop...

I have been using the Active X Viewer for several months to view a crystal report via our intranet. This report is scheduled to run every 10 minutes in Crystal Enterprise 10. It is exported to a network folder and overwrites the old file. So, if a user has their browser open for a long period...

Thanks guys! They both seem to work.

I am using Crystal 10 and am trying to write a formula in the record selection. I currently have a parameter, but am trying to do away with it for the report to run automatically in Enterprise without having to update the parameter everyday. I need to select the data from yesterday starting...

That did it! Thanks so much!

Hmmm....I tried that it is still assigning both values as currency. I even deleted the old graph and started from scratch following your instructions.

I am using Crystal Reports 9. I have two running totals per group (month), one is "Total Repaired" resulting in a number and "Total Cost" resulting in currency. I am putting these results into a side by side bar graph, so I have 2 bars per month. I need to display the data values on each bar...

That did it! Thanks a bunch!

I guess I wasn't clear. Sorry. I am actually trying to suppress the footer, so If I moved everything to that footer, I will be supressing everything. The layout looks like this: GH1 GH2 GH3 Da Db Dc GF3 Running Totals in this footer. GF2 GF1 I need suppress everything but the last GF3...

It is actually a group within a group within a group, so it makes it a little more difficult. Basically, the easiest solution that I can think of (if it were possible) is to create a running count to count each record within the group: whileprintingrecords; numbervar counter := counter + 1; I...

I am trying to suppress all but the last record of each group. Is it possible to write a formula to select the last record (OnLastRecord) of each group, rather than the last record of the entire report? Thanks