Running reports and parameters

poverocane
Member Posts: 32
Hi all and thanks in advance for your help...
I have a problem passing parameters and datas between a form and a report...
I have inserted this code:
...
REPORT.RUN([report no.],TRUE,FALSE,Rec);
...
in the Purchase Invoice form, in the OnPush event of a Command Button trigger.
Then i've created a report that has the Purchase Header table as the DataItem. Also the SourceTable property of the Purchase Invoice form is set to Purchase Header.
My problem is that, when i call the report, the report doesn't show the Document Type and the Number values in the initial window (Request Form window, it could be...)...
My question is: what is the problem?
Why form and report don't match datas?
I hope beign clear...
Thanks a lot..
poverocane
I have a problem passing parameters and datas between a form and a report...
I have inserted this code:
...
REPORT.RUN([report no.],TRUE,FALSE,Rec);
...
in the Purchase Invoice form, in the OnPush event of a Command Button trigger.
Then i've created a report that has the Purchase Header table as the DataItem. Also the SourceTable property of the Purchase Invoice form is set to Purchase Header.
My problem is that, when i call the report, the report doesn't show the Document Type and the Number values in the initial window (Request Form window, it could be...)...
My question is: what is the problem?
Why form and report don't match datas?
I hope beign clear...
Thanks a lot..
poverocane
Fantasy is more important than knowledge.
A. Einstein
A. Einstein
0
Comments
-
instead of
...
REPORT.RUN([report no.],TRUE,FALSE,Rec);
...
try to do this
//PurchHeader record Purchase Header... PurchHeader.SETRANGE("No.","No."); REPORT.RUN([report no.],TRUE,FALSE,PurchHeader); ...
read more about Rec and xRec , on form it can be an empty record.keep it simple0 -
Polar wrote:instead of
...
REPORT.RUN([report no.],TRUE,FALSE,Rec);
...
try to do this
//PurchHeader record Purchase Header... PurchHeader.SETRANGE("No.","No."); REPORT.RUN([report no.],TRUE,FALSE,PurchHeader); ...
read more about Rec and xRec , on form it can be an empty record.
When you run the report with
REPORT.RUN(..,..,..,rec), the request forms shows all filters applied to Rec.
As you don't have any filters set on Rec variable, it will not fill in the required filter fields."Simplicity is the ultimate sophistication."
Leonardo DaVinci0 -
Try to add a GET or FIND command after your SETRANGE.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions