Recent content by arachnoid

Thanks to all for the responses. I am using Crystal XI and its my understanding that I cannot modify the SQL statement. Is that not the case? If that is the case, how would I go about modifying the query itself? Thanks again.

I need to substring a field in each of my files in order to link the tables together. Can I link the calculated fields in Crystal? If so, how? Any information will be greatly appreciated. For instance I would substring the following fields, then join the tables based on the substrings...

Thanks Buck! That did the trick!

I am looking for a formula that will allow me to force a page break if there are x number of records being printed on the page. For instance, if I have within a group 8 lines of detail and the first 2 are printing on the first page and the following 6 are on the next page, I want to force a...

I am looking for a formula that will allow me to reprint the group headers, if the group is incomplete on a page break. For instance, if John Smith's detail carries over to page 2, I want to the page header to read "John Smith (Cont.)" I've used this formula: If pagenumber <> 1 then...

I am having problems keeping a list of the available hours. I have a series of tasks with different due dates. I also know how long it will take to complete each task. See the table below: Task # Due Date Hours -------- -------------- ---------- 1 3/1/07...

Using CR XI, I am attempting to calculate the difference between the available hours using the following data set. WO# Due Date AVL Hrs. John Smith 12345 03/02/07 160 23456 03/30/07 320 34567 03/30/07 320 Group 1 is on Resource...

First, thanks for your response! The subreport is located in the Group #1a Footer. I am attempting to suppress Group Footer #1a and Group Footer #1b where the total in Group Footer #1b is = 0 The Shared Variable in the report is the total amount in the Subreport. I am calling the shared...

I am attempting to suppress records if they are equal to zero based on a formula using a shared variable between the main report and a subreport in the Section Expert. However, when I reference the formula in the section expert, it not only does no suppress records equal to zero, it also...

Thanks to both of you for your responses! [thumbsup] I have the main report calculating from the total of the subreport, but now I have a new issue. I am only wanting to print records where the difference between the two amounts does not equal zero. I have tried multiple variations of...

Main Report Sums total invoice amount from File A Subreport Sums total invoice amount from File B I need to print records where the total invoice amount of File A and the total invoice amount of File B are not equal to zero. Using Crystal Reports XI, can I calculate the difference of the...

Could someone, in very simple terms define a BO Universe for me? I am looking for a cubing solution within Business Objects Enterprise XI and was wondering if a Universe could work for me. Any info will be greatly appreciated. Regards,

I have a VBA function that determines the date based on the contents of a file. Is there a way to incorporate this function in a Crystal Report and then calculate date ranges based on its value?

I need to be able to create a custom function within Crystal that will query a file and then perform calculations on the results returned by the query. Specifically, I need to create a function that will read a date from a file and then calculate various date ranges based on the date in the...

I have figured it out. There is a check box at the very bottom of the first window that comes up when you select "New Database Query". With that box unchecked, you will go directly into Query when editing.