Temporary Table in report

steven
Member Posts: 5
Hi all
There is some way to lunch report with REPORT.RUN and to say it to work on a temporary table?
Es:REPORT.RUN(IDREPORT,FALSE,TRUE,recItem2)
recItem2 is a RECORD Item but declared temporary!
Thanks in advance
There is some way to lunch report with REPORT.RUN and to say it to work on a temporary table?
Es:REPORT.RUN(IDREPORT,FALSE,TRUE,recItem2)
recItem2 is a RECORD Item but declared temporary!
Thanks in advance
0
Comments
-
steven wrote:Hi all
There is some way to lunch report with REPORT.RUN and to say it to work on a temporary table?
Es:REPORT.RUN(IDREPORT,FALSE,TRUE,recItem2)
recItem2 is a RECORD Item but declared temporary!
Thanks in advance
No, as far as I know.
But, you can through report function, send temporary var/record to report (with VAR parameter checked on input parameters of function).
Than, in that function you should transfer all records from that temp record to another temp record that is declared in global section of that report (with a Loop or however you want).
after that you can use Integer var for looping through your temp record in report.
sounds complicated but it isn't, though, somebody else could have simplier solution.0 -
-
Create an Function in your Report where you fill (or give them <- Call by Reference Variable (VAR) on this solution you need an second global variable TempTab2, be sure that this variable is temporary) the temporary table.
As DataItem u use "Integer"
Code in PreDataItem()
TempTab.reset;
setrange(numer,1,TempTab.count);
Then in the AfterGetRecord()
if Numer = 1 then
TempTab.find('-')
else
TempTab.next;
.
.
.
In The body Sections (Also Header,Footer, etc.) of Integer you give out the datas from the TempTab.
But when you need the grouping function, you must write some lines of code.
So, if you fill the TempTab not in the Report you must write this:
//Here you fill you TempTab
YourReportAsVariable.SetTempTab(VAR TempTab);
YourReportAsVariable.userequestform(false); <- if you not need the Request form
YourReportAsVariable.run;
If you fill the TempTab in the Report
YourReportAsVariable.FillTempTab(Your Parameters if you need one);
YourReportAsVariable.userequestform(false);
YourReportAsVariable.run;
RegardsDo you make it right, it works too!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