I am using Dot net 1.0 and sql2k.I am design report in dot net IDE. Then i am assign to Crystal report viewer as report source And when i am run that page, it will give error below:Logon failed. Description: An unhandled exception occurred during the execution of the current web request. Please r...

how i can read & get a file property such as type,date,size & etc.<br/>Please help<br/>Thanks

I dont want to have to click on the datagrid row to get the link to the data.I have the correct data but it displays the master table in the dayagrid and then a link to the slave table in the datgrid.I just want the link to appear between the textbox (1 record) and the datagrid (many records) The d...

in mysql there are query like select colomn, count(column) from table group by columnin i need to do the same thing using microsoft access in visual basic 6.0, because after that get the data plus the count result, i would like to use that count number to do some calculation, how am i going to do......

hi all, Im not getting any help regarding this question anywhere :(i m using picturebox as a container in which i want to use few images. also im using 2 scroll bars.the problem is if i have only one picture in the container then i can scroll the image, but i want my all the images to show properly...

i connect to MS-Access database in VB6 and use its tablse<br/>what`s the best Report manager that i use in my VB6 Projects<br/>can i call Reports that I saved in Access database?

how can i get Declaration of windows API Functions<br/>i want a software by this features:<br/>1- show list of existing Libraries for select one of them<br/>2- after select a Library, show list of it`s Functions<br/>3- After Function is Selected, show Declaration of selected function

hello everyone,<br/>i have got another strange problem. the problem is i have to use a picturebox as a container, but i can't put the controls at design time into the picturebox, controls will be added into the picturebox at Run Time. <br/>please guide me to this way.<br/>Real problem for me :(...

I have an ICO file in Resources, How do I refer to it?<br/>Me.Cursor = New Cursor(Image.ICO file Stored in Resources)

Hi,I have a problem when I try to build a solution. It shows me this error:Project 'ProName' could not be opened because the Microsoft Visual C# 2005 compiler could not be created. Please re-install Visual Studio.Does anyone have any ideas what might be the problem?Thenx...

Dear All..,PLs Read Below..i have to find the result of an equation. Equation will change time to time.The values for the variables in these equations are stored in 2 tables.same varibles is exixst in two tables..for eg:let equation as (FHRA/MD*PD)+IHRA+LHRA+HRAADJ+AHRA+ARRHRA .there are 2 table 1.E...

How to generate a crystal report depending on the selected item in a dropdownlist filled with values stored in a table from database?<br/>Note: I am using a vb code behind<br/>Thanks,

Hi,How to sum up the total of all the HOURS except 'ZZ' which should be summed up seperately.hope u got me.Example: (output should be as below).nadeem 5shyub 5ayub 5ZZirshad 5Reported Production Hours: 15 (nadeem + shyub + ayub)Reported NonProduction Hours: 5 (ZZirs...

Hi,Can anyone tell me how to rectifythis errorI have created a Dataset Connection from Web.Config and it have one SP . When I preview the sp it gives me the output . The same I have called in Crystal report .I have a Web Form where I have placed the crystal report viewer control , and necessary co...

Hi All,I have a MS Access Database which is Password protected I want to connect to this particular databaseCould u help me out how the connection string looks likeFor eg:I have given like thiscn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:\Share\UpServer\TMSServer.mdb; Pass...

My window has no border and the below code allows me to click on the window and drag it around. The problem is, Left/Right click on the form no longer works. Any ideas?'Place this code anywhere on your form code#Region " ClientAreaMove Handling "Const WM_NCHITTEST As Integer = &H84Const HTCLI...

When the report is loaded (it makes access to informix 10) inside Crystal Reports Server, the follow error has showed.Request timed outI've included the follow code on web.config on InfoView folder, but it didn't work.<httpRuntimeexecutionTimeout="N"/>Could anyone help me to solve th...

I am new to Crystal Reports, and I'm trying to create a multipage report. The first page is populated at the top and bottom with text and data fields. The middle portion is one large text box (with border) which could contain one or more pages of data.If the text box goes beyond what will fit o...

Whenever one of my users prints any of our reports, the date is in dd/mm/yyyy format, when it should be in mm/dd/yyyy format. This might be more of a Windows settings issue rather than a CR7 issue, but it only seems to do this when a CR7 report is printed, anything else involving a date in any othe...

I am new to vb.netI am trying to convert my application from vb 6.0 to vb.net. the conversion runs smoothly other than "vbUnicode" and "as any" errors. VB.net doesnt support these declarations. Is there any easy transformation?for instance can i rewrite this to work in vb.net?thanks varResult(1, iX)...

I have created a report in Crystal Reports 10 that is connect to an SQL Server 2005 database. I have used OLE DB (ADO).The problem is that i want now to connect this report to another database instead, using "Set Datasource Location" and is giving me the error:"Failed to open a rowset.Details:ADO Er...

hi all,<br/>i have to resize controls at run time but in the same way we resize at Design time, using the edges how is this possible.<br/>pls help

Hi,I need help setting a spreadsheet printing Range because when I print, after printing the area with data, it prints additional blank pages.So how can I set my print range from "A1" to the last cell that has data?Example:xlWksht.PageSetup.PrintArea = xlWksht.Range("A1:???").AddressNote: in the cod...

I've got two strings, filled with digits(seperated by spaces). Let's call them s1 and s2. I want to remove these digits from s1 that are already in s2. I hope i made myself clear, any help is appreciated :) Waiting for your ideas :)Example:s1 = "1 5 7 9"s2 = "1 9"result:s1 = "5 7"...

