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 TouchToneTommy 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: *

  • Users: datenis
  • Content: Threads
  • Order by date
  1. datenis

    Using one parameter to search on multiple fields

    Hi, I've got a parameter that I would like to use to search on multiple fields instead of using one parameter per field. The problem is that when I set the selection formula to Parameter = A.Field or B.Field or C.Field then I get A x B number of records returned. I have a grouping on...
  2. datenis

    Crystal Reports Server Parameters bypass parmeter screen

    Hi, I downloaded a trial version of CR server, and when I upload my reports to the server it prompts for a parameter value before actually generating the data for the report. I don't get this prompt if I run one of the reports in the sample folders. If I make a copy of the report from the...
  3. datenis

    Interactive Parameters - CR XI and CR Server 2008

    Hi, I've downloaded a CR Server trial and uploaded some of my own reports written in XI. They generate properly, but when I click on the parameters panel on the side no fields are displayed, while the sample reports the parameters show up properly. Is there a way make the parameters show up...
  4. datenis

    No Such Table or Object Error

    I want to connect to one of our client's machine using psql CC 8.7. First I tried to connect directly to the ddfs on the server, and I get this error: The Btrieve file directory is invalid[betrieve Error 35] I made sure that the user had read/write/delete access on the directory. No luck...
  5. datenis

    Charts - Nnumbers from complex foruma not displaying

    Hi, I have a report where the chart is based on the sum of a number from the group divided by a second number, for example the formula of formula field A would look like this: (SUM(YTDSALES,GROUP1)/X) When I try to generate a bar chart using this number, forumula field A is not displayed on...
  6. datenis

    Trendlines Missing on Chart

    Hi, I have a line chart and if I click on the "Show Numeric Scale" Under Chart Options -> Grid -> Group Axis -> General, the underlying trendline will not be displayed. How do I fix this issue? I'm using CR 10 Thanks in advance.
  7. datenis

    Charts - Number Formatting on X-Axis

    Hi, I have 2 problems. I'm using CR 10. 1. The X-Axis on the chart is based on a formula which returns a number. When the chart is displayed, 2 decimal places appear for each item on the X-Axis. I've tried to get rid of the decimal places by using Truncate(x), setting the number format on...
  8. datenis

    Crosstab: Grand Total Based Top N

    Hi, I'm using Top N for my Crosstab, and I'd like to sum the column totals based only from the top N rows, instead of all rows, how do I do this? Thanks. D
  9. datenis

    Crosstabs: Group sort on columns

    Hi, Is it possible to Group Sort on columns? Specifically, I'd like to filter for Top N, just like what can be done on the rows. Thanks.
  10. datenis

    OLEDB exception

    I'm using C# in VS 2005 and trying to create a OLEDB connection to a pervasive database. I'm using remote desktop connection to run the code in debug mode. On my connection.open call I get an exception that says PS_MSG_N4827 My connection string looks like this: "Provider=PervasiveOLEDB;Data...
  11. datenis

    ADODB Problems

    I'm using ADODB to connect to PSQL 2000. I'm using VS 2005 and C# to do this. I'm trying to add the pervaisve connectivity to some existing code. For ADODB, I'd just add the reference and then I'd thought it should work after calling the below code: ADODB.Connection cnBV = new...
  12. datenis

    Unable to remotely connect to SQL Server 2005

    I have problems connecting remotely to SQL Server 2005 on a Win 2003 server using ODBC connections. I've followed all the steps on the MS KB here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 I went to the SQL Server Configuration Manger and made sure TCP/IP is enabled...
  13. datenis

    The database DLL 'crdb_p2bbtrv.dll' could not be loaded.

    Please give me some help on this. Whenever I try to call the ExportToDisk function on Crystal Reports in .Net with a connection to a Pervasive ODBC datasource I get the above error. I'm running Visual Studios 2005 + CR 10 I have the Pervasive engine installed. I tried to place the...
  14. datenis

    Cannot Debug dll in VS 2005

    I have a project in VS 2005 that was upgraded from VS 2003 that builds into a dll. When I start the debugger it would stop right away, and it does not step into any code. Any suggestions why this is happening?
  15. datenis

    Refresh Report Error: VB .net + CR + Pervasive

    I get this error if I refresh the report programatically or manually in the crystal report viewer in my app: "Failed to load database information. Details: The database DLL 'crdb_p2bbtrv.dll' could not be loaded. Error in File <FileName>:Failed to load database information." I'm using Visual...
  16. datenis

    CR - Viewer not updating properly

    I have an app with mutiple tabs and on each tab there is a cr report viewer. The first time I load the viewers they are displayed properly. However, if I change the report parameter and reload the reports then the report viewer that is in focus will display the report properly. If I click on...
  17. datenis

    CR Viewer: Show as percentage fields not displaying properly

    I have a field in a crystal report that is to be shown as a percentage of a Sum on a group. I can preview this field in the Crystal Reports 10 app without error. However if I run the same report using the crystal report viewer in VB.net, the same field will be displayed as blank in the report...
  18. datenis

    Crystal Reports Viewer error

    I get this error whenever I refresh the report viewer built in vb.net: The database driver used y this report is not supported by this product." The tables that this report references from spans MSSQL and Pervasive SQL
  19. datenis

    Exporting Binary Data from MSSQL to MySQL

    I have a MSSQL table with Primary Keys, Company_Id, set as a binary value. I used the dts Transform Data Task and to create a new table in MySQL. The default create code comes up with: CREATE TABLE `New Table` ( `Web_Edited` tinyint unsigned NULL, `Company_Id` date NOT NULL...
  20. datenis

    Problem with insert trigger

    I've created an insert trigger that works if I add records manually using PCC. But when I use our accounting app to insert a new record in the same table the trigger doesn't fire. Thoughts?

Part and Inventory Search

Back
Top