Recent content by oticonaus

The scheduled report also succeeded. So, I am not entirely sure a) what was wrong b) what fixed it and c) why the SQL account was getting locked... but it is working and that is the main thing. Thanks Hilfy and Turkbear.

Hi Hilfy, Yes, I have historically set the db username and password in the CMC (under Process / Database) and set "Use the same database logon as when the report is run". This report was in fact working fine under that setup for some time before it stopped working one day. Since then I have...

Hi Turkbear, Can you clarify? In Infoview, I have set the report to ask for a username, and when I run it I use one SQL account. I am using my own AD username to run Infoview. Regards, Derek

Furthermore, it seems that the SQL account password is getting reset/corrupted in the process!! So once the SQL account is unlocked from SQL Server Management Studio, I can try and run another report, and it fails - the account gets locked. In order to proceed, I have to reset the password, then...

I have a Crystal report with 2 data sources - both MS SQL. I have one SQL account which I use for authentication for both datasources. This account is used on lots of reports and works fine. Similarly these datasources are also used on lots of other reports without issues. If I run the report...

This is strange. I have Crystal Reports XI R2 SP3. I have written a simple report with a crosstab which runs fine (from Crystal) using 'hard coded' static filters. I then add a dynamic parameter (type DateTime). When I run the report, I select the value(s) - as soon as I press OK, I see the...

Crystal Reports XI R2 I have a report with 2 fields positioned on top of each other in the details section. One of them is conditionally suppressed using a formula. In Crystal Reports XI, that works fine. If I view the same report in Infoview (Crystal Reports Server) the suppression does not...

Yes, I have come to a similar conclusion. I made one big command which incorporated all of the necessary tables, and made it as efficient as I could, and that seems to have done the trick. I still don't really understand why it happens that way, but I am out of the current pickle and on to the...

Hi there, I am running Crystal XI R2 against a MS SQL Server. I have 2 commands which are both UNION queries. If I add both commands to a report and link them with an Inner Join, it runs fine. If I then group by one field (which is indexed) from one of the comands, then the report suddenly...

It is a system DSN.

If I fix the problem by pointing to a new instance of the same datasource (with the same username) it works fine, which rules out rights being the issue.

I am using Crystal Reports XI R2 and querying a MS-SQL database (64-bit Windows 2003, SQL Server 2005). Recently the SQL db servername was changed. I updated the ODBC Datasource to use the new name and was then able to connect again. Existing reports did not work - even though the datasource...

Hi There, I am having trouble obtaining stable results for what should be a simple report, and so am calling upon you out there to help me out and possibly point out the obvious. I have two tables - a Customer Master File (CusMa), and a Description Master file (DescMa) - the CusMa file is the...

Hi There, I am having trouble obtaining stable results for what should be a simple report, and so am calling upon you out there to help me out and possibly point out the obvious. I have two tables - a Customer Master File (CusMa), and a Description Master file (DescMa) - the CusMa file is the...

Hi There, I am having trouble obtaining stable results for what should be a simple report, and so am calling upon you out there to help me out and possibly point out the obvious. I have two tables - a Customer Master File (CusMa), and a Description Master file (DescMa) - the CusMa file is the...