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!

Register Log in
  • Congratulations Rhinorhino 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. crystalReporterNew

    Stored procedure IN Clause variable list

    Hi, I need a way to write the following query: The problem is that I pass a variable sized Comma separated list of Strings that I need to include in the IN clause of the query.The @RepList variable will look like '5674','2345','3455'.... and so on. However if I pass that as @RepList as a string...
  2. crystalReporterNew

    indexing on 2 fields

    Hi, Is there any way I can create an index which indexes on field1 OR field2? (As opposed to a composite index which indexes like AND on both fields in the order specified?)
  3. crystalReporterNew

    stored procedure slow

    Hi, I have a simple SELECT query in SQL(with a LIKE clause in it) that runs very fast if called natively on the database prompt.It also runs equally fast as a stored procedure,however, after a long period of DB shutdown or logging off from the server and logging back in again the stored...
  4. crystalReporterNew

    BHO does not run in limited account

    Hi, I am installing a BHO on the computer and deploy it as a dll which registers itself in the administrative account. It runs perfectly fine in the administrative account. However, when I switch to the limited account, the BHO just does not run.I tried some other dlls for toolbars etc and they...
  5. crystalReporterNew

    regsvr32 doesnt work in limited account

    Hi, I am using a project that generates a BHO for IE and I need to register the dll in order to make it work.It works perfectly fine on a normal windows XP system in any administrator account by simply doing a "regsvr32 dllname.dll" in the appropriate location, namely C:\ ...however on the...
  6. crystalReporterNew

    Convert TCHAR to wchar_t

    Hi, How can I convert from TCHAR to wchar_t ? Can someone please tell me? Thanks
  7. crystalReporterNew

    Convert TCHAR to char

    Hi, Can someone tell me how to convert a TCHAR string to char?? Thanks!
  8. crystalReporterNew

    Convert TCHAR to char

    Hi, I want to convert a TCHAR string to char . How can I do it? Thanks
  9. crystalReporterNew

    Capturing the New Window Event in a BHO??

    Hi, I have a BHO which captures all kinds of events, including new windows such as those fired by pop ups, right-clicking on a link ans selectiing open in a new window etc. This is captured by the DISPID_NEWWINDOW2 event. What is the corresponding function for a window opened with Ctrl + N, or...
  10. crystalReporterNew

    Unknown query engine error with crystal reports

    Hi, I am using crystal reports with VB.NET. I get the data from a MYSQL database thru a select statement and set the datasource in the crystal report viewer and do a form show in the end.It gives me an "Unkown query engine error" at runtime. Everything is correct including the results...
  11. crystalReporterNew

    Caching crystal reports? - is it possible?

    Hi, I am wondering if it is possible to create a crystal report and save it on the disk, and then later retrieve the same report and view it in the crystal report viewer. I know I can save it as pdf etc but I dont want to do that. I have saved it as a .rpt file on my local machine but when I...
  12. crystalReporterNew

    Using SQLConfigDataSource in VB.NET doesnt work for MS text Driver

    Hi, I am trying to set up a DSN for Microsoft text driver. If I write the following code, I get the error that DSN entry Failed: intret = SQLConfigDataSource(0&, ODBC_ADD_DSN, "Microsoft Text Driver(*.txt,*.csv)", "DSN=AppliedEDSN") If intret Then...
  13. crystalReporterNew

    Sprintf function in VB.NET

    Can someone point me out to compiling code for the Sprintf function in VB .NET? Thanks
  14. crystalReporterNew

    Setting up DSN programatically in VB gives error

    Hi, I have been getting a System.NullReferenceException with the SQLConfigDataSource function. Can somebody please help? The following is the code: Public Declare Function SQLCreateDataSource Lib "odbccp32.dll" (ByVal hwnd&, ByVal lpszDS$) As Boolean Public Declare...
  15. crystalReporterNew

    Setting up DSN programatically in VB gives error

    Hi, I have been getting a System.NullReferenceException with the SQLConfigDataSource function. Can somebody please help? The following is the code: Public Declare Function SQLCreateDataSource Lib "odbccp32.dll" (ByVal hwnd&, ByVal lpszDS$) As Boolean Public Declare...
  16. crystalReporterNew

    Graphs changing at run time

    Hello I have inserted a graph as a bar chart in my crystal report but want it to change into say a pie chart or a line chart depending on certain conditions at run time. Instead of making different crystal reports for that can I make the change in my VB program that sets the graphtype as what I...
  17. crystalReporterNew

    Dynamically changing graph types in crystal reports

    Hi, I have inserted a graph as a bar chart in my crystal report but want it to change into say a pie chart or a line chart depending on certain conditions at run time. Instead of making different crystal reports for that can I make the change in my VB program that sets the graphtype as what I...

Part and Inventory Search

Back
Top