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 Mike Lewis 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. majordog

    Consuming a vb.net web service from vb 6.0 app

    Good Day All, I would like to be able to consume a web service I have written and deployed to the web server from a vb 6.0 application. Any direction would be much appreciated .. TIA
  2. majordog

    SubTotoal of field per year

    Perhaps I'm approaching this wrong.. any help would be appreciated .. I've tried something like this: SELECT Veh_Year, NoPlateType AS LDV, NoPlateType AS LDT, COUNT(NoPlateType) AS SubTotal FROM dbo.AUG15_PM_RSD WHERE (NoPlateType = 'LDV') OR (NoPlateType...
  3. majordog

    SubTotoal of field per year

    That: SELECT Veh_Year, COUNT(NoPlateType) FROM dbo.AUG13_PM_RSD WHERE NoPlateType = 'LDV' OR NoPlateType = 'LDT' GROUP BY Veh_Year Gives me this as a result: Veh_Year (No column Name) NULL 583 I want it to display: Veh_Year LDV LDT 1975 2 3 1976 4 5
  4. majordog

    SubTotoal of field per year

    Hey All, I have a question concerning a query I am trying to write; I have a table with years and types SELECT Veh_Year, COUNT(NoPlateType)AS COUNT FROM dbo.AUG13_PM_RSD GROUP BY Veh_Year, NoPlateType WITH CUBE What i want to do is get how many "reds" subtotoal were for each...
  5. majordog

    Load Report Failed - Logon failed

    All my reports, I logged onto the database with a report only user - user name and no password. That way I didn't have to programmically log onto the database every time I launched a report. Also, if this is not your problem - really verify what values you are using for the report path...
  6. majordog

    Response.Redirect not opening local file

    I am still having problems with redirecting the page to a file stored locally on the web server. Can anybody tell me what the best approach would be to allow users to view these reports as clients. Using the exact path just results in a "web page cannot be found" error message. If you follow...
  7. majordog

    Response.Redirect not opening local file

    Hey All, What I am trying to do works fine on my development machine. When I move it to the server however, it does not work. Maybe you can explain what I'm missing. I am storing a path ie: "C:\inetpub\.....\portable.doc" in a Session variable. I then launch a new browser window on a custom...
  8. majordog

    File.copyTo problems

    Hey All, Working with VB.net, writing a windows service that monitors the folder activity on a share drive. When a text file is dropped into the folder, the file is copied and moved to a private directory on the local drive. I am having problems with copying the file over to the local drive...
  9. majordog

    Exporting cr 9 results in "Error in file" - ??

    I'm looking for some help understanding why these crystal report 9 files will not export. I have gone over the code and am confident that it is correct, albeit, perhaps I am missing a step I am unaware of (I will post below). Regardless, when I hit the oRpt.Export - I always get an error...
  10. majordog

    cr 9 .rpt file export programmically not working - help!?

    I am still unable to perform the export and am wondering if anybody has some example code of using the reportappserver to run,view and export using the CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocument ?? Any help would really be appreciated1
  11. majordog

    cr 9 .rpt file export programmically not working - help!?

    Hey All, I have reports written in crystal v9 that I am running from web app using vb.net. Whenever I try and export, I get this error message: Error in File C:\path\file.rpt Operation not yet implemented If I place a watch on it I see that the value of the report document on the line of code...
  12. majordog

    Formatting question cr 9

    Thanks a lot everyone - your suggestions helped me solve this. Big Thanks!!
  13. majordog

    Formatting question cr 9

    Thanks for your reply: No to any unused space NOT being suppressed - I verified each of them and the property settings are not enabled for either "New Page Before" or "New Page After". I have been wondering if the size of the sub-report and remaining space on a page is the problem. If the...
  14. majordog

    Formatting question cr 9

    Hey All, I have a report with about six or seven sub-reports within it. Here's the thing, when I print, I end up with 7 pages for somehting that could fit on 3. I end up with blank space at the end of the page after each sub-report and the next sub report doesn't begin until the new next...
  15. majordog

    report document export error - ?

    Hey All, I am stumped - I try to export a report document to any format like .pdf, .xls, .doc, .rtf and I consistently get the error: Error in File C:\..\reportname.rpt: Operation not yet implemented If I look at the line in debugger, with a watch, the value is: Run-time exception...
  16. majordog

    Report Document export was working now not??

    Hey All, I was using crystal v8.5, then switched to v9. Code has not changed and yet I get this error message now when i try to export to another format: Run-time exception thrown: System.NotSupportedException. Error in file c:\inetpub\wwwroot\foldername\reportname.rpt: Operation not yet...
  17. majordog

    Easy Excel selecting range question

    Hey All, I run this code: Windows("EC1997-002 031904 calc1.xls").Activate Windows("03190930.04").Activate Windows("03190935.04").Activate Windows("03190940.04").Activate Windows("03190945.04").Activate Windows("03190950.04").Activate Windows("03190955.04").Activate...
  18. majordog

    trying to launch launch .pdf and word docs from web app

    Thank you, yes, that helped tremendously. Such a simple thing, just needed someone to point me in the right direction. Thanks
  19. majordog

    trying to launch launch .pdf and word docs from web app

    Hey All, Hoping someone can give me a helping hand. I think I am on the right track but not sure. I have a reporting web site, ASP.Net and VB.Net (VS 2003) I export the reports to .pdf, .rpt and .doc files. This all works fine. However, when I try and launch these files I get nothing. I...

Part and Inventory Search

Back
Top