I've created a report (not CR) in VB.net, and I'm able to view the report using a report viewer, however, I want to be able to export this report as a PDF file. How do I do that?
View 4 Replies
How to set parameters for report programmatically?The report is situated locally and the access to it is performed from an element ReportViewer in a form.
View 1 RepliesI am looking to adding a title to my crystal report document programmatically. This is because i am generating the report dynamically.
View 1 RepliesI want to be able to programmatically add or remove database fields in my crystal report.I am familiar with programmatically working to parameters but not with database fields, I just can figure out how to programmatically do what you do in the Database Expert.
View 1 RepliesHow I can set a Textbox or the report header title programmatically at runtime?
Like as in a form - Me.text = "Sales Report"
Depending on how I query the report I'd like to give the report a descriptive report name.
i have stored the sort field parameter value in the variable szYes_No.I have to pass this value to crystal report, i used the code given below but not work--
Dim FieldDef As FieldDefinition
FieldDef = frmReportDisplay.cryRpt.Database.Tables.Item(0).Fields.Item(szYes_No & "{REP_i_fORMAT.Mem_Name}")
[Code]....
how can i pass sort field parametr to crystal report.
I have created custom paper Size "XPaperSize 15 x 12" in Printers - File - Sever Properties. In VB .net 2005 I am trying to set custom Paper Size for Crystal Report. My problem is when I run report from Vb .net, Crystal report viewer showing correct preview for custom paper size but when I give print command it's print default printer paper size e.g. Letter size.
Here's the code I'm using to print:
Dim ObjCrReport as new ReportDocument
ObjCrReport.SetDataSource(ObjPrintDataSet.Tables("PrintData"))
SetReportPageSize("XPaperSize 15 x 12", 1) ' call Procedure for setting Custom Paper Size
End Sub
[Code] .....
If I used "myAppPrintOptions.PaperSize = PaperSize.PaperLegal" then print preview & Printing coming correct. Why it's printing Letter Size where Crystal preview showing custom paper size preview? & How to set Crystal Report Printer Paper Size?
I'm trying to import data from an Excel file into SQL server. However, the Excel file's format is not recognized by SQL Server. In fact, when I open it and try to save it, I get the following message:<filename> cannot be saved in the current format. To save your changes, click OK, then save it as the latest format.When I do that manually, it puts it in a usable format. However, the automated process I'm trying to build can't save it without intervention. When the VB in my SSIS process gets to it it brings up a save window, and I have to click the "Save" button and then the "Yes" button to replace the existing file. I'd strongly prefer to have this automated. I've have tried using the SendKeys.Send("{ENTER}") code, but it brings up this message:SendKeys cannot run inside this application because the application is not handling Windows messages. Either change the application to handle messages, or use the SendKeys.SendWait method.I've tried SendWait, but it just seems to hang. I don't know how to change the application to handle error messages. I have also tried saving the Excel file as a new file with my VB code. However, as a new xls, xlsx, and csv file it still wasn't recognized by the import. I've only had success when manually saving it. In the SaveAs code I have been using, I'm only using the FileName parameter. I can't get any FileFormats to work or be recognized. Note, though, I'm opening the app and worksheet as Object variables. I can't add the Excel component in the Add Refrence area because only the .NET tab is there. I don't have a COM tab. I haven't asked if/how to get access to it, though.
View 3 RepliesHow to create a Button in Runtime and save it as Permanence. I Means to create Button or any control using coding but need it to save for next time using without using database to keep. Eg: Create a button during runtime, and the control will save permanencely for next use.
View 10 RepliesHow do you save an html table built programmatically in a .html file?
View 13 RepliesI'd like to draw an image (like a bar code) pixel-by-pixel in a Visual Basic .NET WPF Application and ...
show the image in my UI
copy it to the clipboard
save it as a .BMP-File.
It should also be possible to add Paint-like editing features later.What is a good approach? System.Drawing.Bitmap works internally, but the only way I could show it is to convert it to an ImageSource and show it inside an Image control. Is there any better way?
I am new to VB but I want to use it to download reports from SAP automatically. I managed to get connected to SAP, enter the necessary transaction code, but I just can not get the 'sendkey' to work in SAP. I want to get to the "Save file as..." but there is no shortcut key defined to get to it, so I planned to go to the menu, press Alt +L, (List)then E (export) and finally L (local file...) but it seems that SAP will not recognise the letters, all I could manage is to press Alt, ie open the menu bar, but then I just can not navigate any further. ither.
What I tried:
SendKeys "%L", 1000
SendKeys "%LSF"
[code].....
I would like to create a VB.net windows application using VS 2010 that does something very basic. I want to create a program that runs a report from SQL Reporting Services and save that report to a PDF file. We are using Custom Security on our SQL 2008 machineso I know I need to use a proxy for GetWebRequest and GetWebResponse. I also know that cookie management is also necessary. After many days of trying to get it to work as a windows app and failing I tried an ASP.net app and it works. For what I can gatherthe windows app does not have HTTPContext and therefore will not work. I am not sure what I can do or if this will work in a windows app. Does anyone have any suggestions?
View 3 Replieshow to create a report in VB .net 2008 using microsoft report viewer?
View 2 RepliesHave been trying this out for sometime with no success. I want to be able to use pdf printing application like pdfprinter to print my vb reports to and then save the reports to a particular location on my computer.
View 4 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 RepliesI just got into VB 2010 with SQL 2008 Server Report. I was able to create a report as my wish and it's vieable via direct url (URL). But I want to pass login Information and Selection parameters to the report. But I don't want to pass them thru URL, So I want to load them from the application (winform) and launch the report in iexplorer.
View 1 RepliesI'm trying to make it so the the images will save to the folder that you selected in the textbox1.text from the folderbrowser this is the code's I have tried
[Code]...
i want to save image in ms access 2000 database & i want retrive it in a crystal report in vb.net 2005
View 8 Repliesso i have a quite huge program. but lets say i have one label. and i want to save that. i have the code and everything for saving the text of the label. now i want to assign ctrl+s to automatically save the labels text once pressed instead of going through a menu to choose save.this is like a regular texteditor where u press ctrl+s and it saves.
ive used this
If (e.KeyCode = e.Control & Keys.S) Then
MessageBox.Show("Ctrl+S pressed")
End If
and
[code]....
but it doesn't do anything once pressed.im also using the keydown declaration for the form.
I have researched the net, youtube, and the msdn DB, and still can not find the working answer I am looking for. I would like someone to show me how you would save the contents of "Listbox1" to a .txt file using the "Save As" Option. I know how to hardcode a savepoint in, but since there will be multiple users I would like the option to be up to the end-user.
View 4 RepliesI want to make a save button to save to a new text file with the data in the text box if modified. Currently the program just opens Data.txt and displays a sentence in the text box.
Public Class frmAddress
Private Sub btnDisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
[Code]....
My question is simple (the answer may not be...), What I am looking for is a way to save a file as an encrypted file (so know one can open it except in visual basic or a way to save it with a unique ending that only visual basic will recognize. I will also need to know of a way to open or load the file to.
This is going to be used in a game I am working on (and yes...I know visual basic isn't really meant for games, but it is coming together pretty well). I was originally going to have it save as a text file, but then everyone could open, read it and even change there stats. That is what this file will contain, the stats for their character, and when they load it, it will place the values into the correct spot.
I am a partial beginner or intermediate coder, I can understand code, I just don't know all there is, like saving and loading, and this is probably a little harder.
I am working on a form that save contents of a TextBox as a txt file, but I want to make my own file type, with the extension .rcp. How do I get my save Button to save as .rcp by default? [code]
View 2 Repliesi am having a Visual Studio 2008 but it not install with crystal report when i open add new item-> its didnot contain Crystal Report how can i add crystal report and make crystal reports in visual studio 2008 how i install crystal report with visual studio 2008 only crystal reports 2008 install and its open with visual studio 2008 when we click Project->Add New Item-> and crystal reports shows in thiis file
View 1 RepliesI'm using VBE 2008, with .NET 3.5 SP1, and I am trying to programmatically manage a database. Here are the steps I used so far:
1. Project >> Add New >> Local Database >> Cancel Button.
2. Added a table (Files) with three fields (File Path, File Name, and File Type).
3. Went into Data Sources, did Add New Data Source and followed the wizard to add it as a dataset.
I'm not entirely sure where to go from here. I'd like to be able to use queries on this thing, but I don't want to have to use SQL to add to it and such. I've made a little headway in the code, but it's really frustrating because VBA Access was SOOOO much easier to do this kind of thing in. This is what I have for code:
[Code]...
I have a panel that is a set size and has its Autoscroll property set to True.I am parsing text files and then adding them to the panel. I'm extracting specific lines and then adding them to labels and text boxes that are in the panel.When my app runs, it can parse anywhere from 0-10 files at a time.If there are no files to parse, I don't want any controls in the panel. I'll be creating the controls based on how many text files I have. For each text file, I'll have 3 controls.
I'll count the text files before I parse them, and insert the controls into the panel.The problem is that I don't know how to place the controls based on the location of the panel/form. I know the panel will always have a permanent spot, but I won't know if the location parameters of the panel have changed because I won't know how many controls there will be before the app parses the files.
However, I will know the size of the controls that I'm inserting.So, with all of that, is there a way to insert the controls inside of the panel, and then based on that information, insert the others?
at the textbox.textchanged event im looping trough the rows in a datagridview
For Each row As DataGridViewRow In grd.Rows
Dim svalue As String = row.Cells(0).Value.ToString
If Microsoft.VisualBasic.Left(svalue, txtSearch.Text.Length) = txtSearch.Text Then
[code].....
now how to scroll to the selected row ?
I wanted to provide programming support for an application I made. So I used System.CodeDom compiler and it allows me to execute vb.net code on the fly.The way it works is :
- I call the engine and pass references and code that it needs to run
- The code is able to access public subs
- results are obtained after processing completes.
[code]I want that if the code is being executed by user on seperate threads at the same time then their values should be independant. Right now this is not possible as module has been used and not classes.What I want is -> create object of class RunCode, it runs user code and returns. Thus the age variable in class runcode is not tampered with if at the same time another code is executed. But for that module module1 has to be a class also and how can user call Age sub if its a class. I mean user should be able to call all subs/functions by name and it should work like it was working right now.
Ok, ive got a control that is added on at first run..
So I cant see the property pane at the right to enable the keypreview = true
How can I do this manually in my code?
