Search results for query: *

Hello Crystel 8.5 and sql database I have a report that contains 5 groups 1 district 2 school name 3 grade level 4 class name 5 form and in the detail section i have a formula @studentname replace({Answer_Docs.LName},' ','')+", "+ replace({Answer_Docs.FName},' ','')+" "+{Answer_Docs.MName}...

hello crystal 8.5 odbc sql database I have a table that contains last name,varchr(24) the user fills in the space on a form. some will leave spaces between the boxes to fill in example B_R_O_W_N or some like this BR_OWN I need the report to filter out the blank spaces enter my the user so the...

Hi how can i create a report that looks like a spreadsheet with collumn and row and have the lines showing like in excel .i'm using cr 8.5 ans sql database cheers pg pgtek

Hi Cr 8.5 sql database I have a format problem i have 1 group and 1 detail section and multiple 1 group footer i have a rest on change of group and have keep group together check and repeat group header on each page i have a record counter in my detail section i have new page when x2 when...

hi I see the Expoert section and there one call CVS Why would i export to CVS? thanks pgtek

Hi I have a report that uses Global variable. I have this formula in the detail section and it does work fine *********************************** @Hi-Lo global numberVar HiSal := 0; global numberVar LoSal := 0; if HiSal = 0 then ( HiSal := {Employee.Salary}; LoSAl := {Employee.Salary};)...

Hello I need your help please. cr 8.5 sql database i have a report that has group and detail section. the group is ok and the detail does show up ok My problem is a have a line separating my detail section and they want me to add more line so they can fill in other data as needed., Here is what...

Hi i have a field for birth date and i got a blank memory :-( cr 8.5 sql database my field is dbo and here is the data 080994 i have formula like this @DBO left({dbofield},2)+"/"+ mid({dbofield},4)+"/"+ right ({dbofield,2}) the first 2 digit and the last 2 digit are ok but the midlle on is...

Hi I got a problem and have a memory blank lol lol i have a group1 and kepp group together check at the bottom of the page footer i have page n of m i check page footer the format section to new page after and also reset page number i have a group that has more than one page for the same group...

Hi I have a main report and a subreport. The main report runs from a storeprocedure. the field i can have to link in it is the district code. in my subreport is just a text report but it has a district code in it ans using the same storeprocedure can i link these storeprocedure together on...

hi i have this grade level and it's int i want this formula if {TestInstance.gradelevel} = 0 then "KINDERGARTEN" else {TestInstance.gradelevel} i get error string required when i change it to if totext({TestInstance.gradelevel)} = "0" then "KINDERGARTEN" else totext({TestInstance.gradelevel}) i...

hi Can you create a repot label from a txt file. Thank you pg pgtek

Hi I've been ask "What are the basic report function commom to all three editions of Crystal Report 8.5"? Thanks for your help :-) pgtek

hi Can i pass a parameter to an SQL expression here is what i have (Select E.bandlabel FROM ECL_Ranges E where E.testsectionabbr='S' AND E.eclabbr = 'A' and E.FP_Key = 2) i want to replace the E.FP_Key = {?paramter} is this possible? if so how to do it cheers pgtek

hi I have reports done in crystal version 8.5 and someone open the report in crystal version 10 and he save it to crsytal version 10 format. Now i try to open the report with my version 8.5 and i get message wrong version. Is ther a was i can get the report in version 10 to open in version 8.5...

Hello I need this symbold { to be bigger i tried diffent font size and color but I get bigger and bolder . I need longer in lenght and narrower for my graph legend Can someone help me plz. example 9 High { 8 7 the { must streech be the size to fit between 9 and 7 thanks...

Hi I have report that need only the last 2 digit of the year. My formula is year(CurrentDate) and it display 2004.00 i only need 04 i'm using cr 8.5 thank you pgtek

Hi I need some guidance in this How can Icreate a report from an ADO record set? I did some before from TTX files of an VB application,but this time there no application involve like .net stuff or vb Any help would be very helpfull for sure :-) Thanks pgtek

Hi Cr 8.5 Can crystal reports (8.5) use a DataSet as its datasource? thanks pgtek

Hi I have a problem in the background color. I have a report that has a 1 group, detail section and page n of m heres my problem i have format my group to keep together and repeat group heading on new page. in the report footer i have reset page number on change of group. in the detail...