Recent content by majordog

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

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...

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

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...

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...

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...

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...

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...

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...

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

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...

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

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...

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...

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...