Isn’t there a table “query metadata” that I could use as well? Sure, that would be table 2000000142 :-).
If you filter the data on pagetype “API”, you get almost exactly the same as with the “API Web service” table – although, only pages, not queries – but at least it works in SaaS.īut then you might wonder. In fact, it was the API guru AJ that gave an alternative table that also has quite a lot of metadata: namely table “page metadata” (2000000138). still yes, but a little bit with a detour. If anyone has a clue why – please put it in the comments.ĭoes that mean there is no solution in SaaS? Can’t I list all API endpoints simply from the web client? Well. For some dark reason, I (admin) am not allowed to read that table in SaaS. you’d get a list of all available APIs :-).Īt least … if you’re working OnPrem. So, if you would add “ ?table=2000000193” in the URL. Namely table “API Web Service”, which is table 2000000193. Well, if you want, you can get that info from a system-table. It is easy when you know where to look, though. figuring out het available API’s in your system isn’t that easy at first sight. just under your fingertips of the web client.Īnd that’s also the case for API information. Then you know there’s quite a lot of information.
Check Customer License in an OnPrem db – from the web client.Getting not-out-of-the-box information with the out-of-the-box web client.
It turns out that this was mentioned on the 80146B manual on Chapter 3 page 35.Here’s a short post with a small tip about something a lot of you probably already know. Don’t make the same mistakes we did!ĮDIT – Thanks to Steven for pointing this out. We spent hours and hours trying to get our report header to print on multiple pages.
Public Function SetData(NewData As Object)Īnd you need these controls with the proper code: Return Cstr(Choose(Num, Split(Cstr(HeaderData),Chr(177)))) Public Function GetData(Num As Integer) As Object Public Function GetGroupPageNumber(NewPage As Boolean, PageNumber As Integer) As Object So when you create a report that has headers in forms (sales order, quote, etc). If the report goes to the 2nd page, the link is essentially gone, therefore, no value is loaded and so nothing is displayed. The reason why the 2nd page is blank, again, is because the link was done only on the first page on the header. I didn’t even have to use Paint to remove any information. Now this is what happens when you print the 2nd page: I used whiteout to remove some sensitive information in Paint. As you can see, the header displays nice and pretty. Here’s an example if you create a report without using the SetData and GetData logic: So this means that if your sales order is printed to the 2nd page, the header information will all disappear. If you’re printing multiple form type reports like the sales order and you do not use the SetData and GetData, the header will only link to the lines displayed on the first page of the report. For additional information on defining SetData and GetData, please look here.įor multiple pages, the header data is dependant on whether there are lines. The reason for SetData and GetData is not because of performance reason as stated in the manual 80146B. As I previously mentioned on my article, Microsoft really needs to address this in future versions.
Ever wondered why there’s no tutorial on how to create a Sales Order report from scratch in the RDLC? The reason is because it takes a LONG TIME! Even for an experienced developer, it takes a long time.