Search results for query: *

We wrote a Crystal Reports Viewer in C#. The viewer works very well if we use only tables in our reports. If we use Commands, we get a logon screen. In that logon screen it is impossible to enter the Server and the Database because this fields are disabled. It is possible to enter a username and...

Hi, We wrote a Crystal Reports Viewer in C#. The viewer works very well if we use only tables in our reports. If we use Commands, we get a logon screen. Of course we don't want that. We reset the the data source for each table, but it don't work apperently for Commands. This is the code that I...

No I don't update the data. What I want to do: 1) Get the data from the Excel file 2) Put the data in a DataTable 3) Write the data in the DataTable to the SQL-Server So, I want to write a tool in VB.NET to import data from an Excel File and put this data in the SQL-Server. I don't know if it...

The problem is something else, it will be a problem in my .NET application. Something with the data source binding... I think my application does only support dynamic data source binding for tables and not for commands... Thx for your suggestions ksaab2002!

The problem is something else. I tried also the UpdateCommand but it doesn't work.

I've replaced the sqlconnection by an OleDbConnection. I'm using now also the Provider keyword in my connection string. I get no error. (I replaced also the SqlDataAdapter by an OleDbDataAdapter) But it doesn't work yet with the OleDbConnection.

Hi, I try to import data from an excel file in my VB.NET application in a datagrid, this part is succesfully. Then I want to write the data in the datagrid in my SQL Server, but this fails! I think the problem is the SqlCommandBuilder, but I can't find the problem. (I use VS.NET 2003 and SQL...

Crystal Reports 10 (Developer Edition)

I forgot something... If I click Finish in the logon prompt, I get the message: Logon failed. Please try again. Bart.

Hi, I use a table combined with a Command (SQL command). (I use an OLE DB connection) in a report. When I try to view the report, I get a logon prompt. In that logon prompt I can only enter the username and the password. The dropdownbox Server Name and Database are disabled. I use a .NET...

Hi dgillz, I know that crystal reports automaticly will prompt for the parameters. But what I mean is, which parameters are mandatory and which are optional in the screen "Enter Parameter Values"? Bart

Hi! If you use parameters in a report, when is it required to enter a value for those parameters? In my opinion, numeric parameters are always required... Is that correct? :-s Thx in advance Bart

Hi Gary and Peter I didn't use the like-operator in the Record selection formula but the =-operator. {Item.ITM_CODE}={?artCodeSelection} The ITM_CODE is a string. It seems to be not necessary to use the like-operator. What do you think? Thx for your useful help!

Crystal Reports 9

Hi, I tried to use wildcards in the parameter field window, but I get a wrong result... I used the * wildcard. Is it possible to use wildcards in the parameter field window? If possible, which? Thx!

Hi lbass, the language is defined in the row field. I have a table Item and Item_price. An item may have one or more prices. As row items, I use: item_code, item_description, item_unit and item_desc_language The column item is: item_price_code and the summarized field is item_price The...

Hi all, Is it possible to hide rows in a cross tab? I made a report based on a cross tab. Some records are more than once in the table, for each language once. If the user speaks French, he want to see only the record with the French description. But now, all records appears. So, I do not...

hello, I have the same problem as ajdesigns. It is a bad idea to work with Crystal Designer, but do you have an alternative if you can't link the fields on the traditional way? ->there are concatenate fields in some tables :-( thankx

Hi all, I made a report based on a query that I made with Crystal SQL Designer. Everything works ok on the computer that I used to made the report, but I have problems when I run the report on another computer. Of course, the datasource is wrong. Is it possible to pass the servername from CR to...