Hello,VS 2005 & SQL 2005I have a database field called signature and is an image datatype (binary data). I am trying to display that signature in a crystal reports.The signature has been displayed properly in the database as I can display the signature into a picture box using a memory stream. So I...

I have an MDI & MDI Child Forms in my project. I add an Form that having the ICons named 'background' form. this form is mdi child form also, now when user double click on the ICon of this form, the appropriate form will be open. I have no porb till now. At this point 2 mdi child forms are...

Hey guys! I want to print my DataReport directly to file, PRINTTOFILE, irrespective of the system's printer's settings.Upto now I had tried doing this: I set the printer's settings to FILE: port (manually) and then supply the filename to the "Print To File" dialog box (automatically t...

Hi,I'm working on VB.NET Express and SQL Server Express. I have a DataGridView control in the form, with 8 columns, of which one column, which has default values, is hidden and one column is already filled with default values. I want to populate the DataGridView with records that exists in the...

Sir,I am using CR 8.5 and VB 6.0 and Access 2003.my database fieldname are billno, billdt and month. DSN name of the database is - exppath of the database is C:\ks\exp.mdbPl tell me how to prepare report in Crystal Report using the above database. Further I have placed one text box and one command b...

Dear All, I am using the crystal report X1. I that while generating report the output format we are using only PDF format. So in that PDF format how to set the "Enable Fast Web View in a PDF" this option. I don't want to wait untill entire report will get generate page wise i would can displ...

Hello everyone!How can I make a Treeview which lists all the subfolders inside all subfolders (similar to windows explorer), but with all the subfolders' files inside the treeview?I do not want to show it in a listview, all the folders and files must be shown in the treeview.Can anyone help?...

I have just got into university and they have the network set up that I need to login (not the windows login but a web based login) each time I start up my computer in order have any application access the Internet.What I am wanting to do is create a program to automate the login process (easy enoug...

Hi peopleI am using the macro below to create a running total for a cell each row of a spreadsheet. I need the code to add the value of the cell next door to the running total too. The code is: Sub RunningTotal() On Error GoTo errorhandler ' Skip cells that have no comment. With...

Hi all,<br/> <br/>I want to connect to an Excel File in VB.NEt could anyone help me out<br/>Thanks in Advance..

Im currently modifying a small logic inside an existing DLL (VB 6.0) . I have an executable to test the Dlls execution. Im trying to step into the Dll code. I tried opening the Dll project and the test exe project in 2 different IDE and trying to set break points in them so that I can step through....

Is there any way to connect to a database and find out the name of every table in that database?<br/>Note: I don't want to return any data from any of the tables, I only want the table names themself. Google was no help. :(

I have a view I am using which looks at a table and basically only shows rows where userID = suser_sname(). There is a recNum column with an identity auto incrementing by 1. This is all on the SQL server side of course, but when I create a data source and a grid in vb.net 2005, the auto incrementa...

Having hunted this forum and the whole of Microsoft, I cant find how to change the Column format in Excel under VB6 program controlMy problem is when passing data to Excel using VB6, the columns are in General format, which means that when transferring MONEY fields to the cells, 150.00 becomes 150 1...

My database is dynamic; that is, the files are updated constantly. I want to create a report which captures data at ten am every day, day-by-day, to allow for comparisons daily comparisons as weeks and months go by. I created a crosstab which catches all the data needed for the first day in a single...

I have a CR that I have published with visual studio 2005.Everything looks fine locally.My problem.When i select an item on the tree which I am grouping by the page posts back and scrolls back to the top of the tree. This becomes kind of annoying when trying to drill down in a report and have to sc...

hi all,<br/>As we use Stretch property with Image1, i want to use the same property with Picture1 but not available in the Picture1's properties. :(

Hi peopleI am trying to open an excel file that has got a macro in it that calculates a running total for me. Trouble is that the file is shared so that more than 1 person can edit it at a time and this disables macros.Does anyone know how to open the file and also automatically enable macros as the...

I have to make a report that prints letters for individuals or groups.I have a table with letters and id_letter, another with groups and another with the data of the contact. The querys work ok.The letter field is "memo" in access.I have no problem when the body of the letter it it is 1 page long, b...

Hey Guys,I was wondering if anyone could help me with the Bug that I'm running into. I'll give some background before I go into it. I'm developing an Windows App using WinForms in VS2005 and Crystal 11 Release 2. I'm referencing all the latest Crystal dlls from the Service Pack 2...

I am having problems reading txt files more than about 1800 lines long, files are not even 1 meg files.Code: Open openfname For Input As #1 Text1.Text = Input$(LOF(1), #1) Edit = openfname frmMain.Caption = Edit & " - P_Editor" s = False openfname = vbNullString Close #1what a...

I'll get it nevermind

does any know how to read a data in a an excel cell then display it in a text box..please help me

hi, i'm follwoing code for sorting data after clicking on a fixed row's columnif grid.mouserow=0 then grid.row=1 grid.rowsel=grid.rows-1 grid.colsel=grid.cols-1 grid.sort=1endifthis works perfectly well except on columns containing dates. Pls help me why it is not working o...

hi,how to map hard disk serial number and or motherboard serial number through vb ?how and where to use it in such a way that once the appln is installed on a particular system, it sholud check for hard disk serial number and or mother board serial number if the same CD is put to installation for th...

hello all,<br/>what is the procedure of knowing how many controls are placed in the PictureBox and what type of controls are place inside it.<br/>Thank You