Search results for query: *

I have made a couple of reports in Crystal Reports 8.5 Professional that use either 2 or 3 unions depending on the report. Our software vendor just upgraded the crystal viewer for all of our users to Crystal X. All of our regular reports work just fine, however when I go to run a report that...

Crystal Reports 8.5 Hi everyone, I could really use some help on this. What I am trying to accomplish is generate a list that shows each piece of raw material for an assembly. It would like like follows: Assembly 1 Raw Material 1 Component 1 Component 2 Raw Material 2...

Hi all, I'm using Crystal 8.5 I am making a report that is grouped by Customer, then by Part. Each part shows a crosstab and a chart of the average price, cost, and % margin for the month. I have checked these values and everything is fine here. The problem exists when I try to show a summary...

I'm running Pervasive 8.5 and I want to use a subquery as an item in the SELECT clause. I have a view that relates Inventory to Jobs in Process so I can get the total WIP for a part and compare that to whats onhand. However I also need to compare this to a summary of Open order quantity, and...

Crystal 8.5 I have a report with 3 groupings and group 1 is set to "Keep Together" and the other 2 groupings are either hidden or suppressed (don't think its relevant but can't hurt to mention). Once in a while the report page footer will get cutoff so the report can make room for another...

I am trying to create a report and I need to UNION my Open Orders with my Order History but sadly I have discovered in another forum that Pervasive 8.6 (my sql server) doesn't allow me to create views that uion 2 different tables (You can only union from the same table). Is there anyway using...

Pervasive 8.6 SP1 I have been trying to create a union of two views on my pervasive server. First I tried to create a view that made a union of two tables but then I learned on this forum that is not supported. Now I am trying to use query tools like Microsoft Access and Crystal SQL Designer...

I'm new to management reporting and this summer I've been creating alot of crystal 8.5 reports for various functions of the shop. One thing that I keep encountering is the need to analyze and relate data on a many to many relationship. While I find using a sub-report is an effective means to...

Hi I am trying to create an update query but I get the following error: Operation must use an updatable query The query joins two a table (Daily Log) to a query (Time and Attendance) and then is supposed to update 2 fields in Daiy Log to the appropriate times in Time and Attendance for...