Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sikkilamkiran

    dat format for data parameter

    Hi, I have a problem with date parameter. when the parameter page is populated and user selects the date from the date dialog. the format of display is YYYY-dd-mm but i want ot have my own format like dd/mm/yyyy Please help out as its urgent. Thanks & Regards Kiran sikkilam
  2. sikkilamkiran

    Crystal Reports Clent Problem with language.

    Hi synapsevampire, I am sorry i couldnt explain the problem well. I should say the report is showing junk charecters. we are using windows standard Arial font. the printer is also working fine. is there any reason by which we can have such problems with font. please help me , Thanks kiran
  3. sikkilamkiran

    Crystal Reports Clent Problem with language.

    Hi, I have a peculiar probelm. the crystal Reports Cleint is showing all junk charecters when i open up a report. Escpecially all the text objects are showing junk charecters. but when i run the report all of the report showing junk charecters. i have seen the local regiona lsettings of my...
  4. sikkilamkiran

    joining number values returned by a parameter

    hi all, I have a parameter on version column. i want to concatenate the values selected by a user and display them in the report. if i use join it says string array required. if i use totext or cstr to convert inside join function then it says subscript is required. Please tell me a way where...
  5. sikkilamkiran

    Dynamic grouping

    hi, I have a requirement where i have a static parameter which having the following columns Control ID - Number Control Name - char Receive date - date Data Source -char I would like to use the value selected by user as a group in my report. I tried to create a formula where if {?Group By} =...
  6. sikkilamkiran

    stored Procedure in different databases

    hi synapsevampire, im using crystal XI integrated with Business objects and oracle 9i database. the problem is i want to use dynamic database connection in repository and go for a report. but a stored proc cannot be used to create a report in repository .is it possible or else if i create a...
  7. sikkilamkiran

    stored Procedure in different databases

    hi all, I have a problem in accessing the procedure from different databases. for example i have a procedure named test_procedure in a database called ORCL and the same procedure test_procedure in onother database called ORCL_NEW now the problem is i want to dynamically select the connection is...
  8. sikkilamkiran

    groups problem

    I have a peculiar problem on groups. I have a report which is having four groups Library type Library Name Dimension value details- assessor - results - Date - Details ---- details- assessor - results - Date - Details ---- Library type can be - process,cycle,policy...
  9. sikkilamkiran

    dynamic sorting based on parameters

    hi lbass, thank you very much,i got the same idea after i posted i tried out this code and it worked.. but any how thanks for the instant reply .. you are always ready with an answer. if {?sort_column}='dimension' then {Control_Center_BE.Dimensions Name} else if {?sort_column}='subprocess'...
  10. sikkilamkiran

    dynamic sorting based on parameters

    hi all, i have a probelm on sorting. i have 4 feilds in my report (process,subprocess,control and dimension) , i want to sort the data based on the parameter passed by the user. if he passes process the report has to sort by process column, or else if user selects control the report has to sort...
  11. sikkilamkiran

    Subreport show unwanted column which is not included

    hi, I have a peculiar probelm, i have a sub report which shows dimesion name, fromdate and to date columns , the link to main report is process_id,dim_name,dim_value... when im running the report process id is geeting querried in the sub report which is just a condition column but not a actual...
  12. sikkilamkiran

    Retriving sub report Parameter values into main report

    Thanks You very much LBass.. I got the parameters and i mapped it. its really gr8 to have a solution so soon Thank you lbass once again. -Kiran
  13. sikkilamkiran

    Retriving sub report Parameter values into main report

    hi lbass, thanks for the instant reply, i have created the parameter in the main report rather than sub report and when im going to links tab there is no {?Dimension} parameter on the left side instead of ?pm-?Dimesion. please reply
  14. sikkilamkiran

    Retriving sub report Parameter values into main report

    hi, Im having a problem in retriving the sub report parameter values into main report.im using the following code. in the sub report im having a parameter called dimension. im capturing the values of the dimension using a formula DimensionValue: whileprintingrecords; shared stringvar x...
  15. sikkilamkiran

    Language setting in Crystal XI - change from english to french

    hi, i have a question... i want the data of crystal reports which is in english to be converted to spanish, french and other languages. is is possible to convert the data at reporting level if yes what are the setting required in crystal reports. i would be thankfull if any one provides a...
  16. sikkilamkiran

    Join on a Number Parameter?

    hi lbass, i have not used any formula for can grow, do we have to write a formula for "can grow". the parameter was created in business view manager, the settings for the parameter are normal, ex. for apllication LOV First step was to create a command table form exisiting which select only...
  17. sikkilamkiran

    Join on a Number Parameter?

    hi lbass, i have first used what you have given me . like "Applications Selected : " & Replace (Join ({?ApplicationLOV}, chr(13)),".", "") but it says cannot cummarize the parameter , but when i place square brakets it accpets witout any error but when executed it displays only last...
  18. sikkilamkiran

    Join on a Number Parameter?

    hi lbass, i have first used what you have given me . like "Applications Selected : " & Replace (Join ({?ApplicationLOV}, chr(13)),".", "") but it says cannot cummarize the parameter , but when i place square brakets it accpets witout any error but when executed it displays only last...
  19. sikkilamkiran

    Join on a Number Parameter?

    hi lbass, i used the join function .. let me expalin the scenario.. i have a LOV (ApplicationLOV) , its a multi select value, when user selects n values all have to be displayed. but in my case if i use the join() funcion its returning me the last application in the list. i dont know why.. i...
  20. sikkilamkiran

    Join on a Number Parameter?

    hey lbass thats reaaly quick , thanks a lot for that... i have the same problem with the string array.. i want to concatenate all the string parameter values the user selects... i have used join first it worked but after some time it gives me a problem. can you give me a solution.. thanks in...

Part and Inventory Search

Back
Top