Search results for query: *

I am viewing my reports by typing in the url in the browser like this: http://server/folder1/Report.rpt It was taking a long time to display, the performance was very slow. So the suggestion was made to convert the connection to my Access database from Direct to ODBC. I changed the connection...

I have three parameter fields: Start, End and Name Start and End are pointing to the dtpicker where I can select the dates from the control and the name parameter is pointing to a list of names entered into the parameter.. {Table1.Name} = {?Name} and {Table1.Date1} >= {?Start} and...

The problem is viewing the report through the browser it takes the parameter fields too long to appear on the screen..

The overall speed is an improvement but it takes 4 minutes for the parameter fields to appear, why and how can I fix this?

I am using an Access 2000 database and running the report through a web browser simply by typing in the url of the report in the browser. I changed the connectivty from direct to odbc this improved the speed overall of the report but the only problem I have is that as soon as you type in the url...

Here is what I have placed in the Report\Edit Selection Formula: {DB1.Date} >= {?Date1} and {DB1.Date} <= {?Date2} and {DB2.Name} = {?Name} Are you suggesting to remove this and replace it with a sql string? Where and how, and what should I put using my example... Help is appreciated.. Diana

Once I type in the url of the report in the browser it takes a long time for the first parameter field to appear.. why? and how can I fix this?

It is definitely faster using an ODBC connection rather than directly connected to the database. There is only one problem I encounter and that is when you type in the url of the report, it takes a good minute and a half for the parameter field to appear on the screen. How can I fix this, if I can?

I made a copy of my db and renamed the db and the report... and made an odbc connection... when I goto refresh the report I encounter this error: Blob field or memo field cannot be used in a formula.. The thing is in my backend the field being refused is Text data type.. works fine with a...

When clicking on the Database menu the SHOW SQL QUERY item is greyed out... I cannot select it..

I am using this as my query and this is placed in the Edit Selection Formula.. {DB1.Date} >= {?Date1} and {DB1.Date} <= {?Date2} and {DB2.Name} = {?Name} I am not using ODBC, rather when I add a database to the report from Data Explorer, I double click Database Files and then select Find...

I indicated in my thread that I am using an Access2000 database. The two date parameter fields are Date data type that the user can select from the Date control... Any suggestions

I am running a report by typing in the url in the browser. I am using Access 2000 as a backend. The database contains 30000 records. A majority of the fields are indexed. My report contains 3 parameter fields, Name, Date1 and Date2... Here is what I have in my Record Selection forumla editor...

I want to create a chart with ver 8.0... When i goto select any type of chart lets say for example Bar Graph, the ok button is disabled, why is that? Am i missing a service pack or a patch?

I have a main report and a subreport. The problem is if a Name field has no value in the backend then the value of the previous name is carried over to that field... If the names contain data in the backend then the Name fields contain or display the correct values.. Should I reset the...

I have three databases. Database 1 contains the LastName field Datebase 2 contains the LastName field Database 3 contains the LastName field I am using Database 1 as my primary database. I link the LastName field from Database1 to Database2 and I link Database1 LastName field to Database3...

I run a query between two dates. Jan to Aug, but for some reason my Variable for Sept, Oct, Nov and Dec contain a value. Is there a way to indicate: if the variable is Null then assign it value 0 else variable

I am not connecting to SQL. When I click on Database menu the Show SQL is greyed out... The only other query I have is when you click on the Report menu and select Edit Selection Forumla.

I am connecting to two backends. One backend is a ODBC data source and the second is a Access database on my local PC. When I run the report I get the error Invalid Parameter number. The only parameter fields I have are dates. In my odbc I am connecting to a date\time field and in the Access...

I have two datasources: one is a ODBC and the other is a Access 2000 database. My parameter field is a Date data type but when I want to access a ceratin date field, the data type of this field is date\time.