Search results for query: *

Hello, I have a VB6 form with a DataCombo control. My database is in SQL Server 2000. For the client receiving the error, the DataCombo is filled with 267 items. If the client selects an item, or uses the scroll bar to view the list, there is not a problem. Same with using down arrow or...

synapsevampire - That worked like a charm.... It never crossed my mind that Crystal was now seeing it as a memo field. Thanks so much for your quick response! Jolynn :-)

All, I have a report in Crystal 8.5 that displays data from a SQL 2000 stored procedure by passing in parameters to the SQL server. This report has been working fine for several months. The stored proc passes back Name, Address, etc. to print on the report. This report is mailed by our...

Rob2k2, If I remember correctly (it has been a long time!), I was missing a component in my Install Shield project. I added cselexpt.ocx to my install package and once I deployed to other machines, my select expert button appeared correctly. Good luck! Jolynn

Craig, Thanks for the response. I tried adding extra spaces at the end of my text and that didn't work. If I can't get the listview to work, I may just use a tree view w/ checkboxes and align all my nodes to the left. Any other suggestions? Thanks! Jolynn

Hello! I am using a listview control with checkboxes to display a list of items the user can check or uncheck. The properties of my listview are set as follows: View = 2 - lvwList Arrange = 0 - lvwNone LabelEdit = 1 - lvwManual BorderStyle = 1 - ccFixedSingle Appearance = 1 - cc3D OLEDragMode...

Hello, I am using the CRViewer in VB6 against SQL Server. I am accessing the database using OLE DB. (Crystal Reports 8.5) The CRViewer has a Select Expert button which displays fine on the development boxes. The problem: When installed on client machines, the Select Expert button does not...

Hello, I am using the CRViewer in VB6 against SQL Server. (Crystal Reports 8.5) The CRViewer has a Select Expert button which displays fine on the development boxes. The problem: When installed on client machines, the Select Expert button does not appear! I even have code in Form_Activate...

Hello, I am using Crystal 8.5, SQL server and VB 6. I have several reports included with our program loaded at client sites. We have no problems running the reports on our end. But, out clients get a "Server has not yet been opened." error. I know it is occurring for at least a...

jpc - Yep, Report1 was my CRAXDRT.Report set at form level. (I use this form for all my reports, passing in specific info I need). The problem I was getting was with: strSubreportObjName = objSubreportObj.Name objSubreportObj.Name held a generic name that crystal assigned. i.e...

jpc - Stepping through that code, it seems that my Set sRpt = mCrystalReport.OpenSubreport(sRptName) statement is not working. When I query ? sRpt Is Nothing, it returns true. The following is what code I have adapted according to what you gave above. Did I miss something??? Thanks! Jolynn...

Okay, never mind the error... I am back to my problem in my first post. Although I included the code jpc provided and am using SetLogOnInfo to logon the main and all the subreports, it is still not getting the correct data. Any other ideas??? Jolynn

jpc - The code was helpful, thanks. I now am logging on any subreports in each section of my report. BUT... I can't tell you if this works or not because I am getting a new error! A Crystal Reports: Database Error - Column number out of range. Clicking OK on this then brings up two more...

Chelseatech, We are using OLEDB to connect to our SQL server. Is there some additional VB code I am inadvertantly omitting?? What do I need to do to pass each separate connection for the subreports?? Thanks! Jolynn

Help!!! I use Crystal 8.5 and VB 6.0 I have a report that uses a stored procedure for the main portion. I have about 17 sub-reports that are linked to data from this main stored procedure. Upon creating all of my reports, I follow the standard of doing a "Set Location" and removing...

chelseatech, Thanks for the tips... one half-way worked! 1a.) The "Suppress printing if No Records" in the sub-report doesn't work because there may be records although none are printed! Remember, I am suppressing detail lines based on certain criteria. The lines that ARE NOT...

Does anyone know of a way to evaluate a field in the sub-report from the main report? Or to possibly pass that field back as a parameter? Here is my problem: Running CR8.5, VB6, SQL server database I have a sub-report that may or may not display data. I evaluate (and suppress if necessary)...

You can break the section into subsections and do the suppressing formula for each subsection (not entire section). For example - your Details section could have Detail subsection a and Detail subsection b. Show subsection a and suppress subsection b if they want a summary and put only a...

Sorry, I cannot actually help you, but just want to let you know that I use CR 8.5 and have a report that has 5 groups and 16 subreports. Each subreport has linked parameters (3, 4 or 5) to the main report. This has been working fine. So... maybe you need to upgrade from CR 6! (No guarantee...

Can you draw the box in paint or something and save it as a bitmap? Then, you could insert the bitmap into your report design. Right click on the bitmap, go to Format Graphic. Click on the formula button to the right of Suppress check box on the Common tab. Enter this formula: {table1.item}...