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 strongm 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: IainK
  • Order by date
  1. IainK

    Connection problems

    Hello there! I am using ASP script imbedded in an html page to access data from an Oracle database. As of right now the pages don't seem to load up, and instead I get a pop-up window telling me: "Out of virtual memory" and then one that says "the memory could not be 'read'...
  2. IainK

    writing queries

    I have pasted my sql into CR SQL designer and saved it as a QRY file - however I am still having the same problem. - Iain
  3. IainK

    writing queries

    After selecting 'query' in the 'standrd report expert' I get a 'file open' window to select my .sql file as I described in my last post. However, after selecting it and clicking 'open' I still get a new window popping up immedietly, as described in 'step 4'. Any idea why this might be...
  4. IainK

    writing queries

    ...to do as you suggested and run a report against the qry file I saved. I am doing the following and having some problems. 1) Create new report - *Standard* 2) 'Standard Report Designer' - select *query* 3) 'File Open' - select the qry file - click *open* 4) 'Choose new location' - when I...
  5. IainK

    writing queries

    I have a set of sql queries that were written for microsoft excel. I want to use these same queries inside a crystal report - but when I copy/paste the query into the 'sql expression editor' it finds errors. I have cpy/pasted the exact same query into Crystal SQL Designer - and it worked fine...
  6. IainK

    queries in Crystal Reports

    Hello all! I am running crystal reports 7 and am trying to insert subreports. I have created sql queries using Crystal SQL Designer, and want to use them in my sub-reports. When inside my report, I select "Insert Subreport". I then get a box where i create the sub-report name. Upon...
  7. IainK

    sql into reports

    LOL - Nevermind - I noticed a blatantly obvious option for a 'query' instead of the 'sql/odbc'! When I select the appropriate .sql file and click 'open' a new window comes up called 'choose new location'. what does this mean? When I click 'open' in this window it dissapears and nothing happens...
  8. IainK

    sql into reports

    The sql query is already written and saved as a .sql file. From inside crystal reports I tried to insert a subreport: Insert | Sub report. The only option I thought you meant inside the Subreport Expert was the 'sql/odbc' option. Upon selecting that and choosing the table, how do I use the...
  9. IainK

    sql into reports

    Hello all! I am running Crystal Reports version 7. I have used crystal sql designer to import and sql query from excel. I saved it as a *.sql file. I need to import that query into one of my crystal reports. Anyone know how to do this?
  10. IainK

    crystal reports 8 and above

    Could someone please tell me the main web-related advantages of upgrading from Crystal Reports version 7? Cheers, - Iain
  11. IainK

    asp generated reports

    I'd be VERY interested in a solution too! Is online user driven selection a new feature of 8.5? Is it good? - Iain
  12. IainK

    Crystal in a browser

    ...in a dhtml form, which info from that database will be displayed. - If selecting paramters for a report while in a browser window (when the *Report Information Needed* box appears), you cannot select from a drop down menu but must type in your choice. Additionally, you may only select one...
  13. IainK

    drop down paramter list

    Maybe this is the problem... I am trying to create a paramter prompt where users can select the DATABASE they wish to view. I have added all the relevant databses to the report.¨ How can I make a paramter box that will include a drop down menu where the user selects tha database they wish to...
  14. IainK

    drop down paramter list

    Cheers, I am running version 7. I have added numerous 'default' values in the paramter field. However, when I open the report from a browser the promt only shows a single text box with one value (the first from the list in the 'edit parameter' box).
  15. IainK

    drop down paramter list

    Hello all! And a happy friday to ya! I am trying to create a paramter that will prompt to user to select a name. When the "enter paramter values" box appears, I would like a drop down menu so the user will select one of the given options... How do I do this? Right now I can only get...
  16. IainK

    version 7 and 8 - what's the diffeence???

    I guess I'm not the only one who doesn't know then!!!
  17. IainK

    version 7 and 8 - what's the diffeence???

    I am trying to develop a website that accessed reports from CR. i am currently using version 7.0 What are the main web'advantages of changing to Crystal Reports Pro 8.0? Crystal Reports Developer 8.0? Please! Need help urgent! - Iain K
  18. IainK

    Passing parameters from ASP to Crystal

    what url appears in the browser window when you click "submit"? what url would properly refer to the crystal report you are targetting? - iain
  19. IainK

    Passing parameters from ASP to Crystal

    What are you using to create your drop down menu? I have developed a page where you can select a value from a drop down menu and it will access the Crystal Report. I used Mircrosoft Frontpage and found that when I licked 'submit' the url was messy and needed cleaned up, I did the following...

Part and Inventory Search

Back
Top