CRM Reports No Longer Able To Filter On User!UserID

Jan 8, 2008



Hello,

I have some reports running CRM data. It's basically a sales dashboard that shows each user their pipeline values. Since each user has rights to see more than just the opportunities they own, I had a filter on the report in the SQL WHERE clause. It said

WHERE
@UserID = systemuser.DomainName.

The @UserID parameter's value was

=User!UserID, which brought back the logged-in user's domain name, which matched the field in my WHERE clause.

Now, in CRM 4.0, to eliminate the need for a VPN to access reports, everyone who accesses a report is logged in as NT Authority Network Service. Does anyone know if there's still a way to access the person's domain identity?

Thanks,

Andy

View 3 Replies


ADVERTISEMENT

Asking Userid And Password While Deploying Reports

May 15, 2007

Hi All,



While deploying reports on the reports server, it is asking to supply user name and password. When I entered the same, it didn't accept them. What do I need to do? Is there any specific setting which I need to configure?



An immediate reply will be highly appreciated.





Thanks

Sekhar

View 6 Replies View Related

Can You Mirror A User To Another Userid?

Jan 24, 2006

I have a user which has the currect rights to do what he needs but others with the same permissions (from what I can tell) can not do somethings. It looks like I have 2 options

a.) find a way to mirror the working one to 30 others ids
or
b.) find some tool that will do a detailed comparision of the two ids

Any suggestions/tools(free)/scripts that would work?

Thanks

View 1 Replies View Related

Getting UserName Or UserID In Database When Using ASP.NET User Management

Mar 25, 2008

Hi I am using ASP.Net user management tool. How can I get the user name of the current user who does some activity to log those details using triggers.Any web link/tool/suggestion is welcomed.

View 13 Replies View Related

Help With Trying To Insert The UserName Of The Logged In User Into The DB Field UserID

Feb 11, 2008

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 7 Replies View Related

How To Deal With User!UserID In Data-Driven Subscriptions

Jul 27, 2006

First a bit of background.

We use the Windows-logon to authenticate en identify the user. With this logon we check within most of our reports what a user is allowed to see.

Depending his level or geographical location he is allowed to run reports on one to all sites. He can selects the sites from a Multiple Select box. This works fine.

Now, we want to use data-driven subscriptions, I understand why we can't use this parameter, but how do you people deal with this kind of configurations.

I would prefer not to 'double' the reports in a normal and a subsciption version .....

View 9 Replies View Related

Matrix Reports Filter

Sep 11, 2007

I am trying to have a matrix report filter on records that had sales in a prior month but no sales in the current month. Basically looking for accounts we €ślost€?

For example:

Name Invoice Date Quantity
Joe 4/1/2007 7
John 5/1/2007 13
John 4/1/2007 7
Tim 6/12/2007 6

The matrix report pulls back

Name Month

April May June
Joe 7
Tim 7 13
John 6

I am trying to return only names that had quantity in May and don't in June.

I would like it only to return Tim€™s record because we lost his business in June.


Any ideas?

View 1 Replies View Related

Adding A New Record Takes Longer And Longer -- Archive? (was Table Help)

Mar 1, 2005

Hi we have a table with about 400000 records in it. It starting to take longer and longer to add a new record. I was thinking of creating another identical table and archiving off most of the records every month (we are now adding about about 4000 records a day) . Is this the best thing to do?
I don't know a lot about sql server so any help or suggestions would be great

View 4 Replies View Related

Stored Procedure With User!UserID As Parameter, As Report Parameter?

Jul 2, 2007

I had thought that this was possible but I can't seem to figure out the syntax. Essentially I have a report where one of the parameters is populated by a stored procedure.

Right now this is easily accomplished by using "exec <storedprocname>" as the query string for the report parameter. However I am not clear if it is possible to now incorporate User!UserID as parameter to the stored procedure. Is it? Thanks

View 1 Replies View Related

Restore Taking Longer And Longer

Feb 4, 2008

The following code is taking longer and longer to run. I am not talking about the gradualy increase in size. this job has been taking 30-40 mins normaly and in the last few days it has gone 1hr to 2 hr to 3 hr... ANy ideas why this is happening? I can not see and other jobs running at this time.

declare @filename varchar(255)

