Recent content by hodgesp

How can I pass the value of session("oRpt").SQLQueryString = selectstring into a crystal variable that I can display on the report? I'm using Crystal version 9.

Bummer, that didn't do it. The problem is that the sql statement or ASP variable select string which I use to query the database is a virtual variable and doesn't correspond to any database table field object. I need to pass the value of this session("oRpt").SQLQueryString = selectstring...

What I'm trying to do is use the sql statement in a variable in crystal to display the selection criteria in plain english so I can display it in the report header. That way management will know what the report is displaying. (rememeber they need all the help they can get) Just for end-user...

I have an asp page that I use to define a sql statement that I pass to a crystal report via the SmartViewerActiveX.asp on another page. The report works fine and responds correctly, displaying the data based on the selection criteria I input. The fields pick up the correct data elements and...

Could you be more specific please. I assume that window.opener is javascript. I'm not very knowledgeable about that language as yet. Thank you....

I have an ASP page form that will be used for data entry. I am redoing a MS-Access Runtime application that has been used for a few years. One of the issues; "What to do about the conditional visibility code" I had set on several of my Form objects. What happens is, based on what value the...

I have an ASP form that end-users will be useing to update a SQL 2000 database. It is an upgrade to an MS-Access dtabase frontednd that I built using VBA. The problem I have is that I need to get users to fill out specific data elements based on values within other data elements. For example if...

Yes, this of course is true. By most standards it is bad programming practice but only because it was over-used, not because the construct itself was inefficient. That is why the term "Spaghetti Code" was coined. However, in moderation, I still believe that it can be used. It was the simplest...

I didn't know people would freak out like this to a simple question. I am a newbe to ASP, trying to teach myself, and I was trying to convert an old MS-Access application that has a SQL back-end and a MS-Access front end to web based. I was trying to follow the same logic. Maybe it isn't what...

I have a user input page that constructs a SQL statement and sends it to a Crystal Report Viewer. The problem is that if a user selects a record by its main key field "Track Number" no other criteria need be selected, and I would like to go ahead and send the request to the report without any...

Well this is even Stranger! The issue is finally resolved [shocked]. It had to do with a MoreRequiredSteps.asp file. For some reason the copy I had didn't seem to function correctly. I mean obviously something worked to allow the report to be generated. But when I garnered another copy of the...

You were right about the field! I was supposed to be using {tblComView.TrkgNumber}= 9542 NOT {tblComMain.TrkgNumber}= 9542. When I modified the field name I got the report page to display. However it Still ignored the criteria. I still think it has something to do with the fact that I...

Even when I hardcode the value I get the error: Error in formula Record_Selection>. '{tblComMain.TrkgNumber}= 9542' This field name is not known. (the single ' is displayed in the error this is my exact Code:) TN= Request.Form("TrkgNumber") recordSelection = "{tblComMain.TrkgNumber}=" & TN...

I get errors: Error in formula <Record_Selection>. '{wippcts2000.Trkgnumber}=2000' This field name is not known. Or page cannot be displayed ---------------------------------------------------------- When I restored my original code the report displayed but the same issue returned. The...

I have an ASP page that successfully passes values to the page that has the crystal report viewer within it. My connection is fine becuase the report returns all the records in the view that the report was designed around. However the code: Path = Request.ServerVariables("PATH_TRANSLATED")...