Thanks for getting back and providing me with the information. As below, this should be enough for me to work something out.

Thanks for getting back and providing me with the information. This should be enough for me to work something out.

I looking into doing the following.... Create CSV files via VB.Net and then add these files to 7 zip manager. I want to do this automatically rather than getting the users to manually add these files to 7 zip manager. Before I start doing this.... 1. Can this be done 2. If so how and is there any good examples I could use? Thanks in advance.

I have a masked text box that displays a date dd/mm/yyyy e.g. 01/03/2007 When I try and change the format to read yyyy-mm-dd, it displays yyyy-mm-dd and not 2007-03-01 If it was any ordinary text box the syntax is format(MyDateField.Text, "yyyy-mm-dd") and it works. It does not when the text box is masked. I must be doing something stupid or missing syntax. How do I get a masked text box to format correctly as above?

Hi, I have to run crystal reports runtime before/after installing a new vb.net project on a user's pc. How can I include the automatic installation of crystal reports runtime file when deploying a project onto a user's pc e.g. run CRRedist2008_x86.msi. I know this can be done but how? Thanks in advance.

Hi, When I try the following I get an error.... crReport.DataSourceConnections(servername, database, True) "Property access must assign to the property or use it's value" I am trying to assign a database to my crystal report. The reason being I have a test database and a live database. Any ideas where I am going wrong or what I should do?

Hi, This is an easy one, I think. I have written a procedure behind a button e.g. Private Sub btnProcess_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnProcess.Click I want to call this procedure from a timer function, how is this done? Thanks in advance.

Hi, I get the following message when I try and delete a file. "System.IO.IOException - The process cannot access the file 'filename' because it is being used by another process." My cut down code is as follows Dim aryFi As IO.FileInfo() = diFolder.GetFiles("*.pdf") For Each fi In aryFi sFileName = fi.Name fi.delete Next Basically what I am doing is that depending what file is in the folder, delete it once I get various information about it that file. The above code is a cut down version. What other way would you delete a file or is this the best way. If so, what am I doing wrong. Thanks in advance.

modified on Wednesday, May 25, 2011 8:30 AM

Hi, I'm doing a project on generating a Crystalreport and viewing it in a pdf format. I'm using vb.net and sql server (2008). I have managed to create the crystalreport, save it in local directory then view it. I would also like to save the pdf file into my sql database. This, for me, is the difficult part and also the part which i'm stuck now. Hope there will be someone who can help me! Thanks in advance.

How do you store/retrieve a PDF file in SQL Server using vb.net code?

Hi, I think I am getting mixed up. The question I meant was "How can I set the code so that my printer does not print duplex" What is the syntax and what class do I import. It has been a long time since I did any real coding and I am a wee bit rusty. You can properly tell with this question...getting old.

Thanks for the speedy reply. How would this code/structure be displayed on the project. Sorry for this.

Hi, I am printing Crystal reports via VB.Net. Some of the printers are set to print duplex others are not. I want to set the printers duplex option to off when ever I run the code. What is the best way of doing this. What do I have to import/do to achieve this? I have tried importing SystemManagement but no success. What am I doing wrong. Any sample would be welcome.

What is the best way to check for a particulair file in a folder? e.g. I want to count the number of files that start with say "temp" and have an extension of txt. In this example Folder = Temp Files = temp01.txt, report.txt, temp02.txt. In this example we would return a count of 2

I have a listview with values Salary Name Department 2000 Peter Accounts 1000 Anne Sales If I want the salary, I have the following code that works MsgBox(lvwListView.SelectedItems(0).Text) This gives me a value of 2000. What is the code if I want to display their Name or the Department instead of salary

Works a treat now. A big thank you and have a great weekend.

Hi, Thanks for replying. I tried the following but still got the same message. cr.DataDefinition.ParameterFields("PassParameter").ApplyCurrentValues("123456") I agree I was assigning the parameter to the viewer object but I just cannot seem to get the syntax right to assign to cr. What is the correct syntax as I have tried all sorts code?

I am getting the following error message "Missing parameter values." when I am trying to print directly to the printer. Below is my code. Works perfect if I want to view on screen but get the above error message when I try to print direct to my printer. If I did not have any parameter code etc, prints no bother to printer. Dim cr As New ReportDocument Dim param1Fields As New ParameterFields Dim param1Field As New ParameterField Dim param1Range As New ParameterDiscreteValue cr.Load("c:\MyReport.rpt") param1Field.ParameterFieldName = "PassedParameter" param1Range.Value = 123456 param1Field.CurrentValues.Add(param1Range) param1Fields.Add(param1Field) CrystalReportViewer1.ParameterFieldInfo = param1Fields 'View Report 'CrystalReportViewer1.ReportSource = cr 'Print straight to printer cr.PrintToPrinter(1, False, 0, 0) '(1, False, 0, 0)

modified on Friday, November 26, 2010 5:21 AM

I have been tasked to write an VB.Net application with all reports to be written in SSRS. I have never done SSRS so the first questions, 1. How can I print the report straight to printer and not first browser then print. Can this be done? 2. Can you create a PDF file and not first via browser What would be the easiest and the fastest way to do these reports from VB.NET? Thanks in advance.

I am in the process of writing multiple reports for a system developed using Visual Studio 2008 (VB.Net)and running SSRS 2008. Is it possible when you click a "Print" button that rather than the report showing up in the report viewer window first, that the report be sent directly to the printer without viewing it in a window first. Unfortunately, since I am fairly new to Reporting Services, I cannot figure out the process to do this. So basically, is there a way I can print a report without viewing it first? Other.... I know the users are going to ask as well as sending the report directly to printer, to save it in a PDF format. Can this be done?