Search results for query: *

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

Hi synapsevampire, As I prepared my answer this morning and started testing again, I was surprised to find that the report worked! I can only assume that the settings that we updated on Friday afternoon relating to the maximum number of records for CRS to return did not get applied straight...

We have recently upgraded to Crystal Reports Server XI R2 (From Crystal Reports Server XI) and I have a problem with one report which gives me the error "Max processing time or Max records limit reached". I have changed the settings for the Report Application Server : Max Number of Records to...

I need to create a crosstab which is organised into Weeks (1-52). Needless to say that is a lot of formulas for a manual crosstab and I wonder if there isn't a smarter way. The reason for not using a standard crosstab is that there may not be data for every week, but each week needs a column. So...

Solved! It turns out that the report was set to use 2 columns, but was using portrait orientation, so the second column couldn't be seen.

I have a basic report which has a Page Header, Detail, and Report Footer section. The Detail section gets clipped after one page. The second page just shows the Page Header and the Report Footer. If I vary the margins on Page 1, I can see more or less data, it just won't display anything from...