Options

RTC Report Selective Filters Only & Landscape Report

postsauravpostsaurav Member Posts: 708
edited 2012-03-19 in NAV Three Tier
Hi all,

I know after reading this you might feel wiered but that is what i want to do.

1) My client wants to show only selective fields in the filter to the user?
Explanation -

Suppose report is on table item, and Report ReqFilterFields have value No.,Bill of Material,Unit Cost.
Now user can add other filters from the list. Now client want that user should not find standard cost, Net Weight fields in the list. Is there any way that it can be achieved?

2) My client wants to run a report that is in Landscape format?
Explanation -
In classic client when we run a report that has orientation as Landscape and print it, it automatically prints in landscape format.
Whereas in RTC if we run a report and print it, we need to specify the printer layout as landscape.

* I know there is a functionality of printer selection but client have only one printer and they want that if report is in landscape it should come automatically in the format.

Please let me know if anyone know how these can be resolved.

Thanks & Regards,
Saurav Dhyani

Thanks & Regards,
Saurav Dhyani

Do you Know this About NAV?


Connect - Twitter | Facebook | Google + | YouTube

Follow - Blog | Facebook Page | Google + Page

Answers

  • Options
    BeliasBelias Member Posts: 2,998
    1) set the dataitemtableview and don't set any request filter (this will hide page where you can set the filters by standard), then create a request page where the user can only set the filters you want. BTW, request pages are a pain to design in some instances (e.g. when you have to program onlookup/onvalidate triggers :( ). I suggest you to avoid this, whenever possible
    "standard cost, Net Weight" --> why these two filters, is this data so "private"?
    2) search mibuso :wink:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Options
    postsauravpostsaurav Member Posts: 708
    Hi belias,

    thanks for the reply.

    For solution 1 - I know that but the client wants to hide only certain fields and let users to use other fields, like he wants to hide cost related fields from the filter.

    For solution 2 - I tried searching that on mibuso, but didnt find any link.

    Any help will be great.

    Thanks
    Saurav

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • Options
    BeliasBelias Member Posts: 2,998
    1) in that case, As far as i know its not possible...what you CAN do is to remove these filters by code: in this way, no matter what filter is set by the user, it will be "voided"
    2) search google for landscape rdlc nav :-k ...c'mon be creative ;)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Options
    postsauravpostsaurav Member Posts: 708
    Hi Belias,

    Thanks for the reply and motivation :).

    I tried and finally found the solution for the issue 2 but the issue 1 is still open.

    Thanks & Regards,
    Saurav Dhyani

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • Options
    BeliasBelias Member Posts: 2,998
    I think I already gave you the only possible "solutions" to your issue #1...
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Options
    vijay_gvijay_g Member Posts: 884
    AFAIK the above solutions are more than enough, moreover you can create a alternate table(saveas to item table) with user difined fields only and use this as first dataitem in your report(but You can only have list for filter where table relation property has set).
Sign In or Register to comment.