Search results for query: *

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.

...ticket number (100) was included twice in the results and it should only be included once. 2.) The first line in stTickets does not have the "*" row identifier and it only contains one ticket 3.) The second line in stTickets starts with the "*" row identifier and it looks all of the tickets...

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...

...output, where the number of tickets included per row is defined in a variable (5 in this example) and each row begins with an asterisk: * 100 1000 10000 100000 200000 * 300000 400000 1000000 3000000...

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...

...as MixPct FROM Inmx LEFT OUTER JOIN Prod on Inmx.Mix2CompID = Prod.ProdID WHERE Mix2Pct <> 0 ...10 more Union Selects for each of the Inmx.Mix*CompID Does Pervasive 8.70.014 allow multiple Union Selects within a view? Is it possible to use the above statements as a derived table within an...

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...

We are using Crystal Reports XI with Microsoft SQL Server 2005 using SQL Server Authentication. We have reviewed some of the Crystal Report viewers on http://www.kenhamady.com/bookmarks.html and would like to select one that allows users to drill-down on data that is saved in a report in...

I think the suggestion posted by lbass is correct. You should look at Database -> Show SQL Query to confirm that your SQL looks something like: Select tblCase.CaseID , tblCourtReportType.CourtReport , tblCourtReportType.CourtReportTypeRef From tblCase Left Outer Join tblCourtReportType on...

I have reviewed some of the Crystal Report viewers on http://www.kenhamady.com/bookmarks.html and would like to select one that allows users to drill-down on data that is saved in a report and launch on-demand subreports within the same report. The on-demand subreports contain sensitive...

Have you successfully exported the report in other formats like Excel, Web Archive or TIFF?

...hope you can help me through a couple scenarios. Scenario #1 Some of the reports I am converting have multiple parameters. For example: select * from slbudget where locationid = ? and YearNo = ? and TypeID = ? Currently, all three parameters are displayed as "?", so the user won't be...