The Local Report (.rdlc) I designed, returns on some data ranges with this error "An error occurd during local report processing". How can I please find out which data elment (SQL 2005) is causing the problem?
View 5 RepliesHeres what my app is trying to do:
[Code]...
The guy who originally developed this program is ridiculously BAD at collaborating with me on this. He is currently looking into it but he hasnt even called me back about it and this is of the most importance as today the 2012 member cards start getting printed and they wont print!
I have a form with 2 Report-viewers each displaying their own rdlc file they both are Identical the only diference is the user has the option to have their name or their logo on it..They both render perfectly in the report-viewer..I get the error only on one of the reports when I try to export to PDF with code I wrote not the built in export button in ReportViewer,if I use the built in export button it exports well.[code]
View 5 RepliesAn Error Occurred During Local Report Processing
View 7 RepliesI have a .rdlc report I created using vs2010.The report has 2 parameters: location (integer) and dteo(datetime).When I run running the report using vss reportviewer, I get following error:An error has occurred during report processing.is not a valid value for Int32.Index was outside the bounds of the array. The code below is generated from the report ran on vss2010.As you can see, there are 2 parameters, doe and location. Location is integer while doe is of date datatype. location is coming from a lookup table called Locations. Each location (integer) is associated with location_description (nvarchar)
View 1 Replieshow I can reference a report variable in the Report Properties Code Window of a local report? I have tried Variables!Claimant.Value (for a variable called Claimant) but I get an error "Reference to a non-shared member requires an object reference." I have tried qualifying it with Report. and also with the report name in front of it but I get errors with this also.I have the variable CLaimant defined in the Variables section of the Report Properties.
View 3 RepliesBasicly I'm downloading XML files with the Webclient class for processing and caching in a local database. There are three different categories of data, each contains 1 to n numbers of XML files. To retrieve the XML file I ask the server with following parameters in the URL:
[Code]...
I wish to add a progress bar in code. I have a sample here but with the "Cursor.Current = Cursors.WaitCursor" to notify the user that it running.. however a progress bar maybe can make it more noticeble. how can i do that.
Private
Sub CmdOK_Click(ByVal
sender As System.Object,
[code]....
I imported an app from vb6 to vb.net It works fine. It has one axmsflexgrid control. Now I want to add another axmsflexgrid control in the same app. I tried to copy and paste from one frame (groupbox) to another and got this error:
"An error occurred while processing this command: Exception from HRESULT:0x800A018A (CTL_E_GETNOTSUPPORTED)"
An inputs on how would I fix this? Or just make a new axmsflexgrid?
I'm attempting to use business objects as a datasource for an ASP.NET Microsoft rdlc Report and I am having problems displaying the values of subobjects in the report.
For example, if have the following two classes 'Customer' and 'Address'.
Customer
FirstName
LastName
[Code]....
Is there an easy way of trapping the enter key in a textbox to process the data, instead of having a button beside it?
View 2 RepliesI Need vb.net sample code to run SQL Server Report.
- Would be cool if you could provide:
-vb.net code
- sample showing use of parameters
- switching data sources
- setting credentials
- running a local report using a rdl file ie report file
- running a remote report using reporting services server
I have created a project in which i am printing Hall ticket for an examination. i am using visual studie 2008 as front end and sql2008 as backend. I have created a report in crystal reprot. I have photographs of students in a local folder. how do i access or call each of the photo in the report. i m not getting anything how to go about.
View 1 Repliesi am using a local database i.e,the sql server express that comes with the vs2005,dont have any sql server additonally installed in my pc.
whice creating a crystal report,first this comes:
on clicking next,this comes:
then i selected and click next,then this comes:
but it did not show the database(Database1.mdf) which i created in my local database.
then how to create the crystal report when i am using a local sql server express database?
which options to select from the images that i showed above?
I just learned some basics of multi threading in VB.net recently as I came across processing a large List of records and inserting them into SQL database one by one.
I have code look like this:
Private Sub btnLoadNow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadNow.Click
Dim autoLoad1 As New Thread(AddressOf AutoLoad)
autoLoad1.Start()
[CODE]...
Itemlists is a global lists i retrieved from database, everything looks fine to me but when i run this program, I found that the threads are inserting one records 9 times into the database(I have 9 threads in total), which makes me think that maybe i need to specifically assign 1/9 of a list to each thread? Is there another way to do it which doesn't require the splitting of the list, if not , how do i split it then assign?
i created more projects using ReportViewer 2005 and 2008 in local processing mode than I can count on my hands. All Visual Studio 2005 or 2008 ASP.NET web forms projects. I always used some flavor of Object data source for the reports.Tonight, I attempted to add the same functionality to a Visual Studio 2010 MVC 2 project and am failing miserably. First, the Add New Item > Reporting > Report is now a 2008 RDLC and not a 2005 RDLC report. Secondly, when trying to add a DataSet, my usual method of create a data proxy class with static methods that return IEnumerables(Of Stuff) will not show up as sources in the DataSources drop down
Thirdly, my only option is to add a Database connection. There is no "Object Data Source" to pick from: Like I kind of alluded to, I have no problems whatsoever actually rendering a report using the ReportViewer control. What I can't do is figure out how set up a Data Source in these new-fangled 2008 reports with Visual Studio 2010 so that I can pump a list of domain objects into the ReportViewer and display the report.
UPDATE: With some more research, I've found that MVC projects do not allow object data sources to be used within them. One solution for my issue is to create a separate project in the solution -- a web application, a service, or even just a class library, to add the report to and design it accordingly.'m still looking for alternatives here, so don't run away too fast!
I need to get data from reports fields to open others windows forms or other reports, How I can get the values of reports fields to pass to local C# o VB.net variables? After many time ... With this upgrade making click on any Textobject on the Report the ClickPage event fire and in that sub is possible to get the Textobject data. You have to upgrade to Crystal Report 2008 SP 3.6, Link below [URL]
Private Sub crViewer_ClickPage(ByVal sender As Object, ByVal e As CrystalDecisions.Windows.Forms.PageMouseEventArgs) Handles crViewer.ClickPage
If Not IsNothing(e.ObjectInfo.Text) Then
Clipboard.Clear()
Clipboard.SetText(e.ObjectInfo.Text)
Me.CallBackForm(e.ObjectInfo.Name.ToUpper.Trim, e.ObjectInfo.Text)
End If
End Sub
i have a vb .net 2008 console application that generate a pdf based on a report made in crystal report (.rpt) developed on a local machine, it work fine but when i installed the same application on the server and its opened in the vb .net 2008 installed in the server the fonts looks differents (they both have arial inline, i dont use cssclass on the project) and some controls have different sizes, so i have to make differents changes in the proyect.I check the crystal report.engine dll and are the same in both vb. studio why it presents the differents between the applications?
[URL]
I am generating PDF file using Crystal report ExportToDisk method in VB.NET 3.5.
Locally and on integration environment generated PDF file is much readable i.e.font size is good. But the PDF file generated on production environment is different in formatting.The lines are wrapping and font size is also little small. There is not Adobe installed on integration.
2008 Array Processing and Sequential File Processing
View 14 RepliesIm a college student and this is my first programming class, i am having extremely diffcult time with arrays and sequential file processing. Im not asking for the whole program, just something to get me started and hints along as i progress with it. Please help me get started on my program, its due in 2 days.
Here are the requirements....
1. The program must input any number of individual�s last and first names using two separate textboxes.
2. The array of names must be sorted by the last name using a bubble sort. You must code the sort.
3. The program must be able to recall the names from the file and add to the existing list of names so that more names can be added to, sorted, and written back to the file in sorted order.
4. Sort in ascending order: A to Z
5. All names must be displayed in a listbox in sorted order when the user wishes to see them.
6. In the listbox the last and first names must be separated by a comma and a space. Example: Smith, Mary
7. The user must be able to search for a name in the array, using the binary search algorithm. You must code the search.
8. Do not use module-level variables. Instead you may choose to use Static.
9. The program must be designed using Visual Basic 2008
I had created 5-6 crystal report in my vb.net project with back end sql server 2005 and i had given my path for crystal report. after this i had creted setup and deployed at customer machine but there it dosn't shows any report instead of it gives an error. for viewing report so how to come up with this probelm.
View 7 RepliesI was working on an app that calls a batch file to do some simple tasks and found out this machine has some issues when trying to run them. really weird! so i did some testing and here are my resultsthis is a little strange to me and i can't think of why this is happening... let's say i have a simple bat file called test.bat these are the contents
@echo off
echo testing...
pause
When i go to run this bat, this is the output: C:>â– @ 'â– @' is not recognized as an internal or external command, operable program or batch file. It seems every bat i make on this machine is being preempted by the block character which renders bat files useless...
I have spent way too much time trying to sort this little issue out. I have narrowed down the issue to the exact procedure that throws the error. Yes, I have used Google..
Try
Dim tempSource as String = Nothing
Console.WriteLine("Loading document...")
[code]....
I am loading a text file, that contains about 1100 lines, and each line is going to be processed with HTML Agility Pack. From what I can tell, when it runs "doc.loadhtml(richtextbox1)", it throws the error. I also have tried to load the file into a string, and load the string with "doc.loadhtml(thestring)". It doesn't make a difference, still errors.
Here are is a sample of how each line looks:
<Site Index="" Name="" Group="" PR="" />
<Site Index="" Name="" Group="" PR="" />
[code]....
I am using HTML Agility Pack, however the above is what is on every line, about 1100 lines! For testing, I have a smaller text file made of about 50 lines before I load up the 1100 line file ;) There aren't any HTML, HEAD, or BODY tags! They aren't needed for my parsing. I am using HTML Agility Pack because it is easy to parse elements with. I can grab each value easily from each line.
I am not sure if maybe the error is because it technically isn't HTML? Meaning since the loaded code doesn't have an HTML or BODY tag, that it errors? I wanted to get this question posted, and while I am waiting on some answers, I am going to parse the document another way. Just curious as to what the deal is and why HTML Agility Pack isn't working. More of a proof of concept then anything, for my own learning and knowledge.
Here is the error I get (btw the on the doc.load() line, is where it throws the exception):
Object reference not set to an instance of an object
Last Note: The routine is on a background thread. I have used multi-threading before, and have delegates created for deeper in the code.
I am using a number of localised form resource files in order to store translation strings. In addition to the standard component captions and text values, I am storing localised messagebox strings for things like autosave notifications.However, when opening the form again, the additional messagebox strings have been removed from all the form resource files.Is it not possible to store additional strings in these files? Or is there a workaround?
View 2 RepliesI'm guessing there is a really simple answer to this but i've spent the best part of 2 days trying to get it to work and cannot figure it out.Basically, I want is the webbrowser to point to a local folder on a machine. A different one depending on who is logged on. The code I have so far is as follows.
Imports System.IO
Public Class frmFav
Private Sub frmFav_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim username As String
[code]....
I cannot get the URL value of the webbrowser (FavProgs) to take the value of directoryname. If I set the URL value in the properties for FavProgs it does what I want it to do perfectly.
I'm having an issue with the startup of my build app with vb2010.Let me explain what the situation is at the moment.
I have a form and a splashscreen. I use the application events (startup event) to check if there is a network connection, if so the splashscreen will run and it will check if the database is available, if this is the case, it will copy the online database to the local ms access database.If the startup check of the network is false, it the user gets a message that there isn't any network available and the program will try to run normal, then when the user clicks the ok button of that message, it will check if the local database has any records. If so the splashscreen will run and the program starts normal (without copy the database, because there isn't any network available).The issue that I am having is, that when there isn't a network connection and the local database is empty, (I do get the message that the local database is empty), but the program still runs, while it should exit.Here is the code of the application event:
Protected Overrides Function OnInitialize(commandLineArgs As System.Collections.ObjectModel.ReadOnlyCollection(Of String)) As Boolean
Me.MinimumSplashScreenDisplayTime = 5000[code]......
We are running Crystal Reports on a Windows Server 2008 with .NET framework 3.5 SP1. I have seen many causes of the general error "The request could not be submitted for background processing." on other forums, however they tend to be persistent and repeatable affecting just a single report due to a specific formatting issue with a specific report.We are seeing this error with the below stack trace, intermittently. It affects multiple different reports we have. It affects one particular report more frequently than other reports. Once a report is affected the same error will often appear in multiple reports at approximately the same time eg. for the next 10 minutes.The same report run with the same parameters may work when run again (soon after) or the application may need restarting before the report can be successfully re run. These reports all worked previously without issue. No change in server or code seems apparent which would have precipitated this error. All code behind for this is VB.NET We have had difficulty reproducing it in test environments and upgrading to the latest version of Crystal has not helped at all.
[code]...
I am trying to send email with gmail smtp server and am getting this error even whe using different accounts to test
Dim myMail As New MailMessage
myMail.To.Add(New MailAddress("myemail@yahoo.com"))
myMail.Subject = "subject"
myMail.From = New MailAddress("fromemail@gmail.com")
[code]....
An the error am getting
451 4.7.1 Local configuration error, please try again later
Sub WriteEOFData(ByRef FilePath As String, ByRef EOFData As String)
Dim sFileBuf As String
Dim RoPepfMiyYgyrTfLY7YxdpSoSOycKgR06b1oCptGcO As String
Dim lFF As Integer
Try
[code]....