KevRob
KevRob
About
- Username
- KevRob
- Joined
- Visits
- 0
- Last Active
- Roles
- Members
Comments
-
Ok, cheers. Could you not check the provider of the connection to determine what symbols to use? I dont mind replacing the connection object as a work around but just wanted to know if you thought it was ok or not? I know what the connection n…
-
Sorry, encountered problem:( All our report files need to be able to run on any database type. These could be standard reports we create or ones the user creates. Original I was using the OleDBConnection to cater for the different database type …
-
Cheers for the RefreshTable() change. Just want to check if there is any reason I shouldnt use the RefreshTable() method to add new report tables aswell as updating existing ones; instead of InitSchema()? Just saves me having both methods in my S…
-
Cheers. Will this affect any calculated columns that the user may of added? AlexTZ wrote: » Hello, I will make visible the table.RefreshTable method in the next build. Did you manage to put an extra Restriction on the data objects…
-
Hi, Im trying to get the table schema for an existing report to update using the code below but any new columns I add to the database are not visible in the report designer. If I edit the table within the report designer and then go through the w…
-
wrote: This is just a simple way to restrict the "dumb" user from doing something unwanted. I will try to add a new flag in the Restriction that can't be set from the designer, and hides all properties completely Brilliant. wrote: Also …
-
Ok. You have converted me from using the OleDbConnection:) Nice one for putting this feature in so quickly. AlexTZ wrote: » - I've added the Restriction property to all data items such as connection, datasource, column. The property has se…
-
I see what your saying about the escape symbols being dependent on the database type especially if the Access escape symbols are always used for OleDB. Do you think this is a problem with the underlying OleDB Provider for SQL Server? Would of though…
-
Hi, The connection string works in the FR designer, all tables are visible to select but there is no + synmbol next to the tables to expand to see the fields. Only way I can get a list of fields is to re-edit the table once the connection and tab…
-
The columns are not populated when using the OleDbDataConnection with SQL (unfortunately this is the connection type I am testing/evaluating). If I use OleDbDataConnection with Access, MsAccessDataConnection or MsSqlDataConnection all columns as you…
-
Hi, AddHandler sorted the problem with the EnvironmentSetting component. Thanks. Have noticed that the DatabaseLogin event is firing more than once for each connection. When designing a new report using the connections as below it fires 7 time…
-
Hi and cheers for the quick reply. I did try using the CreateAllTables() method but I dont want to add all the tables and some of the tables are SQL Queries so I didnt see the point. Would be nice if there was a method that would define all the c…