set @filename =
(select top 1 physical_device_name
from ****.msdb.dbo.backupset bs, ****.msdb.dbo.backupmediafamily bf
where bs.media_set_id=bf.media_set_id
and database_name = 'Live_PRD'
and backup_start_date>getdate()-1
and type = 'D'
order by backup_start_date desc)

restore database REPORTS_REP
from disk=@filename
with
move 'LIVE_PRD_Data' to 'T:SOUTHREPORTS_REP_Data.mdf',
move 'LIVE_PRD_Log' to 'U:SOUTHREPORTS_REP_Log.ldf',
move 'LIVE_PRD_Log2' to 'U:SOUTHREPORTS_REP_Log2.ldf',
replace, stats=2, recovery

View 5 Replies View Related

Using Membership UserId Guids With SqlParameters (Membership UserId Guid)

May 7, 2008

In my site, when a user registers, I need to create rows in additional tables besides aspnet_Users. So, I need to be able to pass the generated userId guid to subsequent SqlCommands. I'm having a terrible time with this. What's the correct way to set up a SqlParameter so that it will accept a guid? I keep getting this error: "Conversion failed when converting from a character string to uniqueidentifier."
I've tried creating the parameter both with and without a SqlDbType.
cmd.Parameters.AddWithValue(paramName, guid);
and
SqlParameter p = new SqlParameter(paramName);p.SqlDbType = SqlDbType.Guid;cmd.Parameters.Add(p);
and I get the same error either way.
Driving me nuts! Any help appreciated.

View 1 Replies View Related

Filter Tables According To User

Aug 29, 2006

Hi,

Im new to SQL Server and Im having trouble to decide wich is the best way to filter the tables that one user can read and write.

For example the table Sales as a field named Branch (SMALLINT) with values 1 or 2 (the store that made the sale). User "A" can see and write only records where Branch = 1.

Im developing a windows program that shows all the purchased orders in a DataGridView. So should I make the filters (permissions) in the program or in the SQL Server?.

I hope I made my self clear (my english is not so good)

View 5 Replies View Related

Filter By Page.User.Identity.Name

Jun 29, 2007

Hiy all,
I have used the code below to capture the current logged in user into my LoginID Filed in my SQL DB.
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load        SqlDataSource1.InsertParameters("LoginID").DefaultValue = Page.User.Identity.Name
 End Sub
Now that I have this in my DB I want to create a Gridview that will filter by this LoginID.
So I want to filter all records where LoginID = the currenlty logged in user ie: filter using Page.User.Identity.Name
So in my SQL code I have WHERE loginID = @Currentuser.
VWD now wants me to define a parameter for this Varaibale @Currentuser... So I want to set this to Page.User.Identity.Name.
My Problem is that in the datasource define parameter area I'm not sure what to define this as.
ie: is Page.User.Identity.Name a cookie , control , Query String , session ?
can someone point me in the right direction to what syntax to use?
Ray..

View 7 Replies View Related

Dataset Filter By The Current User

Dec 7, 2007

Is there a way to only return the data that the user is allow to see?

Example:
A student login into the Report Server and open the Class Report It will only display all the classes this student is in.

View 1 Replies View Related

SQL Sever Side Query To Filter For User ID

Apr 23, 2008

I currently have a query in an access database that filters the records in a Sql Linked table for their user ID. So basically i use Environ("UserName") to filter for a field that contains their user name. I want to secure this and put it on the SQL Server so there is no way anyone can see any records other then the ones that are filtered for them. Does anyone know how to do this? I think it will be some SQL query.

I'm still learning sql server 2005.

Thanks.

View 3 Replies View Related

Filter SqlDataSource Select Based On Membership User Name

Jul 11, 2006

I am running into an issue trying to declaratively set up a SqlDataSource.  I want to be able to filter some of my queries based on the user that is currently logged into the web site.  I want to do it Declaratively as that's one of my favorite 2.0 features.Is there any way to do this with the Membership information?  I know I can use the code behind to set the parameter, or store the User Name in Session Variable, and use a <asp:SessionParameter> but I think there should be a way to bind directly to the Membership user...Am I missing another option, or is there no built in way to do this?  Any other suggestions...Thanks

View 1 Replies View Related

Filter SQL Server Data By User With An Micmicrosoft Access Front End

Sep 20, 2006

