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 TouchToneTommy 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: *

  • Users: sbcsandhu
  • Content: Threads
  • Order by date
  1. sbcsandhu

    Windows AD - Authentication drop down not there in Infoview

    Windows AD - Authentication drop down not there in Infoview When i log on the CMC i get the drop down and my login and password works, I set up the Windows AD in CMC and it says it is enabled
  2. sbcsandhu

    LDAP on Crystal Enterprise

    I am getting an error when I Mapped LDAP groups. I dont know what to put in the ADD LDAP group (by Cn or dn) I get this error when I enter Report Group in there. The secLdap plugin failed to get the dn for the group Report Group this is the information I have about the ldap LDAP Hosts...
  3. sbcsandhu

    Where do I download a LDAP provider for Crystal Enterprise

    Where do i download the ldap provider? Do i install it on the Crystal Enterprise server?
  4. sbcsandhu

    parameter box opens when you open report

    Is there a way to get the parameter box to pop up , when you open the report , instead of when you hit the refresh button?
  5. sbcsandhu

    row count for each person

    cwin is the unique identfier for a person, with the query before if a person has 2 records i would get a 2 in column row_count, but how would i do this, if i want a 1 on the first record and then a 2 on the second record, currently since there are 2 records for the cwin, i get a 2 in both...
  6. sbcsandhu

    if one field is null i want to look at another field in my link

    hi , i forgot how to do this i have a table called wia and a table called indv the table wia doesnt have SSN all the time, so then what i want to do is a first name, last name , dob match so currently i have select * from wia inner join indv on wia.ssn = indv.ssn but if the ssn in wia is...
  7. sbcsandhu

    Crystal Reports 2008

    Is anyone using crystal reports 2008, my boss came by and asked me if i want to update my computer tocrystal reports 2008. Has anyone done that? is it better? anyone have problems with it?
  8. sbcsandhu

    how do i get - out of ssn

    how do i get the dashes out of the ssn 123-45-6789 would like to see it as 123456789
  9. sbcsandhu

    seperate name from one field into two fields

    I have a field called case_name the fields returns last name, first name. how can i seperate the field into two fields one first name and otehr field last name this is how its looks now case_name White Delrisha or Middlebrooks, Ashley sometimes there is no comma
  10. sbcsandhu

    formulas from report footer to my group

    i have about 50 totals on my report footer, what is the easiest way to put the same 50 totals on my group footer . is there away to do add the totals without having to create a new formula for each total?
  11. sbcsandhu

    need only month from date

    what is the formula i would use in crystal xi , so i only grab the month example 20071103 i would like to create a formula that say 11
  12. sbcsandhu

    control the number of records on each page

    is there a way i can tell my report to put like 15 rows per page whatever amount of rows i want. is there a way to do that in the section expert?
  13. sbcsandhu

    datetime to date

    my date is a datetime field. what is the function i would use to change it to only a date
  14. sbcsandhu

    how do i grab the next date

    ok, i am doing a report in sql sever and crystal reports im writing my query in sql server. I am grabbing completed appraisel activties, what i want to see is what activity did they go to after they completed appraisel. I have dates for all activites. so if a person compeleted appraisel...
  15. sbcsandhu

    when i use temp tables i get an error in crystal enterprise viewer

    Error in File wtw_caseload6: Error in formula . '{Command.LAST_NM} +',' + ' ' + {Command.FIRST_NM}' This field name is not known. Details: errorKind the report runs fine in crystal reports xi , but when i run it in enterprise, it seems like my formulas error
  16. sbcsandhu

    i want to automate my dates in crystal

    how would i do my formula in the record selection area, i want to look at the previous month every month, the report will be run on the second business day . so i would like an automated date range that will look at the entire previous month
  17. sbcsandhu

    2nd parameter to look at 1st parameter

    is there a way to do this i have my first parameter transaction successful which is Y/N then my second and third is begin date and end date if they choose Y then they can do a 6 month begin date and end date range if they choose N then they can do a 1 year begin date and end date range. is...
  18. sbcsandhu

    want to give option of "all" in parameter

    i have report in crystal xi and sql server. my report will have about 4 or 5 parameters i want to give the user the option to pick all how would i do that in my sql server query that i wrote. is there away to do it in my query and not in crystal? if i cant do it in my query, how would i do it...
  19. sbcsandhu

    ssn format

    i cant rememeber how i would format the dashes(-) in a SSN 123456789 would like it 123-45-6789 thanks
  20. sbcsandhu

    is there a way to show detail in the page header

    i want to show a case's programs. but is there a way i can show all the case's programs in the page hearder , instead of the detail section?

Part and Inventory Search

Back
Top