an error during calling report from page
snyktp
Member Posts: 75
Hi,
I have a problem during running a report from another object(page). You can see the my codes below. Those codes are on an action (menu item) on a page (form). I get an error when i call the report,the error related to yellow line.You can see the error at the attachement.
SalesHeader := Rec;
SalesHeader.SETRECFILTER;
CLEAR(PDDocument2);
PDDocument2.SETTABLEVIEW(SalesHeader);
PDDocument2.SetBoxQty(Rec);
PDDocument2.RUNMODAL;
Thank you
I have a problem during running a report from another object(page). You can see the my codes below. Those codes are on an action (menu item) on a page (form). I get an error when i call the report,the error related to yellow line.You can see the error at the attachement.
SalesHeader := Rec;
SalesHeader.SETRECFILTER;
CLEAR(PDDocument2);
PDDocument2.SETTABLEVIEW(SalesHeader);
PDDocument2.SetBoxQty(Rec);
PDDocument2.RUNMODAL;
Thank you
0
Answers
-
snyktp wrote:Hi,
I have a problem during running a report from another object(page). You can see the my codes below. Those codes are on an action (menu item) on a page (form). I get an error when i call the report,the error related to yellow line.You can see the error at the attachement.
SalesHeader := Rec;
SalesHeader.SETRECFILTER;
CLEAR(PDDocument2);
PDDocument2.SETTABLEVIEW(SalesHeader);
PDDocument2.SetBoxQty(Rec);
PDDocument2.RUNMODAL;
Thank you
the report PDDocument2 is not transformed into RTC0 -
Thank you for the answer but i dont think so. because when i call the repurt like this
dynamicsnav:////runreport?report=61033, the report runs.
the problem is related to yellow line because before running report, i call a function from the report.
thank you0 -
The report runs, but it runs as RDLC or as window from Classic client?0
-
Hi,
It runs as windows form classic client because ProcessingOnly of report is NO. If it is YES,it will run as RDLC. Can you see the error message? It says that you call a function from report,before running report.
Thank you0 -
snyktp wrote:Hi,
It runs as windows form classic client because ProcessingOnly of report is NO. If it is YES,it will run as RDLC. Can you see the error message? It says that you call a function from report,before running report.
Thank you
is this a customization thet if ProcessingOnly of report is NO then run Classic and if yes run RDLC? :-k
if not,
its not like that if ProcessingOnly of report is NO then run classic .
the report is not transformed.
export the report in text format and check whether rdl data is there or not
its not related to function called before the report0 -
Hi,
But when I delete yellow line ,it runs. Is not it strange? Because you said that it is not related to calling a function before running report.
SalesHeader := Rec;
SalesHeader.SETRECFILTER;
CLEAR(PDDocument2);
PDDocument2.SETTABLEVIEW(SalesHeader);
PDDocument2.SetBoxQty(Rec);
PDDocument2.RUNMODAL;
It has this line.
}
RDLDATA
{
}
Thank you0 -
the first thing is report not transformed as rdl data is blank
and can you post the code in SetBoxQty funtion0 -
Hi Mohana,
What should I do? I dont understand what you want to say.
Than kyou0 -
Problem is this:
the mechanism, which allows you to run report as classic client report, is working only in situations, when the report is called through REPORT.RUN/RUNMODAL or directly through button properties. You cannot run classic report through report variable, because it is not allowed/possible by design of the system. This is what the error tells you. You need to run the report as RTC report (RDLC) to be able to call it through report variable.0 -
snyktp wrote:Hi Mohana,
What should I do? I dont understand what you want to say.
Than kyou
1)i want to see the code written in SetBoxQty funtion
can you paste the code here.
but i strongly feel, its not the problem.
2)open the report in design mode and click tools-->Create layout suggestion
and save the rdlc
test after doing 20 -
Hi,
The function is below
SetBoxQty(SalesHeader : Record "Sales Header")
WITH SalesLine DO BEGIN
SETCURRENTKEY("Document Type","Document No.","Item Type");
SETRANGE("Document Type",SalesHeader."Document Type");
SETRANGE("Document No.",SalesHeader."No.");
SETRANGE("Item Type","Item Type"::Container);
CALCSUMS(Quantity);
TotalBoxQty := Quantity;
END;
I tried 2. step , i got an error. it say "An error occured when opening Report designer. A supported version of Visual Studio could not be found"
Thank you for your help0 -
snyktp wrote:Hi,
I tried 2. step , i got an error. it say "An error occured when opening Report designer. A supported version of Visual Studio could not be found"
Thank you for your help
you need to instal the visual studio(>=2005) in your system.0 -
but I have already installed Visual Studio Express 2008, so I don’t understand the error.0
-
I think you have not installed complete visual studio/sql server0
-
you are right. Thank you0
-
snyktp wrote:you are right. Thank you
welcome :thumbsup:0 -
(Reposted in new post)NAVN00b0
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
- 322 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