Show/hide A Field Based On The Logged In User In Reports
Hi,
I have some sensitive and non-sensitive info/fields in one of my reports. Is there a way to hide/show the info based on the logged in user? or do I have to create separte reports for each type of info like one for sensitive and another one for non-sensitive info.
Thanks inadvace for your help!
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Show/Hide Details And Sub-Reports
We were having a standards meeting today at my company and we talked about the show/hide details button in the UI. We hide reports all the time because they are sub-reports and aren't meant to be run on their own. If we can't hide the "Show Details" button and we can't ban the user with security from running the sub-report because they need to run the Main report which runs the sub-report, then what do we do? I'd think we have the have the ability to to hide things, or least a creative way to hide them; but I don't want to deploy sub-reports to wierd places just to get around this. The following posts reference this topic, but didn't address it; yet raise this question. Thoughts? Keith http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=950457&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=204599&SiteID=1 p.s. Just my own two cents, it would seem like a nice feature to be able to hide the "show details" button because there are advantages to hiding things.
View Replies !
View Related
Hide/Show Table Based On Parameter Selection!!!???
I'd like to hide/show a table based on selected parameters. In the current setup I have a matrix and two tables underneath that need to be displayed from time to time. First of I use a multi-value parameter called "Lieferart". Depending on the parameter I have set the visibility of the two tables with the following expression: =iif(Parameters!lieferart.Value(0) like "Nagel%", False, True) This expression doesn't work though, any ideas??? I am also unsure about what I have to do If multiple values from the parameter list are selected as Parameters!lieferart.value(0) doesn't necessarily need to have a label like "Nagel" included...
View Replies !
View Related
How To Show Only Records That Belong To The Logged In User.
Hello.I realize that this question has been asked before, but I still can't get it to work. Below are some links that might be of help:http://forums.asp.net/p/1159666/1913519.aspx#1913519http://forums.asp.net/p/1161930/1924264.aspxhttp://forums.asp.net/p/1116601/1732359.aspx#1732359http://forums.asp.net/t/1104718.aspxhttp://forums.asp.net/p/1096290/1655706.aspx#1655706http://forums.asp.net/p/1110162/1707952.aspx#1707952 Basically, I need a DropDownList to display only projects for which the logged in user is assigned as leader. The [Projects] table contains an integer ProjectId, a string ProjectName, a uniqueidentifier ProjectLeader, and other fields. Can someone help me with the SQL query and code? * Here is the definition of the SqlDataSource: <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ASPNETDB.MDFConnectionString %>" SelectCommand="SELECT [ProjectId], [ProjectName] FROM [Projects] WHERE ([ProjectLeader] = @Leader)" OnSelecting="SqlDataSource5_Selecting"> <SelectParameters> <asp:Parameter Name="Leader" Type="Object" /> </SelectParameters> </asp:SqlDataSource> * Here is the definition of the SqlDataSource5_Selecting method: protected void SqlDataSource5_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { e.Command.Parameters("@Leader").Value = loggedInUserId; } where loggedInUserId is a global variable of type System.Guid. It has been evaluated in the Page_Load event to as: loggedInUserId = (System.Guid)Membership.GetUser().ProviderUserKey; Now the first problem I encounter is that when I run the page, the compiler complains and says, "error CS0118: 'System.Data.Common.DbCommand.Parameters' is a 'property' but is used like a 'method'." The second problem is when I insert the line: SqlDataSource5.SelectParameters("Leader").DefaultValue = loggedInUserId; in page_Load. The compiler again says, "error CS0118: 'System.Data.Common.DbCommand.Parameters' is a 'property' but is used like a 'method'." I've spent a long time trying to figure it out, but could not solve it. I would appreciate it if someone can help me out. Thank you very much.
View Replies !
View Related
Show/Hide Report Parameters Based On Selected Values In Different Parameter
Hi All, I have requirement where first I need to show only one report parameter. Based on user selection I need to prompt or show the user another report parameter. Say suppose I have 3 parameters. User selects first value in first parameter I should not show the other 2 parameters. If user selects second value in first parameter I should show second parameter and hide third parameter. There is no relationship between these 2 parameters except user selection. Similarly if user third value in first parameter then I should show third parameter and hide second parameter. Is this possible? I can not see any Visible property for report parameters. If yes, how to achieve this functionality? Appreciate your help. Regards, Raghu
View Replies !
View Related
Programatically Show/hide Group Headers/footers In Reports
I have a report that has three levels of grouping including headers (containing titles) and footers (containing summary values). I would like to programatically show/hide these header/footer sections based on a Show/Hide paramter. Is that possible? Currently I work around the problem by just having two physical reports (one with the header/footers, one without)
View Replies !
View Related
Showing Data Based On The User Logged In.
Assume I have a heirarchy like the following: - John Smith - James Jones - Robert Allen - Lisa Andrews - Bob Thompson Now, I have a report where whoever is logged in will only see data for themselves and those below them, so John Smith would see everyone including himself, but Lisa Andres would only see herself and Bob Thompson. James Jones would be able to see everyone except John Smith. How do I go about implementing this code, for example in an asp.net page where one of the user's logs on to view the report. Currently, there is a T-SQL function that creates a user heirarchy table, but it is very slow and I am curious if SSRS 2005 has any new capabilities in handling this. Thanks, Saied
View Replies !
View Related
Help With Trying To Insert The UserName Of The Logged In User Into The DB Field UserID
How do I insert the UserName of the Logged in user into the DB field UserID. I created a web form page, and added a form view control set the page default to Insert Mode. The Page is used to insert data. I have a hidden field called UserID that I would like to capture the Logged in user. I have logged in to the default page with userID and password, added a new record, and the db table field UserID is empty. I have been trying to figure out what I am doing worng, but no luck, Please suggest the best way to do this. I have listed what I have done thus far? I have added the login Control from Login and added it to the page as a hidden field thinking that I needed to have this field on the page to get this to work where you copy the value in the Loginname field to the useridTextbox on the formview1 insert template. I read on line where the method below is better. Please tell me what I am doint wrong. System.aspx---------------------------------------------------------------------------------------------------------------1) <asp:FormView ID="FormView1" runat="server" AllowPaging="True" DataKeyNames="SystemID" DataSourceID="SystemSqlDataSource1" DefaultMode="Insert" Width="583px">2) <asp:TextBox ID="UserIDTextBox" runat="server" Text='<%# Bind("UserID") %>' Visible="False"></asp:TextBox><br />3) <asp:SqlDataSource ID="SystemSqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RCMISConnectionString %>" DeleteCommand="DELETE FROM [tblSystem] WHERE [SystemID] = @SystemID" InsertCommand="INSERT INTO [tblSystem] ([SystemID], [SystemDesc], [Inactive], [TimeStampEntry], [TimeStampUpdate], [UserID]) VALUES (@SystemID, @SystemDesc, @Inactive, GETDATE(), @TimeStampUpdate, @UserID)"4) <InsertParameters> <asp:Parameter Name="SystemID" Type="String" /> <asp:Parameter Name="SystemDesc" Type="String" /> <asp:Parameter Name="Inactive" Type="Boolean" /> <asp:Parameter Name="TimeStampEntry" Type="DateTime" /> <asp:Parameter Name="TimeStampUpdate" Type="DateTime" /> <asp:Parameter Name="UserID" Type="String" /> </InsertParameters> </asp:SqlDataSource>System.aspx.vb---------------------------------------------------------------------------------------------------------5) Partial Class MemberPages_RCM_frmSystem Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'UserIDTextBox.Text = Membership.GetUser().ProviderUserKey.ToString() End Sub Protected Sub FormView1_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) Handles FormView1.ItemInserted 'Set the UserID Value to the currently logged on user's ID e.Values("UserID") = Membership.GetUser().ProviderUserKey End SubEnd ClassThank you in advance,
View Replies !
View Related
Hide Field From User
I have an app that connects to sqlepress. When run the field are loaded from the db. There are some fields that I don't want some of the users to see. Is there a way to do this without hardcoding the 'username' in the applicaton ? I looked at the explicit permissions for username for the particular table, but I don't understand some of the terms listed. Alter Control References View definition
View Replies !
View Related
How To Show Partial Report Based On User
Hi, I am new to SSRS. Is there a way to show part of a report based on User. Say we have a report consisting data for all department. When a department director view it, the report only display data for his/her department. Can this be achieved in SSRS? Thank you in advance for your help.
View Replies !
View Related
How To Show ChartFX Reports In ReportServer And How To Show Tooltips For Reports Using Chart Properties
Hi all, I have two problems. 1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this. 2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'. Thanks, Mahesh Manthena
View Replies !
View Related
How To Design Dynamic Reports Based On User's Choice
Hi all, I'm a beginner to Report Services, and have tons of questions. Here's the first one: if the reports are created based on the condition that the user selects, how can I create the reports with Report Services? For example, the user can select the fields that will be shown on the reports, as well as the group fields, the sort fields and restrict fields. So I would not be able to pre-create all possible reports and deploy them to the report server, and I think I should create the reports dynamicly based on what the user select. Could someone tell me how to do it (create and deploy the reports)? Thanks a million! Jonee
View Replies !
View Related
Query To Show Only Users Who Logged On In Past 6 M
Hi All I have built this query : Select position, SubsidiaryName from position Where SubsidiaryName in ('country1','country2') and position not like('testuser_%') and position not like ('Inactive_%') and position not like('olduser_%'); However when I run it, the result more accounts in country 1 than expected. I think it could be inactive users who have not logged into this system for 6 months or more. How can I build a query that incorporates my original query + shows only users who logged into the past 6 months ?
View Replies !
View Related
Insert Adjusted Datetime Into Sql Field Based On User Locale
Is there a way to adjust a date and time depending on the users locale before inserting into the database? Users login in and their country of residence is stored in the database on signup. My server is in the US and I want to reset part of the users db record when it's the end of the day in their country so I need to enter the date and time into the db plus or minus the time difference, is there a function written to do this already or would i need to write my own?
View Replies !
View Related
Show/hide Report Columns
Hello, I'm currently investigating whether SQL Reporting Services might be the right solution to some reporting requirements I have been given (web reports). There is a requirement that some of the columns are hidden to begin with and can be shown by clicking on the header of one of the other columns. E.g. There is a list of clients and a "Total Revenue" column, clicking on the "Total Revenue" column header would show an additional 5 or so columns which show a breakdown of different figures that make up the total revenue. So my question is this: Is it possible to show/hide columns by clicking on the headers of other columns in the report? Thanks, Lachlan
View Replies !
View Related
Hide And Show Parameters In SSRS
I am doing report development against OLAP. I have Parameter1 and then my second parameter is a boolean (True/False). I want to show Parameter 3/Paramater 4 based on selection of Param2 (So, if true, show Param3, if false, show Param 4) and please remember we are doing this in a sequence. Is this even possible in SSRS 2005? If yes, how the hell do I achieve it. PS: Sorry for cursing, but I am about to lose my mind. Any help is much much appreciated.
View Replies !
View Related
Show (or Hide) Only 1 Subtotal Column Ssrs 2k
Hi, I have a simple SSRS 2k Matrix report that has the following format: SomeCampaign1 SomeCampaign2 ....... Reward Points | Next Level Reward Points | Next Level EmpName1 5 10 1 2 EmpName2 1 5 2 5 ......... I basically want a single Grand total column at the end of the report making the report look like this: SomeCampaign1 SomeCampaign2 Reward Points | Next Level Reward Points | Next Level Total Points EmpName1 5 10 1 2 6 EmpName2 1 5 2 5 3 I have these groups set up: Rows: EmpName Columns: FakeColumnGroup CampaignName [Static Group] The rewardspoints and nextlevel are the details i am showing. I created the FakeColumn group above the Campaign group as I read somewhere on the web that you needed to use this and then use InScope function to set the totals column??. I havent really got this to work. All i seem to get is a Reward Point AND Next Level totals columns when i only want the Reward Point total. I created a subtotal against the FakeColumnGroup Has anybody got suggestions on how I simply hide the Next Level column or simply display a sinlge total column? What I've found so far doesnt go into enough depth. Thanks in advance, Peds
View Replies !
View Related
Show/Hide Extra Column Without Running Report Again
Hi all, Is it possible to show or hide columns in a report on the fly, i.e. without having to run the report again? I have a report in with a parameter to let the user choose between the data to show. However the customer doesn't like it that he has to rerun the report. Any help would be appreciated! Regards, Henk
View Replies !
View Related
Hide Calculated Column In Matrix Report And Show Only In Total
Hi All, I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using InScope, as it creates *Blank column. Please go thru details below. Year Month01 02 03 Total Salary Salary Salary Salary Cumulative (Calc) Employee01 20 5 25 25 Employee02 10 10 20 45 ..... Total How can i achieve this?. Any suggestion on this would be appreciated. Thanks,
View Replies !
View Related
Is User Logged-on?
Dear GroupI wondered whether there's a function or script that will show mewhether a user is currently logged-on to a MSSQL 2000 database? I'musing SQL Authentication.Thanks very much for your help & efforts!Have a nice day!Martin
View Replies !
View Related
How Can I Hide A Table Column Based On A Group ?
I am using Reporting Services 2000. If you find out that Reporting Services 2005 would resolve this issue, please lemme know also. But I want to mention that I would prefer a way to fix this without changing Reporting Services versions. I have a table that has a group on ProductTypes. This group is set to PageBreak at end. What I need to do is to conditionally hide an entire column based on the current group's ProductType. Examples Page 1 = Product 1 = Column 1 is visible Page 1 = Product 1 = Column 2 is visible Page 2 = Product 2 = Column 1 is hidden Page 2 = Product 2 = Column 1 is visible Can you help me figure this one out ? I've tried everything I found on the net, especially everything on this page : http://blogs.msdn.com/chrishays/rss.xml Thank you in advance.
View Replies !
View Related
Adp Crashes When Logged On As User Other Than 'sa'
I have an adp front end to sql7 back end. There are a number of problems when I log on as a user other than 'sa'. For example, one user, who has select, delete, etc. rights to nearly all the tables, can perform a number of functions (add, update, etc.) and then Access will suddenly crash ("invalid page fault...." in one or another dll.) Sometimes this will happen very soon (after one or two operations) and sometimes it will go fine for a dozen or so. I have not yet crashed the system as 'sa'. Also, the back end has a number of sprocs that serve as record sources for forms, combo boxes, etc. These will not show up in the database screen at all -- the sproc tab will be completely empty. Forms and combos that run on sprocs will run normally, however reports will not (for this user). I am not sure it is relevant, but on the permissions tab in enterprise manager, I did not check the "DRI" box for any of the objects for this user. Simply because I wasn't sure what it meant, and couldn't find anything on it in my books or in BOL. Any help is greatly appreciated. TIA. D. Lewis
View Replies !
View Related
User Logged In Too Long
I need to be able to check how long a user has been logged in and boot them if they have been logged in too long. The problem I am having is that they log in through terminal server or using a PeopleSoft application. Thus, we have application servers that need to be up and running and not boot them. Any suggestions? Thanks
View Replies !
View Related
How To Find Out The Logged In User
Hi, I wanted to know How can i find out that with which user i am logged in. Is there any command to find out the same. ( like in oracle, we have command -- showuser, which will return the logged in user of your session). Thanks in advance. -- Chetan
View Replies !
View Related
Way To Hide Subreports Based On Item Existing In A Data Set.
My current report has around 40 subreports corresponding to tests executed by the user. There is a different sub report for each of the tests executed. I first developed the report by just putting the subreports directly on the main report. The problem is if some of my tests are not executed by the user I would like the subreports to not appear in the report. I have tried doing this two different ways. First I tried creating a table and attaching that table to a dataset that I created that returns all the tests that were executed by the user. I then set up a filter that specified that the name for a specific subreport had to equal the test name. I then dropped the sub report for that particular test into the table. The idea is there would only be one row when data is available and no rows when no data is available so the subreport would not appear. When the data is available the subreport appears great. When it is not available and there is no item in the dataset for that test I get an error from SQL that states there was an internal reporting error and to check the SQL server log for more information. I know my table is set up correctly because when I replace the subreport with text the text will appear only if data is available for that test and the text does not appear if no data is available. I get no errors until I add the subreport and remove the data from the database so the filter does not return any items. Is there a reason why I would be getting this error? I am still pretty green using reporting services so I do not even understand how to get the log from the server to determine why this error is occuring. Secondly I have tried to use an expression to hide the subreport using the visibility tab for the report. I was able to get this to work by creating a dataset that returns 1 if a specific test has been executed and no rows if not. I then created an expression that would return true if the dataset returned 1. This worked okay in hiding my subreport but I would then have to create 40 datasets, one for each test. Is there anyway to write an expression that would return true if a dataset contained a row with a specific test name? I have not been able to figure this out. Can someone either help me fix the problem I am having with the table approach or write an expression that would work in the visibility setting for each sub report that did not require 40 datasets? Or is there another approach that I am not even thinking of that might work? Thanks so much, Josh
View Replies !
View Related
Hide Fields Based On Users AD Member Ship
If I wanted to make a report that shows different fields, one being cost, but I only wanted certain people to see cost based on their AD groups, is there a way to hide this information? Basically, domain/user1 belongs to AD purchasing group purchasing, he can see item, description and cost, where domain/user2 belongs to sales so he can only see item and description?
View Replies !
View Related
Get The Currently Logged In User's SQL Role In A Different Database
NOTE: I am talking about roles in my sql server - NOT in asp.net. I need to create a stored procedure that retrieves the roles that the currently logged in sql user has for a different database. I have the code that gets the roles for the user, but it only works if the user is in the database. I want to be in one database, and get the roles for a different database. I have tried using USE DATABASE, but this is not allowed in a store procedure.
View Replies !
View Related
Select Latest Logged In User
Hi! I would like to select the 10 latest logged in users and then display them in a gridview-control.... But Iam not good at SQL, so I would really appreciate if someone could help me to write the select-part for this!! (I use the database 'ASPNETDB.mdf', which is automatically created by VVD 2005 Express Edition)
View Replies !
View Related
How Do I Refer To The User Logged On To The Database?
How do I refer to the user logged on to the database? I can refer to a table as dbo.tblApptDaily, but how do I refer to [current user].tblApptDaily? Create Procedure "prcCreateApptDaily" as Create dbo.tblApptDaily (ID int primary key, ApptTime datetime, book1 numeric, book_Status1numeric default (0), PN1 varchar (50), ApptID1 int,...LastID int)
View Replies !
View Related
How To Hide URL When Display Reports In Reporting Services
Hi , How can I hide the URL information when I open a report, some with parameters and some do not have parameters. Is there anyway or properties in RS that I can set to have it hide all the important information, like datasource, credentials, parameters, and display the report like a aspx page instead? Or does this need to have special programming to make this happen? and if so, what do I need to do? thanks very much
View Replies !
View Related
Select Records For The Current Logged On User
Hi all I've been having a really difficult time finding out how to run a query which selects records from an SQL database for the current logged on user. I've tried a whole manner of different approaches but here is where I am at now: <script runat="server"> Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) If Not Page.IsPostBack Then ds_meobservingcolleagues.SelectParameters(0).DefaultValue = User.Identity.Name End If End Sub </script> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ds_meobservingcolleagues"> </asp:GridView> <asp:SqlDataSource ID="ds_meobservingcolleagues" runat="server" ConnectionString="<%$ ConnectionStrings:StPaulsDatabase %>" SelectCommand="SELECT [observeTeacher], [observeBy], [observeReason] FROM [Observations] WHERE ([observeBy] = @observeBy)"> <SelectParameters> <asp:Parameter Name="observeBy" Type="String" /> </SelectParameters> </asp:SqlDataSource> This is not resulting in any error. But it is not returning the records that it should be either. Please can anyone help? I'm sure it shouldn't be this difficult to do
View Replies !
View Related
Is There A Way To Show A User-friendly Error When User Did Not Select A Required Parameter ?
Hi all, I was wondering whether there is a way to show the user an error when the user did not select a specific parameter. In my case, I have two optional parameters. The user has to select either one to view the report. If the user does not select either one, I would like to show some sort of an error page indicating so. However, all i am getting is a complete blank with no report in sight. I as a developer know this is an error as a result of missing parameters, but i was wondering whether I could produce a page or direct it to a page so that the user doesn't go all horrified at an empty page ? Thanks Bernard
View Replies !
View Related
Show User Groups Associated With User ID Report From Active Directory
Hello. I am trying to write a report that pulls information in from Active Directory. I have a view created that gets a listing of users and a view that creates a listing of user groups, but I can't seem to figure out how to get all user groups that are associated with the users. This is what I have. SELECT TOP 100 PERCENT * FROM OPENQUERY(ADSI, 'SELECT cn, groupMembershipSAM FROM ''LDAP://wmdomain.local'' WHERE objectcategory=''group''') Rowset_1 SELECT * FROM OPENQUERY(ADSI, 'SELECT title, displayName, sAMAccountName, givenName, telephoneNumber, facsimileTelephoneNumber, sn FROM ''LDAP://wmdomain.local'' WHERE objectCategory = ''Person'' AND objectClass = ''user''') Rowset_1 Let me know if you have any suggestions! BJ
View Replies !
View Related
How To Show Duplicates In Reports
I'm trying to create a report in Sql Server 2005 Reporting Services where it will display duplicates rows in the reports. I'm unable to find the property that enables this. I would need something like HideDuplicates = false, but that is not the way it is intended to be used. If HideDuplicates is left blank, it seems to still hide duplicate values if the preceding row matches. The report is a crosstab type, so we are using a Matrix for the report item. I'll illustrate with a simple example: This is what we currently get: Catagory Class Detail Type 1 A Item 1 B Item 2 Item 3 Type 2 A Item 4 B Item 5 This is what we want: Catagory Class Detail Type 1 A Item 1 Type 1 B Item 2 Type 1 B Item 3 Type 2 A Item 4 Type 2 B Item 5 I'm sure its something simple, but we just cant seem to find the solution, Thanks Darin
View Replies !
View Related
Want To Hide The Time From The Date Field In GridView In ASP.Net With SQL
I m using ASP.NET 2005 with VB,C#. I m using GridView to display the data. My problem is with the database field date. I want to use only the date and the fields are manufacturing date and expiry date of some items. But,in the gridview it displays the time which is by default same for all the entries which 12:00A.M. I have used date picker for designing. What should be the validation for showing only the date and not the time ?? How to hide the time from the gridview. I m using SQL Server 2005 to store database where i have selected the datatype as date/time.
View Replies !
View Related
Show Data In A Txtbox Based On A Key Passed From The 1st Page
On my Home page I have a gridview that has Four columns: CustomerID, Product, Quantity, then a link (which appears on each row..called View). When a user clicks View on a particular row it will then send that particular CustomerID to the next page (CustomerProfile.aspx). On the CustomerProfile.aspx page I have a textbox where the Customer Name should appear. How do I go about displaying the customer name in the textbox based on the CustomerID passed to the customerprofile.aspx page? Do I need to call a stored procedure? Do i need to call the Customer Table in my code? (i'm using C#) Thanks!! Ur help is very much appreciated! Side Note: i am passing the CustomerID by a SESSION variable called customerID ~~~>this is in my pageLoad method labelCustomerID.Text = Session["customerID"].ToString(); but i'm wanting to have the Customer Name in a textbox based on the above ^^^ session variable. My textbox is called txtCustomerName.Text *** Customer Table***CustomerIDCustomerNameCustomerAddress ^^^wanting to call the customer name and put it in the customer name text box based on the particular customerID
View Replies !
View Related
Show More Than Two Reports In Report Viewer
Hello Reporting Gurus: I am viewing 3 reports on one report viewer every report has different size .it is showing all right on printer but one report displays two report pages on report viewer from 2nd page.i am adjusting the report sizes on selection of reports. Select Case str_CallReportOption Case "PrivacyLegislation" ''Calling Privacy Legislation Report Me.rptClientCompliance.Width = New Unit(21.5, UnitType.Cm) Me.rptClientCompliance.Height = New Unit(29, UnitType.Cm) rptClientCompliance.ServerReport.ReportPath = "/WinfundReport/PrivacyLeg" Case "Person" ''Calling Persons Only Report Me.rptClientCompliance.Width = New Unit(21.5, UnitType.Cm) Me.rptClientCompliance.Height = New Unit(57, UnitType.Cm) rptClientCompliance.ServerReport.ReportPath = "/WinfundReport/KYC_Person" Case "Company" ''Calling Companies Only Report Me.rptClientCompliance.Width = New Unit(21.5, UnitType.Cm) Me.rptClientCompliance.Height = New Unit(57, UnitType.Cm) rptClientCompliance.ServerReport.ReportPath = "/WinfundReport/KYC_Company" End Select I apreciate ur respone. Ramzan
View Replies !
View Related
|
TRACKER