I am in the process of migrating 40 access databases to SQL Server and still use an access front end.All of these databases are Identical in structure and purpose. The goal is to centralize all of the databases backends into one Sql server database, but the data needs to
stay seperated by each location(user). I was able to add a location feild to all of the tables to keep the data seperate. Then I imported three of the locations data for testing. I would like to know how could I filter the data on the access frontend, so that it would ask the user for their location and only allow the user to access, update, and delete that Locations data ?

View 4 Replies View Related

In A Data Model, How Do I Filter Rows Based On The Identify Of The User???

Jun 21, 2005

Good morning,

View 7 Replies View Related

Why Does It Take Longer And Longer For The Same Code To Run

Feb 22, 2008

Why does it take longer and longer for the same code to run very simply I have 8,0000,000 records I want to delete from a table . I have tried a few options

Option 1 a while loop which deletes 10,000 rows per loop starting from the earliest until it hits the cut of number I have set. THIS TOOK 5 HOURS

Option 2 created an SP which found the oldest 100,000 records then deleted them. If I run this SP manually it takes 30 €“ 60 secs. Which I thought was much better than above. So I put this SP in a while loop to run 80 odd times thinking the time it would take would be 80 mins a huge improvement.


But every time this SP is called it takes longer and longer (36,30,32,39,37,37,123,163,155,182€¦and so on(In seconds)).

All the sp is doing is as follows(8860000 is just to insure I don€™t delete to much). this sp is then called from in a while loop.


set @recnumber = (select top 1 recnumber from
(select top 100000 recnumber from TabletodeleteFROM where recnumber < 8860000
order by recnumber asc ) TabletodeleteFROM
order recnumber desc)

delete TabletodeleteFROM where recnumber < @recnumber


please help why is it taking longer and longer

View 8 Replies View Related

Personalize Reports For Each User

Aug 22, 2007

Hello Everyone,
I am trying to personalze my reports for each user, for example: Say I have a report which takes in userName as a parameter and then generates the report. Is it possible to use the same userName that the user used to login to the reporting services enviornment. This way the user don't have to enter their userName to see the report, it will be entered by default.

Thanks a lot,
-Rohit

View 5 Replies View Related

List Available Reports For A User

Feb 11, 2008



Hi there,

Don't know if anyone has done this before -and I would really be wondered if not-:
I want to show a list of available reports to a user. Since we are working with SharePoint Portal Server 2003 the webparts can't be used (need MOSS 2007 or WSS 3.0), but I really need to be able to build a dynamically generated list and show it on a sharepoint page.

My first idea is to build a report (kind of menu). I am already this far:

to get a list of reports with the active directory groups and their mapped roles:
select u.UserName, c.Path, r.RoleName

from PolicyUserRole pur

left join Users u on pur.userID=u.userID

left join Roles r on pur.roleID=r.roleID

left join Catalog c on pur.policyID=c.policyID

order by u.UserName, c.Path, r.RoleName


I managed to link active directory via LDAP - linked server.
I even managed to get a list of users and groups. Unfortunately I cannot check whether a user belongs to a group (any idea?), since all of our security (on sql server) is managed by active directory groups this really is a problem.

Or am I completely wrong and is there another way to fetch a list of reports for a user?

Any help would be great!

Thanks,
Tom

View 1 Replies View Related

A New User Cannot View Reports

Nov 28, 2007



Hi,
i have a prob;lem while using report manager.when i login As "administrator" to the report manager i can see all the folders and i can check also reports. when i create new users with some role and i login as new user i can see the specified folder and report but when i click to see the report this message appear:
" Your browser does not support scripts or has been configured not to allow scripts".
Note that these same reports i can check them when i login as administrator

i am using sql server 2005

please it's important to resolve this problem as soos as possible
thx
labiba

View 3 Replies View Related

How To Let User Open The Reports W/o Login?

Aug 17, 2007

My PC is in the domain group of SQL Server 2005 Reporting Service, so I can publish the reports. After the reports were published, I can viw the reports from ASP.NET application on the web server, but everyone else was prompted for login. Only my login can view the reports. What can I do to let others to open the reports with the same web application? Thanks.

DanYeung

View 1 Replies View Related

User Can Not Access Reports From BIDS

Jan 22, 2008

