Search results for query: *

Thanks Hypetia - it works and actualy i was using the topindex property at a liitle wrong place - which i figured out later- so it worked too.but ur code saved my 3 lines. Anyway now i have another simple problem thati am not able to get he current selected record number in the listbox- is there...

Hi I have a list box ,data coming from table and i need to select a default value in that.the Value does get highlighted but the listbox can show only 3 items at a time and if it is 5th or 6th or even more ..item then i have to scroll downmyself to see the selectde item.I need to directly...

Thanks Paul and Golom - for ur help .I will try both solutions and hopefully get my work done. sidanshu

hi Experts there, I am just trying to disable/enable the minimise button through code and use the property - Me.Minbutton = true and get the error msg Either Function is restricted or it uses an automation type not supported by VB. Well if it works through properties box then what is the...

Thanks Arvind for the reply. The way i solved the problem was to refresh the data environment everytime the report was opened ( instead of refreshing the report only) and that solved the purpose and i think by assigning again the dataenv to report would do the same. So anyway thanks again. Anshu

Actually my problem is not to suppress the blank lines but - blank columns and then the column to the right of suppressed column should move to left to fill up the space(if possible).what i have now(as guided by ken is as follows) col1 col2 col3 |---------------------...

hi ken.. another question i have about your reply to Q1) above is that how do i format my fields now to diplay inone line if they have value- by making subsections - the filds are moved to new section so they don't line up.i am also not much experienced in CRs so please help. Thanks Anshu

Thanks for the help. Yes the problem was selection formula stil had the previous value for the second report and so that caused the problem.Because i din't need any selection formula for second one so i did nothing to it- but i had ti initialize it to "" atleast.Now it works fine...

hi Gabi Try the site msdn.microsoft.com and search for "crystal reports and vb" you may get some help. Anshu

I am facing a strange situation .I have two option buttons on my vb form - that do following 1.opens a crystal report with all predefined parameters 2 had suboptions to select some of the parameters only and - the parameters selected are displayed on report. now if i first select option(2) - it...

hi yputopia to Refresh your data report before showing it you have to refresh your connection object or you can just unload and load your data environment before showing the report.e.g. use Unload DEtempdb 'detempdb is ur dataenvironment name Load detempdb dbreport_cust.Refresh or...

....continuing the above answer, if you want to process each record in any way , right after rs.open.... you can say rs.movefirst for intctr = 1 to rs.recordcount 'get the fields of firstrecrd say last name strtemp = rs!lastname -------- ----- rs.movenext next intctr I...

I have a situation when i want to insert some selected columns in the database. Talking about one column, i have the column name and its value stored in two variable say strcolnames = strcolnames + ", city_name" and its value stored in a variable , say strcolvalue now to make my sql i...

You may get some ideas from the link... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbconaddingcalculatedfieldtodatareport.asp

I have a data report with some pictures(Company symbols) and i want to send it as softcopy to my manager.so if i export it and save it- all formatting and pictures are lost.How can i save it as a file in same format as it looks. Thanks in Advance. Anshu

Just refresh your database connection.try loading and unloading it or close an dopen it.It will definitely give you the latest results. Anshu

Try to find something in thread- VB Data report designner- posted by sam13 with 26 responses- last replied on yesterday- so you should see it easily, hope you can find something there. Anshu

hi Inder, with all the field you must be getting the column names as weel which you can drag anywhere in the detailed section- change font/style or even add you own new text buttons from controls of data report- to make additional headings/labels. Is that what you needed... Anshu

hi IF you are not using this way- try it. Create a data envirinment- make connection, create your command- selecting all tables and fields .Open both the data environment(as small window) and empty data report and then drag that command onto the report's detail section.that way all your fields...

Try using the statement "resume next " after your msgbox in errorCheck .Actually it does go to the errorCheck flag and shows you the error message no as you want - but afterthat you need to tell it to skip that error. hope it works Anshu