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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by seller

  1. seller

    Crystal and Lansa web application integration

    Yep! Thanks!! I checked the link and it had a lot of helpful info but nothing addressed my need specifially. We have a some web based programs developed in Lansa. I was looking for a way for a user to pull up a report from within the program. I was hoping to use Crystal and just link it to...
  2. seller

    Crystal and Lansa web application integration

    Is there anyone who has any experience using (integrating) Crystal in a web application developed using Lansa? I am in need of some general guidance. Thanks much!
  3. seller

    Limiting record returns to Crystal

    Ido, That worked great! I had started looking at the count function but could not get it to work until you pointed out that it needs to go into the group selection. I appreciate the help.
  4. seller

    Limiting record returns to Crystal

    Sample table structure is : ID COURSENUM CODE 28244 12200100 A 15639 12200100 U 28244 44001000 A 36186 44001000 U 28244 12200100 U As you can see from the table above ID 282244 has entries of the same COURSENUM (12200100) twice. I need to limit the return to...
  5. seller

    Comparing Dates in a Range

    I am not sure where to even start with this so here is the situation... I have to return the corresponding quarter information depending on a user entered start date parameter. So if a user picks a start date of 3-13-2002 I would like to return a value of Quarter 3. Quarter 1 2002-10-08...
  6. seller

    Passing Parameters to SQL

    This is crazy sounding but after spending an inordinate amount of time tweaking the sql query and researching the issue on the web...all I did to get it the parameter to pass was to delete all the parameters in the select wizard, close and save, open and add the parameters back (using the select...
  7. seller

    Passing Parameters to SQL

    Thanks for the feedback. I cannot create a sp in sybase because this particular install is using a runtime version that came bundled with the app. Hopefully someday they will rehost to a full version of a database. As for editing the registry...would this have to be done to each end user...
  8. seller

    Passing Parameters to SQL

    I am trying to pass a user supplied parameter at run time in crystal to a sybase anywhere runtime sql server. The statement used in the select expert formula wizard is: {teacher.teacherid} = {?Teacher ID} The sql query in "Show SQl" is: [i]This runs excruciatling slow coz it returns...
  9. seller

    Open Files Report

    What NT system files do I need to access on an Win2000 server to create a Crystal report that shows which users have a share open on a client/server application? Is this possible? The situation is...Management wants a daily list of personnel logged onto an application to use for attendance...

Part and Inventory Search

Back
Top