Recent content by mrdjsm1th

Based on the information provided, it appears you will need to group by Mth and Phase and use an aggregate function like MIN, MAX or AVG on "JCCP"."ActualCost", and a SUM function on "APUL"."GrossAmt" in order to handle the many APUL records per JCCP record.

I figured out the issue with resetting the cnt (counter) variable. The colon was missing (should be cnt := 0, not cnt = 0) , and now everything appears to be working correctly. Thanks lbass and Dell for your suggestions!

The logic submitted by lbass works for the first plant (the report groups by plant), but not for the second plant. The second plant shows one ticket in the first row and I believe it is because the onfirstrecord function only works for the first group. I am trying to update the logic to use "if...

Sorry LB, I forgot to remove another formula from the report that was also using the stTickets variable. It looks like the logic is working correctly! Thanks for taking the time to help.

Thanks LB. I added the formula to the detail section, and also added the second formula to the group footer because the report groups the tickets for each plant. There are some issues with the logic in the detail section formula: 1.) A duplicate ticket number (100) was included twice in the...

Thanks Dell. I tried using the suggested logic in the @PopulateList formula in the report detail section, but it just prints an asterisk for every row. It looks like the issue is the rowCount variable does not increment after each distinct ticket is added, and I am not sure how to do that in...

We have a business requirement to print a list of ticket numbers into a fixed column format and include an asterisk at the beginning of each row. The following @PopulateList formula is currently used within the detail section of the report: // {@TicketNo} is the trimmed Ticket //...

Yes, I can execute the original statement, however I need to join other tables to the results of that statement.

Yes, here is the error message I get: ODBC Error: SQLSTATE = 37000, Native error code = 0 Syntax Error: select * from ( SELECT<< ??? >> Inmx.ProdID , 'Component1' as Component , Mix1CompID as MixCompID , Prod.GrpID as ComponentGrpID , Mix1Pct/100 as MixPct FROM Inmx

Is it possible to do something like this? Select * from ( SELECT Inmx.ProdID , 'Component1' as Component , Mix1CompID as MixCompID , Prod.GrpID as ComponentGrpID , Mix1Pct/100 as MixPct FROM Inmx LEFT OUTER JOIN Prod on Inmx.Mix1CompID = Prod.ProdID WHERE Mix1Pct <> 0 UNION SELECT...

I am using Pervasive 8.70.014 and trying to work with a denormalized table in a third party database. The difficult table has 12 columns to store bill of material mix components and I am attempting to normalize the columns into a view or derived table for a reporting solution. I am having...

Thanks MJRBIM and chelseatech for your suggestions. MJRBIM - I tried your suggestion, but unfortunately it just added another data source that required credentials. chelseatech - I evaluated cView, but it did not prompt for a password. It generated an error message when I launched the...

The subreports are on-demand, so they are empty.

Crystal Delivery works very well, and it is free.

Thanks for the response. The report is currently distributed to 10 people via email each week. The report file contains saved data. The users currently drill-down on several summary groups within the saved data of the main report. When they get to the last level of drill-down detail, they...