roboticapps1
IS-IT--Management
Background info:
Epicor Vista 8.03.406
Crystal Reports 11.0.0.1282
Very new and unfamiliar person learning to create a report from Vista using CRXI.
I am looking to create a custom report from Vista. I have been reading all the documentation given to us from Epicor and I have also been watching the tutorial videos. Currently, I am having problems formatting the report in Crystal Reports. This is to assume that I've done all the other steps correctly. Please help if I am wrong but these are the steps I have taken:
1. I first created a new Business Activity Query (BAQ). For this explanation I will title it COMPANY-TestReport with the description of Test Report.
2. I clicked on Phrase Builder and the tables that I selected are InvcHead and Customer
3. Next, I went to the Display section and I only included
Customer.Name
InvcHead.InvoiceNum
InvcHead.InvoiceDate
InvcHead.InvoiceAmt
InvcHead.InvoiceBal
4. I didn't change the Headings section
5. I Analyzed the BAQ and it had no syntax errors so I tested it and all the data was visible, exactly the way I want.
6. I didn't change anything else because I could see that the data that I want was clearly queried, so I saved and exited the BAQ
<This is where I start the BAQ Report Designer>
7. I open the BAQ Report Designer and I click new. I enter
Report ID: InvcRpt
Description: Invoice Report
BAQ ID: COMPANY-TestReport
Crystal Report: InvcRpt.rpt
8. I don't change the List section but I create two Option Fields to give me a range of dates that look like
Option Field FieldLabel Compare Operator Data Type
InvcHead.InvoiceDate Invc Date >= date
InvcHead.InvoiceDate Invc Date <= date
9. I didn't put any filters in because I wanted to test the report to see if everything worked before working any further but I did put two sorts in, Date/Num or Num/Date.
<Testing the BAQ Report>
10. I clicked action and BAQ Report Actions and followed the recommended options in the book.
11. I saved everything and wanted to see the progress I had so far so I clicked Action and Test Report Form. Sure enough, the Option Fields showed up for me to put a range in dates. I put the date range in and clicked Print Preview to see how the date looked. Strangely, no data was visible on the Print Preview. At first I thought that no data was suppose to show up because it was just testing the form so I moved on.
12. I generated sample data and received a message saying that sample data generated successfully. (a XML file)
13. So then I clicked Design Crystal Report. Once I in Crystal Report, no data was on the report. Then I assumed that I need to import the sample data so I can manipulate the report to how it should look. So I clicked Database Expert and then Create New Connection and in here I didn't know whether to use the folder OLD DB (ADO) or the folder XML. I decided to try the XML folder first because the file in an XML file. I located the sample data and then unchecked Specify Schema File because no XSD file was available. When I tried to import the data, it kept giving me an error that no XSD file was found. So I figured I couldn't import the data through the XML option and decided to try the OLE DB (ADO) option. This case left me more confused with Providers to choose from and not knowing what to choose, I stopped there.
I am currently at a loss of things to do. I'm sure I created the BAQ correctly but I can't seem to get the Report to work correctly. I'm not even sure if what I'm doing is the best way or even the correct way for me to pull a report. If anyone can critique me or show me a better workflow or show me flaws in my procedure, that would be greatly appreciated.
Thank you for reading and I apologize for such a lengthy post.
Epicor Vista 8.03.406
Crystal Reports 11.0.0.1282
Very new and unfamiliar person learning to create a report from Vista using CRXI.
I am looking to create a custom report from Vista. I have been reading all the documentation given to us from Epicor and I have also been watching the tutorial videos. Currently, I am having problems formatting the report in Crystal Reports. This is to assume that I've done all the other steps correctly. Please help if I am wrong but these are the steps I have taken:
1. I first created a new Business Activity Query (BAQ). For this explanation I will title it COMPANY-TestReport with the description of Test Report.
2. I clicked on Phrase Builder and the tables that I selected are InvcHead and Customer
3. Next, I went to the Display section and I only included
Customer.Name
InvcHead.InvoiceNum
InvcHead.InvoiceDate
InvcHead.InvoiceAmt
InvcHead.InvoiceBal
4. I didn't change the Headings section
5. I Analyzed the BAQ and it had no syntax errors so I tested it and all the data was visible, exactly the way I want.
6. I didn't change anything else because I could see that the data that I want was clearly queried, so I saved and exited the BAQ
<This is where I start the BAQ Report Designer>
7. I open the BAQ Report Designer and I click new. I enter
Report ID: InvcRpt
Description: Invoice Report
BAQ ID: COMPANY-TestReport
Crystal Report: InvcRpt.rpt
8. I don't change the List section but I create two Option Fields to give me a range of dates that look like
Option Field FieldLabel Compare Operator Data Type
InvcHead.InvoiceDate Invc Date >= date
InvcHead.InvoiceDate Invc Date <= date
9. I didn't put any filters in because I wanted to test the report to see if everything worked before working any further but I did put two sorts in, Date/Num or Num/Date.
<Testing the BAQ Report>
10. I clicked action and BAQ Report Actions and followed the recommended options in the book.
11. I saved everything and wanted to see the progress I had so far so I clicked Action and Test Report Form. Sure enough, the Option Fields showed up for me to put a range in dates. I put the date range in and clicked Print Preview to see how the date looked. Strangely, no data was visible on the Print Preview. At first I thought that no data was suppose to show up because it was just testing the form so I moved on.
12. I generated sample data and received a message saying that sample data generated successfully. (a XML file)
13. So then I clicked Design Crystal Report. Once I in Crystal Report, no data was on the report. Then I assumed that I need to import the sample data so I can manipulate the report to how it should look. So I clicked Database Expert and then Create New Connection and in here I didn't know whether to use the folder OLD DB (ADO) or the folder XML. I decided to try the XML folder first because the file in an XML file. I located the sample data and then unchecked Specify Schema File because no XSD file was available. When I tried to import the data, it kept giving me an error that no XSD file was found. So I figured I couldn't import the data through the XML option and decided to try the OLE DB (ADO) option. This case left me more confused with Providers to choose from and not knowing what to choose, I stopped there.
I am currently at a loss of things to do. I'm sure I created the BAQ correctly but I can't seem to get the Report to work correctly. I'm not even sure if what I'm doing is the best way or even the correct way for me to pull a report. If anyone can critique me or show me a better workflow or show me flaws in my procedure, that would be greatly appreciated.
Thank you for reading and I apologize for such a lengthy post.