Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrdjsm1th

    Linking Tables In Crystal

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

    Formula Logic to Format String Data into Fixed Columns

    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!
  3. mrdjsm1th

    Formula Logic to Format String Data into Fixed Columns

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

    Formula Logic to Format String Data into Fixed Columns

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

    Formula Logic to Format String Data into Fixed Columns

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

    Formula Logic to Format String Data into Fixed Columns

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

    Formula Logic to Format String Data into Fixed Columns

    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 //...
  8. mrdjsm1th

    Limitations of Subquery or View

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

    Limitations of Subquery or View

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

    Limitations of Subquery or View

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

    Limitations of Subquery or View

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

    Report Viewer for Saved Data and On-Demand Subreports

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

    Report Viewer for Saved Data and On-Demand Subreports

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

    third party scheduling tool

    Crystal Delivery works very well, and it is free.
  15. mrdjsm1th

    Report Viewer for Saved Data and On-Demand Subreports

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

    Report Viewer for Saved Data and On-Demand Subreports

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

    Using OR in record selection

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

    Crystal Report Viewer with On-Demand Subreport

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

    Chinese in RS pdf export

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

    Pervasive 8.70.014 ODBC with SSRS 2005

    Thanks Mirtheil. I 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...

Part and Inventory Search

Back
Top