Search results for query: *

Thanks, I will try that (GH2a,b,c). I did notice the :=, but when I error check or save it, it tells me that "The result of the selection formula must be bollean." I was not sure what I was doing that caused the bollean message. Can you suggest what I would be doing wrong that would cause this...

LB, I am still having the same issue when saving the report, it shows Generating Data for Saving Subreport Reading Records (on the bottom right of blue bar). It just keeps rerunning over and over until I end up stopping it. I have even had to stop the CRxi process form the task list once to stop...

Thank you. I will start again and be more careful to follow your instructions.

Also, 1) I have only inserted one subreport (so far) into the Main Report - Details-a. The only thing that I have in the subreport at this point is Group1 {@left5}. What should I have in the details of this report? Should I be inserting the street_name data? or is this subreport completely...

LB, When I put the suggested formula in the Group Selection (using the Formula Workshop - Group Selection Formula Editor) I got the message "Thr result of selection formula must be a boolean" when I checked the formula for errors. What did I do wrong?

Thank you LB. I will give this a try and let you know if I have any follow up questions/problems. BTW thanks for the quick responce, I have not asked for much assistance on this site, but other sites have taken days to get any responces. You guys definitely make this site the great tool that...

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

LB- Thanks, I had tried that and end up with $0.00, but I realized I was trying to do - if {FEE_TYPE} <> "FS" then sum({FEE__DUE_AMT}). Thats where my mistake was. So now I sum the new VAR from that formula and it works great.

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

Brian, Thanks for your reply. I brought that up while I've been searching for a solution to my problem and was told that they did not want me to use a command object to call the stored procedure. Although that might be a viable solution, it is not one that I can use at this time. Any other ideas???

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.

Thank you. I am sure I tried that and got some other message that I thought it was wrong, but it worked this time.

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