Reporting Services And Web Application (with HTTPHandler)?
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
ADVERTISEMENT
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
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
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 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
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
Feb 14, 2012
We are in very critical position. In our orgnizantion our development team using Visual Studion 2010 with sp1 and they are using MVC 3. When they try to insert table or create a new dataset, the visual studion 2010 simply restarted again and again. How to fix this issue. The below are the event log files for the above issue.
[Code]...
View 2 Replies
Apr 16, 2009
I am using the below code to dynamically change the text, but I also need to change the color from black to red of the entire row in SSRS, using VB.NET.However, row.Cells.Style.ForeColor = System.Drawing.Color.Red does not work. Any ideas on how to dynamically change text color in a particular row?
[Code]...
View 1 Replies
Sep 20, 2011
how I could do that to click a button on a Winform send a URL or you can (with parameters) to a Reporting Services and it loads in a browser.
View 4 Replies
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
Jul 9, 2009
I have an input parameter for my stored Proc, Instead of choosing available values from a drop Dwn, the customer wants an empty input box that when left blank returns all records. the parameter type is numeric(6,0) in the Db. I have not found a way to leave the input blank and retrieve all records. my default value for all records is '-99' and also is declared as the default value for the param in the proc.
View 1 Replies
Dec 6, 2011
I have the following code in "Custom Code" in SSRS 2008. It works fine in VS2008 but it won't run on the server:
Public Shared Function Ns(ByVal num as Object, ByVal def as Object) as Object
if IsNothing(num) OrElse Not IsNumeric(num) OrElse System.Double.IsNaN(num) then
return def
[code].....
View 1 Replies
Aug 13, 2009
I have a matrix with rows indicating a name (Ex Store name) and I have data pertaining to that in the DATA cells. I also have another date field in this format (MM/DD/YYYY). I would like to use a cross tab between Store Names and Just the Month of the date field.
[code]...
is there any expression I can use to get the month format on the header of column.
View 2 Replies
Apr 30, 2009
We are using Reporting Services to generate a purchase order, which is rendered as pdf before displaying on the screen. The report works well, as is, except that now we have to add a Terms & Conditions page to every PO. I've tried placing it in the footer, setting it to display only on the last page--this didn't work. I've also tried adding it to the body, setting the "Page Break Before" property to "true". This works, except that it looks like there is still space reserved for the header (i.e. the header's "show on last page" property is set to false). I can't get the Terms & conditions to fill the page. how I could attach or bind the pdf generated by reporting services with a pdf version of the Terms & Conditions sheet?
Note: We are using ASP & VB.NET 2.0, Visual Studio 2005, & SQL Server 2005.
View 2 Replies
Aug 27, 2010
How to call the .net windows service from VB application
I have only the executable for VB application. Through the exe , I am able to view the .Net service, but it does not allow to install the .net services.
View 1 Replies
Jul 5, 2010
I am new in programming. Have a some knowledge in scripting. me in sample coding using VB 2008. - Create an application that will run on system start up and still run even if user's Log off. - The application will read a list file that contains other application names (e.g notepad.exe) then the application will continue running.. if notepad runs then it will log to a text file the time started the execution and after it was quit it also log the application ended time of execution. - Like its running as services.
View 6 Replies
May 18, 2010
i have novice skills in programming in vb.net,I just finish my project and applications for Data logic memoir wherein the data has been save to text file or SQL compact server database in the Handheld Device and use Active Sync Connection to pass Data into H/PC to Desktop P.C and Vice Versa.I just shift now to C#.net and start learning it and i just successfully transpose my Smart Device Project from VB to C#.
But now i want to Start Projects linking The device to server using Web services
View 1 Replies
Jul 6, 2010
I'm a relatively seasoned VB (COM) vet but this is my first VB.Net application and as is my luck a web services application feeding off a site that I can't publicly mention nor can I post any code that may expose the site.
So, here's the problem. I have written a simple form and have 2 buttons. 1 button simply asks the webservice for it's version. This works no problem. I was able to load the web reference using their supplied WSDL file for this "version" class. Now that I have that working I think "GREAT, that was straight forward. I have my credentials, urls, etc working, the rest of this should be just as straight forward." (See where I jinxed myself here?)
Anyway, I move onto the next WSDL and set of classes and get that reference added no problem. (Man that took a LONG time, like 20 minutes.) I then build my "Get my order data" code syntaxes on the prescribed exposed classes and run my project just to see what errors I get. The "run" process takes almost 45 minutes to an hour..... It's as if the app is getting the WSDL set all over again but doing it over and over..... I have no clue what's going on.
I've tried to disable all the Windows 7 "potential" issues, UAC, firewall, etc, but these changes don't help. Anti virus, spyware, etc all these are off and no difference. I'm running VS2008 as an Admin, right click "run as admin", and have complete control over this machine. Any ideas, suggestions, etc are VERY welcome and I am happy to expose as much of this application as I can providing I can stay with in the rules of the confidentiality contract.
View 1 Replies
Feb 17, 2012
I am a new member here and a new user of VB.Net.So, I would like to know how to make an application that can control the processes and the services in a remote machine.
View 4 Replies
Jul 28, 2011
We are developing an application in VB.NET that will need to accomodate remote users logging onto a Microsoft Terminal Server using RDP through the MSTSC.exe client.
Is it possible to offer an 'Upload' button which will allow the remote user to pick a file from his/her local hard drive and upload to the server ?
View 1 Replies
Feb 1, 2012
I am trying to create an msi install for my windows service. The reason for creating an msi is that the intended users want to be able to quickly install the service with as-little intervention as possible.
i can get the service to install as a msi but i have a variable within my code that i need the user to define when the msi is being installed. the variable i require from the user is the file path which they want the xml files my service creates to be located.
i thought i could configure the app.config application settings to contain the file path that the xml files should be written to. However i'm struggling to do this and im not to sure if its the best way to do it?
I have my setup project that contains my executable and has my textbox which will contain the one variable from the user.I have an installer class which contains my serviceinstaller and process installer. This is where im struggling to understand what i need to do next. Do i need to override the install method? The current code of my installer class was automatically generated and is as follows:
[Code]...
View 1 Replies
Jul 14, 2011
windows services - Configure App.config Application Settings During MSI Install
View 3 Replies
Jun 2, 2011
I'm creating a webhandler and want to include classes from another file. How do I do this?
View 2 Replies
Feb 4, 2011
I'm still trying to follow this sample:
[URL]
Under Visual Studio it's working fine but, when I try to publish on IIS it doesn't works. This is the situation: under my Website I created a Upload.vb class under App_Code folder that implements IHttpHandler, IRequiresSessionState. On web.xml I wrote this rows:
<remove verb="POST,GET" path="Upload.axd"/>
<add verb="POST,GET" path="Upload.axd" type="Upload"/>
On Page.aspx I added this code:
<FlashUpload:FlashUpload ID="flashUpload" runat="server"
UploadPage="Upload.axd"
FileTypeDescription="Images" FileTypes="*.doc; *.xls; *.pdf; *.docx; *.xlsx"
UploadFileSizeLimit="0" TotalUploadSizeLimit="0" />
I followed the sample and my class has not namespace. I read on internet that this error happens when IIS is not able to find the class.
View 1 Replies
