Search results for query: *

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

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

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

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

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

I want to insert x records to a table based on some fields in a form, where x is a number entered by the user. Seemed, simple, based on my code below. However, when I run the code, it writes the first record correctly, then writes the second record twice, the third record four times, the fourth...

I have a report which currently links 6 different tables from 2 different datasources (MS SQL and Maximizer). That works fine. The current SQL query (which runs fine) is SELECT CLIENT.Name_Type, U_ACCOUNT_NUMBER.U_Account_Number, CLIENT.Client_Id, CLIENT.Contact_Number FROM...

I am using Crystal XI, and data from a MS SQL Server, and also Maximizer 9. There are 2 SQL tables (Serial_History & Customers) and 4 Maximizer views (Client, Events, Account Number, and Company Type). I am selecting customers to show based on data in Maximizer, and then calculating units sold...

I am a newbie to .net and to Active DIrectory. I have cobbled together some code from various samples to retrieve a list of Names and Departments from Active Directory. This now works well. I then query Active Directory again to determine the Manager of the selected Name. That almost works...

I am a newbie to Crystal so bear with me! I have created a very basic report which links to an Access database (Access XP - no security). When I click on the report name in Infoview, the report is displayed. However, if I schedule the report to run Now and set no other parameters, it fails with...

I have a form bound to a table, then filtered to show 1 record. If I change a field on the form, and close the form with the x, the changed data saves to the table. If I close the form programmatically from the OnKeyPress event, it doesn't save. Private Sub Form_KeyPress(KeyAscii As...

I need to represent the follwoing on a line graph X-Axis Value *1000 25 *2000 30 3000 29 *4000 40 6000 38 *8000 31 I don't want to see the label for 3000 and 6000, but I want to see the data plotted. Also, I need those with an asterisk to be equally spaced (in other...

I have 2 text boxes. txtA allows a message to be typed in. txtB shows the number of characters in txtA. However, I want the value in txtB to update as each character is typed in (or deleted) much like an SMS message. The following code only updates the value in txtB on the first key press in...

I am sure there must be an easy way around this... I have a DateTimePicker and when the user selects a date, I want to test the weekday of the date and if it is a Saturday or Sunday, then change the selected date to Monday. But as soon as I change the date to Monday, it fires up a loop. How do...