Hi. I am trying to create a report that returns a list of the Sales Desk Worksheets that a specific user created within a certain time frame. I think I have the info I need, but I am only getting the first result.
Options Page
1. Entered Date
2. Document Type
3. Enetered User ID
Report Page
1. Information is pulled from the following formula (Hidden Row): =NL("Rows","sales header",,"Entered Date",Options!$D5,"Document Type",Options!$D6,"Entered User ID",Options!$D7,"Gen. Bus. Posting Group",Options!$D8)
2. Document No.
3. Entered Date
4. Sell-To Customer No.
5. Sell-To Customer Name
6. Enteerd User ID
7. Item No. (NL function back to the Document No.)
8. Line Amount (NL function back to the Document No.)
I can send someone the report to look at if my info doesn't make sense. My report should yield 7 rows of results based on the filters I entered in the options page, but I am only getting the first result.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment I took a look at your report. It looks like you haven't "grouped" this report correctly. I made some changes to the report and colored the cells that I changed. I can't test the report because you use fields in your database that I don't have, but I think it's correct.
A document on grouping can be found at http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=86
SDWs(JET).xls -
Jet Reports Historic Posts Thanks., That fixed one problem. Each sales line is coming up on the report. Thats is great.
UPDATE:
I checked the results incorrectly. This has corrected my problem.
THANK YOU SOOO MUCH! :D
Please sign in to leave a comment.