VB 2010 - Is The reporting Services in VS a Suitable Replacement?
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
ADVERTISEMENT
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
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
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
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
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
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
Feb 7, 2011
does anyone know what i can use in place of the NewIndex since it doesn't seem to be able to update that from my VB6 code?
lstARCurrent.AddItem strStatus & " - " & strApprover & " " & strStatusDate
lstARCurrent.ItemData(lstARCurrent.NewIndex) = (.Fields("approval").Value)
View 7 Replies
Jun 18, 2012
What's a replacement for e.Argument?I swapped from a Background worker to manual threading and I don't know what to use here?
View 1 Replies
Sep 3, 2010
The application reads information similar to a DXF file. For purposes of discussion, the data consists of lines, those lines have endpoints, x1,y1,x2,y2. Within the file those lines create "paths", in other words, they are connected. There can be many separate paths within a single file. However in the original file, the geometry is not in any particular order, the paths are not indicated.
View 3 Replies
Dec 23, 2009
I am upgrading my program from VB6 to VB2010. In VB6 I am using about 200 pictureboxes loaded at runtime starting with one of each different picture
Private Sub Form_Load()
Image1(0).Top = 2340
Image1(0).Left = Screen.Width - 1300
Image1(0).ZOrder 0
[code]....
What can i use instead of control arrays in VB2010 to get the same functionality as in VB6, or does VB2010 use control arrays?
View 3 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
Jul 13, 2010
many posts about the security risks of app.config file...ncrypted or not... for storing the connection strings of a remote database.OK! I agree with this... but... how can i make a VB.NET Application to connect to my database thru WebService or WCF as long my server is Centos with MySQL ? How can i make the connection strings of MySQL Connector to work with WebServices or WCF ? I did not find any solution for this problem.
View 1 Replies
May 20, 2012
I'm using Regex.Replace function. It fails to accept trackbar1.value as "replacement as string". This code returns "Reference to a non-shared member requires an object reference." error:
[Code]...
View 1 Replies
Apr 26, 2012
I'm working on a application which suppose to work as a interface between multiple applications. as a example, one PBX system sends me data via TCPIP or COM ports and I manipulate it and send to PMS application. likewise PMS also send me data which I need to send back to PBX system.By query is, I don't have a fix number of communication interfaces and it can go up to 8 - 10 or may be more and they should work independently (should be able to switch off communication at any time in any interface).
In this situation, I cannot handle everything in one service or two since I don't know how many interfaces going to be. So I'm thinking a way to create services dynamically such as when user create a new interface in application it automatically creates the windows service on server or pc.I don't really need to create services remotely since my application will install only in one pc or a server and system administrator will access the server for the configurations.
View 11 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
Aug 3, 2011
What is the suitable type for these 3 syntax in vb.net? i can't find in this page url..I've tried to convert the first one to -->byval ID() as byte is not working
1. unsigned char *ID
2. unsigned short*Count,
3.unsigned long*Minute
View 7 Replies
Jun 16, 2011
what version of devexpress is more subtable for vb.net 2008?
View 1 Replies
