Search results for query: *

Hello, When reports scheduled on the Infoview Server are scheduled against Microsoft Access 2003 tables located on our local server I get the following error messages.Error in File ~tmp19286c705807b00.rpt: Unable to connect: incorrect log on parameters This error does not ocurr with reports...

Hello, I have a query situation similar to the one below. The issue is I would like to return only one record for each exeption number dbo_V_CXP_CUSTOMER_PXP.QXP_EXCEPTION_NO but I also need to return a component number in the record but the table that contains the component number could have...

Thank You, I have reviewed the document you suggested. I have a little different situation as I am using my first group to filter duplicate records and I have my main report linked to a sub report due to pick up my count data I am using for my percent defective that I need to graph that ends up...

Hello. I have ver XI. I have a field that is calulated in a montly summary band from a shared variable from a sub report and a summary count from the main report giving me the percent defective for each month. The calculation works well but when I include a graph in the report footer grouped...

I need to create a field to use as link to an outside database in the SQL expression Builder in Crystal Rep XI. I am able to get Month()+ Year() from a date field but I need to Convert Month() to string + Convert Year() to string + "String" Then I would have something like 122009AB as my...

Hello, I need to use a Vba expresion in a query calc field. Presently I use the expression below to determine the shift grouping in a query for my report but I now have 3 shifts. Shift: IIf([Team Number]>199,"2","1") I need to use a Vba expression -If Then Else - so that...

Hello, I am trying to use the Dlookup function to validate data entered into a table. I would like to check an alternate table to make sure the value exists in that table using the validation rule property of the text box on the data entry form. If the value does not exist in the alternate...