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 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]...
I have a website(asp.net) which displays ssrs reports. Howevery everytime that I try to run the report from the website it takes about 2 min to load, but if I click on the report again , it will load up in seconds. I have tried to run a query that is used by the report and I get the results in second as well.
Is there any configuaration that I need to change or any tsql code that I need to add?
I have gone through to solutions provided here on stackoverflow but still had no luck.
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 RepliesWe 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?
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.
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.
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 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]...
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 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 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 RepliesI 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].....
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.
my users to view, send (via email), export SSRS reports. I have set up date parameter boxes with calendar drop down and they are able to send via email a URL link that would either display the report via ReportViewer or send a link that would let then view the report in Excel or PDF. This is working just fine. Now I just added another report with a procedure prompt using a text box. Report works fine when I run it in SSRS. If I enter say carotid stent, it displays all records that have the word "carotid stent" in the procedure name field. Now, when I added code using VS 2005 to accommodate this new parameter, here's my code -
ProcedureName = txtProcedureName.Text
msg.Body = "Please click on the URL link to view the report - " + Chr(13) + Chr(10) + "http://SERVERNAME/ReportServer/Pages/ReportViewer.aspx?%2fReports%2f" + ReportName +
[code].....
I working on ASP.NET application.I need to add Thousands Separators to the number as in output below.Are there any built in VB.NET functions?.Pls share some links.
Input: 3427689 output: 3,427,689
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.
What is ado.net synchronization services and how to use these services
View 1 Repliesi have the sql code (exported from mysql) as
[Code]...
I have tried multiple times to get string str to = this but it never works? can someone look at it and tell me wat cud be wrong or even better and possibly convert it into the str 4 me or give me an easy way to do it?
I have created a very simple Visual Studio .net 2002 VB# program. It consists of form1 containing a DataGrid bound to an Access 2007 Database using OleDbConnection1, OleDbDataAdapter1 and DataSet11.The location address of the Database will change based on the user so, I need to make the connection string variable. Problem is inserting the following string variable "source=" & strFileLocation & ";" creates a fatal error
View 1 RepliesI have just written an application for myself and a few other users to use .rdp to connect to a number of servers, by clicking on the appropriate button. In the full version of the program I have two sets of connections one for when we are inside our vpn, which uses local ip addresses and DNS names; and the other which uses the external IP addresses and DNS names.This works quite well; if the user has stored credentials on their pc for the connection they connect straightaway; and if they don't the .rdp dialogue opens up with the server name/address filled in, ready for them to edit the rest of the required information.The problem for me is that this means I have to code 43 different Private Subs and then link the buttons; and I was hoping that instead of individually coding each connection, I could get the users to:Select by an option button whether the connection was internal or external
View 3 RepliesI need to be able to pull a list of reference from a database whixh ar 12 characters long. Unfortunatley i dont want the first character from each reference number as it is useless but just has to be there.
anyway of saying "list refernce numbers, not including the first character"?
I have been given the task of debugging someone else's program. It previously ran flawlessly on a 32-bit Windows XP system, but now we are steadily switching over to 64-bit systems and this program has "spit the bit" so to speak.
This is App.Config.xml
Code:
<configuration>
<appSettings>
[Code] .....
The problem is I don't know my alternatives are. System.Configuration.ConfigurationMananger.AppSettings doesn't work.
I've tracked the problem to the last line Con.Open().
Code:
Public Function get_quotes(ByVal strDBConnection As String) As DataSet
Dim con As SqlConnection = New SqlConnection(strDBConnection)
Dim strQuery As String = "SELECT qmpQuoteID FROM Quotes"
Dim da As New SqlDataAdapter(strQuery, con)
Dim dsQuotes As New DataSet("quotes")
Try
con.Open()
The error is "The ConnectionString property has not been initialized."
I have a report already setup on the ReportServer. And its subscription as well. What I'm trying to do is add the ParameterValue "CC" and some email addresses then send the email out. It doesn't seem to work.
My code:
Dim emailReader As SqlDataReader = selCount.ExecuteReader
Dim emailsTest As List(Of String) = New List(Of String)
[code].....