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!

  • Congratulations strongm 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: *

  • Users: epmo
  • Order by date
  1. epmo

    Cannot determine the queries necessary to get data for this report

    When you add parameters to the record selected formula, crystal reports might be confused , because there are 2 different connections. Try to add the 2 new tables to a subreport instead to the main report .
  2. epmo

    Compare Report Processing Time - any formulas or tools?

    I am using R-tag viewer. It shows start/end time and other information about each report - parameter values, workstation, how many times a report was used etc. It is perfect to plan report optimizations since you can easily find the list of slowest most used reports, how much time per period...
  3. epmo

    Hello, Is there a way to create

    Check this link for mock-crosstab sample: http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/10c4c9c3-a275-2b10-bfa6-87b265d5a0d9
  4. epmo

    Crystal Cross tab excel export

    I am a big fan of R-Tag Viewer, which can create a pivot table from a query. May be @IdoMillet is talking about this tool. Export to excel is clean and with formatting which makes the data easy to read. They have a video demoing the same crosstabed data in crystal , SSRS and pivot table, which...
  5. epmo

    Crystal-based database reports run in 32-bit windows but not 64-bit

    mbrayc, I would suggest you to install one of the products which are using crystal reports 13. A list is available here: http://kenhamady.com/viewerfeaturematrix.pdf I am using R-tag and it worked out of the box. It is available here: http://r-tag.com/Downloads.aspx Other applications that use...
  6. epmo

    Crystal-based database reports run in 32-bit windows but not 64-bit

    I am not sure how this should be handled with the virtual machine, but you should be able to run the application in both 32 and 64 bits mode on your Windows 7 64 bits machine. Do you have SAP runtimes 32 or 64 installed on your Windows 7 64 bit machine ? ( check your "Uninstal or change...
  7. epmo

    Crystal-based database reports run in 32-bit windows but not 64-bit

    mbrayc , it is really hard to give you an advice without knowing what is going on. If you go to "Uninstall program" dialog can you see: SAP Crystal Reports runtime engine for .NET Framework4(32-bit) or SAP Crystal Reports runtime engine for .NET Framework4(64-bit)
  8. epmo

    crystal report SQL query

    The query is used in place where one value is expected. The problem is not in the query syntax but in the returned data. Try to use distinct if it still returns the same error modify the where clause to return just one record: SELECT DISTINCT "LotNumberTransactions"."abtlotnumberid" FROM...
  9. epmo

    Need to create a seperate index file for report.

    I am using R-tag manager (from the same link). It runs a report against a list retrieved from the database then creates an index file and sends it by e-mail.

Part and Inventory Search

Back
Top