Search results for query: *

Good Afternoon, I good really use some help. I am using CR XI and am pulling data using SQL Server 2005. I am creating a report from two SQL tables that have no common fields and no way to add one to link them together. That being said: Table1 has street names and address descriptions for every...

I am using CRXI pulling data from MSSQL2005. I am joining 2 tables (TPABLS & CLASSES) joined on their Key. Using the parameter: {?Date Range} The Select Expert: @Date_Paid = {?Date Range} start & end ,TPABLS.voidcode (is not one of) D,V ,CLASSES.clocode (is equal to) C Printed on report...

I am using Crystal Reports XI and am having trouble totaling part of a table column. My parameters are: {?Calendar_Year} and {?Calendar_Qtr} My Record Selection Crteria is: {FEE_STATUS} = "PAID" and {FEE_TYPE} in ["TS", "PL", "ME", "FS", "FM", "EL", "BM", "BU"] I am trying to get the...

I have a report set up with a hyperlinked on-demand sub report. The question was raised: Can you change the link to open on a single mouse click instead of a double click? I have not found a solution and thought I would throw the question out to the experts here at Tek-Tips. I am using Crystal...

I am using CRXI SP2, MS2005. I have created a report from a stored procedure that uses two parameters. The first parameter is {?schedule/on-demand}. Where the user chooses either "S" or "O". If an "O" is selected the user needs to fill in the second parameter {?inputdate}. If the user selects...

When using a SQL stored procedure in Crystal Reports (XI), can you edit the input parameter that the user needs to fill in to run the report? My SP input variable is set as DATETIME, but I would like the user to be able to input only the date.

I am a new user to crystal. I am using Crystal XI against a SQL Database. I am trying to write a simple formula to the sales price based on quantity purchased. What I have tried is: NumberVar SalesPrice; SalesPrice := ToNumber({Orders_Detail.Unit Price}) * {Orders_Detail.Quantity} I get the...