.net - Reference A VB Function In Reporting Services Grouping?
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
ADVERTISEMENT
Aug 10, 2009
I am trying to summarize a datatable based on a primary column and then add certain columns. For example this table
col-1 col-2 col-3
1 AA 2
2 BB
[Code].....
This simply doesn't do anything becuase it thinks the target table doesn't have a primary key.
View 1 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
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
Jun 19, 2010
I'm trying to add a reference to the windows media services, but I cant find the reference.I found lots of pages, downloaded the platform sdk, on my laptop, got a server with windows server 2008 and installed the server2008 there also.
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
Oct 18, 2009
I use Ms VB 2008 express edition with SQL server express. I want to know what is the reference to be added to make a connection the SQL express database?
View 1 Replies
Jun 29, 2012
I am creating a database project where I take my data from mysql database and then create graphs and charts.I currently have microsoft visual basic 2010 express edition. I am familiar with visual basic but have never used mysql before. I have quried a database into mysql and server connection to the database is working fine. Furthermore I downloaded mysql a week ago so I have the latest connector.I looked at many youtube tutorials and have tried to find mysql.data in the add reference section (in project) but it doesn't seem to be
there.
View 3 Replies
Jul 7, 2010
I have an "Object reference not set to an instance of an object" error that does not make any sense.I have a form with 2 datagrid views, (dgv1) and (dgv2).During the form load, I load the data for dgv1 and dgv2 without any problems. After the form load is complete, I get an error on the follwoing code.
[Code]...
View 3 Replies
Jun 9, 2008
I have a combobox where the user can type the sql server name. Then a connect button that, when the user click, I want it to populate another combobox with all the databases from the server in the previous combobox. Unfortunately, I am getting the error object reference is not set....!
Here is where I am getting the error:
For Each objDB As Database In Me.SMOServer.Databases
I am new to VB ...I'm using vb2008 connecting to sql server 2005.
Here is my complete code:
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Public Class Form1
'Public Class frmSQLConnection
Private m_objServer As Server
[Code] .....
View 1 Replies
Nov 28, 2009
i am a php programmer but one of my clients is needing a script I created for him along time ago converted to .net.Anyhow, I got everything converted and working fine but one small issue. In PHP if I wish to update multiple records with -- DIFFERENT -- values, I can use mysql_fetch_array then do a simple loop to update the data in each record with different values.Basically here is what I need todo, Open the mysql database connection, execute my update SQL code.
i.e: update users set last_login_location='" & txtLastLoginLocation.Text & "' WHERE user_id='" & txtUserID.Text & "' This gentleman has many different salesman out in different parts of the country and he wants to keep a record of where they report in at. I know it sounds strange, but hes the client and I am just doing what he asks. He manually runs the report so I am unable todo it at each login.
View 2 Replies
Dec 23, 2008
I'm working on a Free, Open Source Multimedia player. I'm hoping if I do it right, I can have it beat out WMP and iTunes. As this is the case, I'm trying to program the whole thing without connecting to either WMP or iTunes through COM or ActiveX, and not use any of the .dlls.One of my current problems is that I can't seem to figure out how to setup a "Library" function. What I'm thinking right now is I want to setup a database, and then connect to it. I was able to create a Local Database, and setup my Table and Fields, but I don't know how to connect to the database; I figured out how to create a new instance of the table, but those get deleted as soon as the program is closed.If anyone has a suggestion on how to do this, or a tutorial they can point me to, that would be fantastic. My only stipulation I have is I'd like to be able to use SQL searches on the database, to make searching for song faster.
View 3 Replies
Jul 15, 2011
I am trying to call a stored procedure and get the idn_num as output on entering an input of a name. I get a "Procedure or function 'aaa' has to many arguements specified" error when I try to run my VB.net code
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:ParameterProject esttable.mdb;Persist Security Info=False" & ";Jet OLEDB:Database Password = "
conn.ConnectionString = "Data Source=localhostsqlexpress;Initial Catalog=PPRT;Integrated Security=True;Pooling=False"
[Code] .....
View 1 Replies
May 1, 2012
I have 2 functions that need to work together.1 function is to generate a chart number. The other function is to search via SQL to see if the chart number exists. if the chart number doesn't exist then i need function 2 to return a boolean value so function one can generate a new chart number example code: [code] Now i know that i am probably using the incorrect sql statement, my main issue is that i dont know how return available back to the function.
View 1 Replies
