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 RepliesI have a form with a single Report Viewer control on it. I wish to use this single form to display ALL of my application's reports. I am looking for a method that will allow me to assign the rdlc file / table adapter and rebind the datasource at runtime. I've tried various methods but cannot get it working. It sounds simple enough but is now driving me crazy!!
View 2 RepliesQuestion: 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.
I am having trouble loading and displaying my .rdlc report file in my reportviewer. I've been all over the internet and nothing worked.I think it might be because i am using vb.net 2008.Also I am wondering if there is a click event in Microsoft Reports or in Crystal Reports where I can link certain data in my report to other files in my project, eg. form2.vb
View 1 RepliesHow to use multiple rdlc file in one ReportViewer? in same dataset using visual basic 2010
View 1 RepliesI am having trouble loading and displaying my .rdlc report file in my reportviewer. I've been all over the internet and nothing worked.I think it might be because i am using vb.net 2008.
Also I am wondering if there is a click event in Microsoft Reports or in Crystal Reports where I can link certain data in my report to other files in my project, eg. form2.vb
I am trying to edit a .rdlc report file before displaying it to the user. it will eventualy read from an MS Access database, but first im just trying to get it working. I have included the proper namespaces(i think!!), but when i try to change the innertext of a node, it gives me the folllowing error:
Object reference not set to an instance of an object.
I have google worn out trying to find the solution...i know its probably somthing realy simple in the code but, for the life of me, i cant fugure it out.Here is the xml and code ( i have compacted some of the XML to make it fit)
XML-
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
[code].....
I am using the Microsoft ReportViewer 2005 in one of my VB.NET apps and a couple of users are having image display problems (red X) on the reports. They have the correct version of the WinForms DLL on their system and the app does verify that the image file exists before passing the location to the ReportViewer. This problem was reported on XP and Vista.No other users have reported this problem and it is not something that I can reproduce, so I am stumped.This is a sample file path that is passed to the ReportViewer,
Code:file:///C:UsersRandyDocumentsLisano EnterprisesDerbyDMVImagesUS PresidentsGrantUlysses.jpg
My app provides sample images and they can't get these to display either.
just want to check whether i am doing this right,i am using visual studio 2008 and have inserted an expression in the backgroundcolor properties for one of the textbox in the table which is suppose to highlight the textbox accordingly. the expression is:-
=iif(fields!element1.value = "hello", "Red", "White")
but however, the expression did not seem to take any effect on the textbox and remain transparent.
I have a report viewer that i would like to display different data in depending on the report button that the user clicks. The data is stored in access databases. I am able to retreive the data and display the initial report but i have not been able to change the report/data that is being displayed.
View 1 Repliesdirectly here is the issue:a "OpenFileDialog" on a windows form is made to choose a picture and then insert it into a rdlc report under VB.net 2008 so i need the exact command to access any picturebox in the rdlc report.
i used to do the job under VB6 as the following:Set ReportName.Sections("SectionName").Controls("Image2").Picture = LoadPicture(fileName)
I am using visual studio 2008 vb language I create a sql table and i want to show it in a nice format. I use the report wizard and point everything to the sql table. i create a form with the extension rdlc (i think its crystal)from my main.vb i want to click a button and open up report1.rdlc how do i do that?
View 1 RepliesHow do I view an rdlc report by pressing a button in runtime?The report is called summaryReport but I can't seem to find the code to actually run it.I was trying to do something like summaryReport.Show(), but by typing summaryReport doesn't even show any related events or methods, like the control didn't even exist.
View 2 RepliesCan 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 RepliesI am using .rdlc Microsoft Reporting reports. I have a form with one reportviewer on it. What I want to use is a combo box where they select the report and then click generate, and it shows a specific report. I have this code so far that changes the report:
[Code]...
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.
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.
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?
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 RepliesI'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.
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].....
Does Visual Basic 2010 have any reporting services, ie, Microsoft Report viewer?
View 6 RepliesI 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.
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.
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 RepliesI 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.
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]...
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]...
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 RepliesI 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