Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. taranis

    Blank window when expoting a report to a web page

    I am not using the smart viewr. I am exporting to pdf, word and excel and opening the file in a browser windo. The files get created fine on the server but cannot be viewed by some users
  2. taranis

    Blank window when expoting a report to a web page

    I have this exact problem that you describe. Blank report showing when trying to display an exported report. I was wondering if you ever found a solution
  3. taranis

    Crystal Viewer does not download

    I am using the Crystal Viewer that comes with version 8.5. The viewer works fine on my development machine when I access reports from the webserver. The problem is that when another client attempts to run reports that does not has crystal installed the ActiveX Viewer does not download. I...
  4. taranis

    blank file when attempting to export to pdf

    I am exporting a report to a pdf format using ASP. The coding works fine and creates the report on the server. However when I redirect to the pdf file it shows up blank. When I open the file from the server it appears fine. So I no that the export functionality is working fine. I tried...
  5. taranis

    Generating pdf file from crystal report

    No - you can only export to pdf in version 8.5. Crystal has a patch for 8.0 that supports pdf but it is not stable. I would not suggest using it
  6. taranis

    Changing format for individual rows in a Form

    I would like certain values in a FORM to show up in a different format (i.e BOLD) depending on values in another table. I am viewing the form in tabular format. First of all can I do this? It seems that all of the formatting properties apply to the whole column when I only want the format to...
  7. taranis

    Help! Need help with passing the password

    Here is a code example that connects to an Access 2000 database that has a password. Note the "OLEDB:Database Password" tag. This is how you pass in the database password dim g_adoDatabase as ADOD.Connection g_adoDatabase.CursorLocation = adUseServer g_adoDatabase.Open...
  8. taranis

    How to open "Select New Data Source" using ADO

    I am tryin to open the "Select New Data Source" Dialog using ADO. I want the user to be able to select from all the ODBC connections available and to be able to add a new one when attempting to open an ADO connection. This was very easy to do when using the OpenDatabase method under...
  9. taranis

    Suppress Tool tip text in CR8 report designer Component

    The above does not work for tool tips. To eliminate the tooltip the only way I found is to select a report object in the designer, right click on format..., goto the common tab and select the formula button next to the tooltip. Insert a "chr(9)" without quotes as the formula. Do...
  10. taranis

    Problem Changing Data Source at runtime for Crystal Report

    As you suggested, I had to create the report from scratch using the VB6 designer then there was no problem. Thanks for your help
  11. taranis

    Problem Changing Data Source at runtime for Crystal Report

    its an old report held over from version 6, so I dont think it was designed with the active driver. Can I easily convert it ovrer to use the active driver?
  12. taranis

    Problem Changing Data Source at runtime for Crystal Report

    I'm using VB6 and Crystal 8 and Access 97 to display a report. I want to change the data source at runtime. When I try to do this I get the following error "Data Source name too long". I changed the path and name of the Data Suurce name so that it was 8 characters long and I still...
  13. taranis

    Problem Changing Data Source at runtime for Crystal Report

    I'm using VB6 and Crystal 8 to display a report. I want to change the data source at runtime. When I try to do this I get the following error "Data Source name too long". I changed the path and name of the Data Suurce name so that it was 8 characters long and I still get the same...
  14. taranis

    Can you update the record source through VB

    all you have to do is create an ADO rs containing the result set for the Query of interest and set it to the recordset property of the data control. Then you have to refresh the datacontrol. Assuming you have a grid connected to the data control, it will display the new results. Set...
  15. taranis

    Distributing an MDB with the VB app

    It depends if your users need to open Access 97 to admin the database. If not then you do not need the Access 97 app to be installed and therefore do not need a license. Data access is handled by the DAO runtime libraries which you can install with your VB App. If you need to have users...
  16. taranis

    Datagrid not showing recordset

    You have to include the reference to the "Microsoft Data Binding Collection" in the project. If you are having the problem only after distribution and installation on a client machine then insure that you are including the msBind.dll in the installer.
  17. taranis

    Recordset returned from Stored Proc has no recordcount

    NEVER MIND, The problem was simple I forgot to set the connection to use a client side cursor
  18. taranis

    Recordset returned from Stored Proc has no recordcount

    I am running a stored proc that is returning a recordset. I want to send the recordset to a grid. The problem is that the recordset gets returned as a dynamic cursor with recordset property set to -1. I want to return the rs as readonly static so that I can set the grid recordset property to...
  19. taranis

    communication between VB6 and SQLserver2000 with XML

    ADO 2.5 offers the feature to save a recordset to a XML file format. I believe it is the SAVE method of the recordset object.
  20. taranis

    SetFocus

    You cannot use the SetFocus method at all in a Form_Load because no controls are loaded yet. You must use the Tab Order to accomplish this.

Part and Inventory Search

Back
Top