-
Advanced Matrix Report
I just wanted to point you to this interesting link to some advanced matrix techniques (you can skip some points in the blog, as it is related to rdl instead of rdlc) http://www.simple-talk.com/sql/reporting-services/advanced-matrix-reporting-techniques/
-
Filtered list Link from report
hi, i think this is not possible, but someone of you maybe found a workaround... basically, i have to run something similar to a drilldown from a report of mine: i know how to run hyperlinks from a report, and i'm abusing it since i started to design reports for the 3 tier...the problem is that now, for the first time, i…
-
Visual web developer shortcuts
useful link: http://msdn.microsoft.com/en-us/library/ky31yd5a.aspx hint: take a big look at the yellow note in that article :!: EDIT: these shortcutse are not working on my VWD 2008 :evil: :evil:
-
open google maps
It's simple but I hope that it will help From the Customer card put this code to open google maps with the client's address: HYPERLINK('http://www.google.es/maps?f=q&hl=es&q=' +Address+' '+"Address 2"+' '+City+' '+County); And another to open google maps with the route from the direction of our company to the customer's…
-
How to Delete the obsolete object using non-accessed license
I have a few objects that can only be read by the Developer license, and not by the customer license. And now, I want to clean them from the customer database. I have recommend the customer to use their license, and do the deletion. The problem is they even could not delete them because their license did not allow it.…
-
Repeatonnewpage does not work ?
i have a report with a list object, containing some tables. the first tables have repeatonnewpage set to true, but this actually not work! do you know if there are some issues in using repeatonnewpage in tables within a list? I don't know where to bang my head... thanks in advance
-
How simply to do "try-except" in NAV
Hi I propose simple method for catch an errors in NAV. Need such Automation: VBScript Automation 'Microsoft Script Control 1.0'.ScriptControl Example: IF NOT ISCLEAR(VBScript) THEN CLEAR(VBScript); CREATE(VBScript); VBScript.Language := 'VBScript'; Source := STRSUBSTNO('' + 'Function TryExceptMethod' + '%1%1' + ' On Error…
-
Can I hyperlink to a MS Word bookmark?
Hello, we've got NAV 5.1 with SQL Server 2005. We're able to open a Microsoft Word document using a Hyperlink in NAV like this: HYPERLINK('file:///c:\tmp\doc1.docx'); This also works: HYPERLINK('c:\tmp\doc1.docx'); However, what we want is to be able to open up the document to a certain point where we've put a bookmark.…
-
User Menu Level Blob Data Field Data interpretted
The user menu level table stores the user's Menu Suite permission in a object type blob field in binary form. Find the interpretation of this binary data at http://extremeengineers.net/dynamics-na ... part1.html
-
On the fly hiding of MenuItems from Menubuttons.
In stead of making two menu buttons that are placed on top of each other and depending on some conditions wich one should be visible and thereby offering the user other menu items there is an other way to do this. The property PushAction together with InvalidActionAppearance will do the trick. See sample code form for the…
-
Standard Text(undocumented)
Hi Guys, we all know that when we place a "?" in all text datatype inside NAV, standard text form will show and we can get the description of it, I just found out that we can also use this when we assigning the variables in global or local, just enter ? and press enter standard text form will show and the value will be…
-
Shortcut for Windows tab in Nav
Hi Everybody, If we opened 3 forms it will show in windows tab in Nav. Normally we can choose opened form from windows tab. otherwise we can use shortly [Ctrl+ Tab] Control will help for this. I think this will be useful..:) :) .
-
Redesign Report Layout on 3 tier
here's a useful link a colleague suggested me. It lists some of the features that existed in classic reports, and how to replicate them in RDLC, enjoy! http://msdn.microsoft.com/en-us/library/dd338753.aspx
-
Import/Export User Roles
I am having active directory users added to my Navision database. I need to delete all the users from Navision and add them again. Is their any way so that i can export, using dataport, the roles assigned to current users, so that i can import them in Navision while the users with same user Ids are added again into the…
-
Encrypt Messages
A way to encrypt messages, this code change the order of the message and change some letters for other symbols. OnRun() /////////////Encrypt Messages/////////// //Message TextMessage := 'This message is encrypted'; Length := STRLEN(TextMessage); //Message Encryption i := Length; REPEAT Letter := COPYSTR (TextMessage,i ,1…
-
control Navision Title Bar or Status Bar
Does anyone know a way to control what is displayed on the Navision title bar or status bar? We used to display the server, database, and user id you were logged in with on the main form in 3.7, but that form is no longer used in 4.0. It’s was a handy way to check to make sure you are in the test database you thought you…
-
NAV 2009 Developer and IT Pro Documentation moved
For all of you who spent WAY too much time trying to find where the &^%$ online help is.... they moved it here: http://msdn.microsoft.com/en-us/library/aa306436.aspx REALLY annoying... if you HAVE to put all help online, put in one place and leave it there!!!
-
increment alpha variable?
I have a code variable that might be A or B or 1 or 2, etc. I have a report that is using INCSTR(variable), but this is unable to increment the alpha variables. Is it possible to increment to the next alpha? Thanks!
-
NAV 5.0 on Windows 2000
The msi installation fails, but when you copy the client folder to the program files and run the fin.exe it will work.
-
ctrl+f4 (rtc)
this shortcut allows the direct opening of the advanced lookup feature (instead of the default "dropdown" behaviour)...nothing new up to now... but try to program your custom lookup through code, then click the lookup arrow of the field: your custom lookup will be shown. now press ctrl+f4...your custom lookup is not fired…
-
Shift+Ctrl+ Up or Down Arrow Key
Want to move menu items with in a group. Try this Shift+Ctrl+ Up (Direction key) for making it move upwards or down for downwards. It works in both design mode or without that as well. It works for moving a group as well.
-
Shift+F10 = right mouse button
Hi, I've just learned (by mistake :) ) that Shift+F10 = right mouse button Works outside NAV as well (most probably it is system shortcut), at least on my Windows XP. Regards, Slawek
-
Pass paramater to a form (or SubForm) using RUNMODAL or RUN
There are a few ways to pass a parameter to a form. The most common is to define a variable of type FORM create a function in that form and call the function to set parameters. There are a few cases where it is not possible or not ideal to do this. For example calling a form from a button on another form, or a SubForm.…
-
Install PDFCreator without toolbar or user interaction
There is a major issue with the current 0.9.8 PDFCreator installer, as it installs the browser toolbar even if it is unchecked in the wizard. (Discussed here.) To work around this issue (and make the installation process easier for your users), use a settings file during installation: Download the most current PDFCreator…
-
About this report 2009Sp1
hi everyone, this is a documented feature, but in case someone missed it... when you are previewing a report, press ctrl+alt+f1 (or the top right button, and then "about this report...")to see the dataset being passed to the rdlc for rendering. Actually, this is the "only" debugger we have when doing rdlc. NOTE: You have…
-
Interact Wizard loses Comments
Not a Support request - this is a bug report. When using Interact Wizard (Form 5077), one has the opportunity to add comments directly, next to Description Field. These comments are not recorded due to a bug in Table 5077 (Segment Line), whereby comments are added to a LOCAL Temporary Table, in stead of a GLOBAL Temporary…
-
Check if user belongs to a certain role in a certain company
Function UserBelongsToRoleInCompany(ItxtUserID:text250 ; IcodRoleID:Code20 ; ItxtCompany:Text30): Boolean// Checks if a user belongs to a certain role in a certain company// PARAMETERS:// ItxtUserID:user to check (mostly USERID)// IcodRoleID:the role ID to check (can also be 'SUPER')// ItxtCompany:Company to check (mostly…
-
Convert Duration, in milliseconds, to Days, Hours, Mins, Sec
Convert a Duration, in milliseconds, to Days, Hours, Minutes, and Seconds (without complicated FORMAT commands) The code below has several assumptions: 1. You want to have easy access to the Days, Hours, Minutes, and Seconds between two DateTime variables. 2. Your start date is a DateTime variable is called vFirstDT. 3.…
-
Code Coverage - exporting and filtering
When using Code Coverage, I would like to: a) filter out the lines have not been executed (i.e. the red lines) b) export the lines (actually, just the black lines) to a single text file. Does anyone konw how to do this? Thanks, Alastair
-
Opening a form always jumps to the subform control
This is particularly noticeable when you have multiple tabs on a form when having a subform on one of the tabs. When you open the form, the active control jumps to the subform on a new line. In order to resolve this you need to ensure that the property "DelayedInsert" = true in your subform. Regards, gus