Up to this point only two of use, both server administrators, have developed reports. Now we need to add two new report analysts to be able to develop reports in BIDS but limit their access to other server folders, etc. Our report source code is located at G:Visual Studio 2005 Source CodeProjects and all report folders, sln files, etc. are located under the Projects sub-folder. I have shared the Projects sub-folder and given read & execute / list folder contents / read / write / modify rights. They can see the report folders and sln files via BIDS or Explorer but get "access denied" when they attempt to execute one of them. Any thoughts on what I may be missing?

View 1 Replies View Related

SSRS:User Defined Reports

Oct 12, 2007

Hi Experts,

I'm using SSR5 2005. I have a set of Cubes. Any idea as how to created customized reports using SSRS. The end user should be able to create reports by himself. Please help or send me some links where I can get help in this regard.

Thanks & Regards,
Naveen J V

View 4 Replies View Related

How Do You Limit The Data That A Certain User Can See When Viewing Reports?

Jan 29, 2008

Hi

I'm new to SQL Reporting Services and I've been asked to create an online environment for a client where their customers can log on and view a report. The client wants to make sure that each customer can only see data that is relevant to them, and that other customer's information is hidden from whoever is logged on.

Can this be done through a username/password setup or is the solution more complex?

Thanks very much!

View 5 Replies View Related

How To Let User Open The Reports Without Prompting Login?

Aug 17, 2007

My PC is in the domain group of SQL Server 2005 Reporting Service, so I can publish the reports. After the reports were published, I can viw the reports from ASP.NET application on the web server, but everyone else was prompted for login. Only my login can view the reports. What can I do to let others to open the reports with the same web application? Thanks.

DanYeung

View 12 Replies View Related

Adding A User Defined Date Range To My Reports?

Oct 6, 2005

This is a pretty simple query that tracks 'yesterdays' apply clicks on our website.



SELECT MIN(A.hitDate) AS minDate, D.AffiliateName, B.ProdType, COUNT(DISTINCT A.ipAddress) AS TOTAL
FROM ArchiveApplyTracking A LEFT OUTER JOIN
Configuration.dbo.Affiliates D ON A.affiliateID = D.AffiliateID LEFT OUTER JOIN
Incoming C ON A.campaignID = C.ID LEFT OUTER JOIN
Configuration.dbo.ProductType B ON A.productTypeID = B.ProdNo
WHERE (A.hitDate >= DATEADD(d, DATEDIFF(d, 0, GETDATE() - 1), 0)) AND (A.hitDate < DATEADD(d, DATEDIFF(d, 0, GETDATE()), 0)) AND (A.deal = 1) AND
(A.ipAddress NOT IN
(SELECT ipAddress
FROM [Tracking].[dbo].ipTracking)) AND (B.ProdType NOT LIKE 'refused%') AND (D.AffiliateName LIKE 'ARROW%') AND
(B.ProdType NOT LIKE '%prequalify%')
GROUP BY D.AffiliateName, B.ProdType
ORDER BY D.AffiliateName


No problem there, that's fine.

But how can i put a simple date range interface on my published report so users can say "get me the stats from 04/09/2005 to 20/09/2005, which then runs the query?


Thanks for any help

View 1 Replies View Related

How Do You Allow Users To View Reports Without Having To Enter User/password?

May 31, 2007

Ideally, I'd like to have the reports use windows authentication, ie grab current user/password so long as user does not have to enter it manually. If that is not possible, then how do I make it so user does not have to enter this info manually? My theory is that I have IIS set up incorrectly for doing this, but I'm not familiar enough with either reporting services or IIS to find out.

View 1 Replies View Related

How To Design Dynamic Reports Based On User's Choice

Dec 13, 2006

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 1 Replies View Related

Show/hide A Field Based On The Logged In User In Reports

Apr 24, 2007

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 3 Replies View Related

Waiting For User Prompt When Running Report Builder Reports

Jan 2, 2007

I have created some reports using Report Builder however they autorun with default values when selected in report manager, cant think many people would want this to happen. Is there a way of getting rid of the default values in RB or preventing auto execute in RM?

View 1 Replies View Related

Want To Use Parameters To Filter For Dates Between Two (parameter, User-input) Dates

Mar 2, 2006

SQL 2005 Dev

How can I do this with Parameters? I can get a single parameter to filter for a single date (or even a combo list of the dates in DB). But I want my parameters to interact so that they specify a range. Is this possible?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved