Search results for query: *

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

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

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

Cheers Ken, I'm trying 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...

yes - odbc

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

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

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

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

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?

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

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

Hello all! I have been toiling away with CR (ver. 7) for a while now - and hoped some of you fine folks could tell me if I am write in thinking the following: - From a web broswer, you CANNOT manipulate which database information will be shown in a Crystal Report. (That is to say you cannot...

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

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

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

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

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

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

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