Passing Current User Credentials From IIS Server To Reporting Services Sever?
Aug 8, 2011
Question: How to pass the current user on the web page from the IIS server to the Reporting Services Server.I have seen this topic throughout the forums. However, the answers are always hard code the user in web.config - use a login window and pass those fields to the IReportServercredentials or create one user for everyone.
When the person who asks the question comes back and says that doesn't work there is not answer.Does anyone know how to do this? I have VS 2008 ( and 2010 ) I am sending the info to SSRS 2005 server.As anyone using SSRS knows that if the reports have parameters and udf behind the report to inspect who the user is, then you have to pass that user to the report.
[Code]...
I have been programming steady with vb.net for a year now and was all happy about using the List view and email etc from web sites. I even used a reportviewer to pdf to email attach, cool. Now I feel quite lost and realize I have not been using properties, etc. That is my background.
View 7 Replies
ADVERTISEMENT
Mar 29, 2009
Is there a way to obtain the current user credentials that are being used for VPN access? [code]
View 1 Replies
Jul 25, 2011
I've set up an application that runs as a service, auth'd as LocalSystem. One of it's functions is to establish the logged in windows user's username.All I'm getting with the following is either the SID or username of the user (localsystem) running the service.
my.user.name
WindowsIdentity.GetCurrent().Name
WindowsIdentity.GetCurrent().User
[code].....
View 1 Replies
Mar 28, 2012
We are planning on creating reports to be run on the same computer that the database application is running on. which of these is the best approach? (SQL Server Reporting Services or creating a rdlc ReportViewer report) Also I tried to locate detailed rdlc ReportViewer report tutorials both in books and online and found none. It's probably because I'm looking in the wrong places.
View 1 Replies
Jul 27, 2011
I need to valid the user credentials connecting to server using TCP communication. How to conver the following code compatible to VB.NET 2003.[code]
View 2 Replies
Oct 9, 2011
I want to make a button like this:The first image is a normal button, but the second is a button with mouseEnter event fired. The bottom part of the button in the second image is not clickable and it acts like a tool tip. How can I make this kind of a button? Do I need to use a tool tip? Please give me some code examples.
EDIT:Here's F Ruffel's code which I modified:
[code]...
Now the last problem is: the expanded part pushes all controls down, and that's what I don't want. Please modify this code to make the extended part overlay controls that are below it, just like in the image.
View 4 Replies
Oct 7, 2010
My project uses .NET remoting. The client connects to the server hosted in IIS to do database operations.
We have a class library that is referenced both by the client and the server. This contains basic static (shared) functions used throughout the project. An example would be a function that takes a customer/invoice number and pads it with zeros/spaces to our desired format. This works fine. There is a copy of the dll with the client and on the server in the IIS virtual directory. Both the server and the client can call these functions and they work correctly.
Now, in that same class library, I've defined two things: an enumeration (enum) and a serializable class. If I try to call a function on the server from the client that passes/returns an instance of either the enumeration or the class, I get the following
[Code]...
View 2 Replies
Jun 29, 2010
I'm writing a program which assists users update passwords for our windows systems and some other applications. Everything is working except when I call the UserPrincipal.Current.ChangePassword command cached credentials are not updated like they are when you change a password using the windows OS password change.
That is: when a remote user who is VPN'd in uses my application to change passwords, when they reboot and VPN is disconnected, they are forced to login to windows using there old password.
Is there a way I can force windows to update the cached credentials to the new password so upon reboot they are able to login using this new password?
View 1 Replies
Aug 3, 2009
How to get userID of current user logged in from server using asp.net vb?
View 2 Replies
Oct 22, 2009
My company got a new server, with a new sever share name, etc. I also moved my project from 'My Documents' to the C: Drive. I went through all my code and replaced the old path info to the new path. Tried to publish and received errors stating my temporary key was no longer valid. I googled that error and tried a solution. I created a test certificate and the app published as expected.
View 2 Replies
Mar 17, 2009
I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?
Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True
View 3 Replies
May 23, 2010
I have an application that has a part of it that modifies several windows services. When the form loads it checks the registry for the current status of the services.
What I would like to do is have it so that the application takes a snapshot of all the defined services when it is first installed and stores the defined settings for each of them. This way the services can be restored at a later time to there original settines. I would also like to make it so that a custom settings file can be created so that this custom configuration could be loaded which contains changes. The result would be the first file made would allow everything to be reset prior to any changes the second file would contain all the setting changes.
View 20 Replies
Sep 25, 2009
Can these two things work together? That is VB.Net Standard NOT VB.net 2005 or vb.net 2008 or any other year. If not is there an inexpensive solution for reporting in VB.Net Standard and SQL server?
View 1 Replies
Oct 29, 2009
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 Replies
Aug 4, 2011
im decide to develop Vb .net Application With Sql server Express 2008 ,but microsoft says they limit 4 GB Sze for per DB! So im developing my app for Single user Desktop pc , so what i do when the DB reached to the Maximum size? when the db size reached to maximum size , is it Good thing to create new DB and allow my vb.net application to work with both DB s ?
View 4 Replies
Jun 10, 2012
I want to download my update files for my program from an FTP server, but i need to login first with the credentials. I have tried many things, used some examples on MSDN, googled a lot, but i can't find the code that i'm looking for... I also use a DLL of someone that i've imported into my project. I don't know if that harms my part of being unable to log in.
I have ZERO experience with FTP servers or Network Credentials, i've learned the little things about it on google.
[Code]...
View 4 Replies
Jul 21, 2009
We have a VB.NET (aspx) website with a login first page. Once the user has logged in and is authenticated they are taken to a single page with a Menu Bar at the top and a report viewer control underneath. When the user has logged in the report viewer is initially populated by a dynamic menu (a menu of links to other reports depending on each user's permission).
Now, on some reports that the user access from the main menu, they like to export the data. The nicely formatted reports export nicely to PDF but these same reports look awful when you export to excel. Further more what is required from the excel version is no formatting and also to include extra columns of data that are available form the dataset but not from the rendered report (for use with importing these expoerts into other systems).
Is it possible to extract the data that is generated from the dataset that renders the report?What I would like to do is obtain this data and create my own excel export option (of which I will put into the page Menu bar at the top of the screen). It is important to just grab the data that is generated because different data is available depending on the parameters the user has chosen.
View 2 Replies
May 31, 2011
I have the following code:
public sub PrettyRows()
dim ds as dataset = report.dataset1
dim GroupName as string = ""
[Code]....
The Protected Overrides Sub OnInit() is comparable to the load event in VB.NET.
I am utilizing this event to call my custom sub PrettyRows. This sub will iterate the rows in my dataset and change the first column in each row so that an entry only appears once, This is being utilized to identify what group the row belongs to. The rows are sorted by group and I only wish to display the group name once and I am removing all other references to the group name.
View 1 Replies
Nov 30, 2009
We are trying to add SQL Reporting Services to a .Net 2.0 Web Application. SRS has been installed on the server successfully, but we get an error when we try to load a report or access the report manager:
Server Error in '/Reports' Application.Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Could not load file or assembly 'netGmrc' or one of its dependencies. The system cannot find the file specified.
The error is being coming from a line in the web.config where an httpHandler called Upload.axc is being added to the web application. The entire httpHandler section is listed below.
<httpHandlers>
<add verb="*" path="Upload.axd" type="netGmrc.Upload, netGmrc"/>
<remove verb="*" path="*.asmx"/>
[code]....
When we remove the Upload.axd handler from Web.Config, everything in SRS works fine. What is the proper way to have Reporting Services work along side the web application with this httphandler?
View 1 Replies
Aug 20, 2010
Web service uses SQL Server based authentication how to change to windows based authentication both web server & Database service resides in different domain .
View 1 Replies
Oct 21, 2009
I'm using Reporting Services 2005 to produce a one-time report that will group records according to the PLANCODE field. I've created the following VB function:
[Code]...
How do I reference the above function in a new calculated field so that the report will group data based on the results of this function? The doucmentation states that the expression should be something like =code.PayorGroup. However, when I try this expression in the Calculated Field window, I get the infamous red squiggly line stating Unrecognized Idnetifier.
View 1 Replies
Aug 30, 2009
What is the best way to launch reporting services reports from .Net code? One method would be to dynamically build a URL and launch a browser. Something like this:
http://server/ReportServer/Pages/ReportViewer.aspx?%2fReport+Directory%2fReport%20Name&FirstParameter=1,2,3&SecondParameter=8/30/2009&rs%3aCommand=Render
[code].....
View 3 Replies
Apr 1, 2010
Does Visual Basic 2010 have any reporting services, ie, Microsoft Report viewer?
View 6 Replies
Jul 14, 2010
I have a report parameter which looks like this: 01.01.2009 00:00:00.Its a date (as string), as you might have guessed :). The problem is, this param can be an empty string as well. So I tried those expressions:
=IIf(IsDate(Parameters!DateTo.Value), CDate(Parameters!DateTo.Value), "")
=IIf(Len(Parameters!DateTo.Value) > 0, CDate(Parameters!DateTo.Value), "")
Both dont work and the value for the textfield where I print the expressions result is always #Error. As soon as I remove the CDate stuff, it works, but I have to use it. IS there another way to achieve that? What I want is to display nothing if its not a date or the date (format dd.mm.yyyy) if its a date.
View 2 Replies
Dec 5, 2011
I have a function in SSRS using VB.NET as follows: Public Function GenerateCSV(byval str as string, byval str1 as string, byval str2 as string, byval GrpName as string)
[Code]...
This works great is str, str1 and str2 have a value and only one value. But I want to make it so if the value isn't there or there is only one value there is no comma and if there are multiple commas there is a comma.
View 1 Replies
Mar 24, 2010
I use VB in Visual Studio 2008 Pro. I've created a few solutions using the Crystal Reports tools. I found them easy to work with & easy to do things, (export to different formats, refresh reports, write an automated service that ran & saved reports, etc...)Is CR in VB 2010? If so - which version of VS 2010 do you need to buy to get it?OR - is the reporting services in VS a suitable replacement? Is there a viewer / preview like the CR tools? Can you create a standalone app to refresh reports & export them to different formats? Which version of VS 2010 would I need to purchase to get these?At home - I use Win 7 media centre (a fantastic piece of software). Are there any development 'goodies' in Visual Basic 2010 for Win 7 Media Centre?
View 2 Replies
Nov 11, 2009
I am trying to build a report using MS reporting services (rdlc file) and having trouble figuring out syntax to take calculated data from a textbox in table1 to table2. In other words, I have totals calculated in table1 and I need to display those totals in another table (table2) and/or a text box outside of table1.
I have tried versions of =ReportItems!TextBox37.Text and =ReportItems!TextBox37.Value and =ReportItems("TextBox37").value etc. but with no luck. The last thing =ReportItems("TextBox37").value does compile but it prints #error on the report.
View 3 Replies
Nov 21, 2011
In VB.Net, I'm trying to connect to WMI on my local computer with different credentials (the user won't have admin rights) and I get this exception : « User credentials cannot be used for local connections » Here's the code :
[Code]...
View 1 Replies
Nov 1, 2011
We don't want to get the password, we only want to store the user credentials so when they do work on the application we can apply their usernameto each operation and when they are done with an operation and do a digital signature by scanning their badge we want to compare the user's credentials with the stored credentials to ensure the user has logged in and is the current user.1. User 1 logs into the program using their username/password for windows.5
View 1 Replies
Sep 12, 2010
I have a client/server application running in a windows domain environment, the client application is started at log on by a scheduled task using domain admin credentials, i need to be able retrieve the username of the user who logged onto the workstation but all the methods i have tried returns the user that was used to execute the program.I have tried:
Environment.UserName
System.Security.Principal.WindowsIdentity.GetCurrent().Name
Environment.GetEnvironmentVariable("USERNAME")
All of these return the account i used to run the application, not the user who is logged on.
View 5 Replies
