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 wOOdy-Soft 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: kken
  • Content: Threads
  • Order by date
  1. kken

    Org Chart Wizard - Ordering incorrect

    Hi all: I read in a csv file and create a visio doc using the Org chart wizzard. It works perfectly except for the ordering. It seems to order randomly instead of the order in the file. 'START THE ORG CHART WIZ objVisio = CreateObject("Visio.Application") objAddOn =...
  2. kken

    Automate visio from VB

    Hi all: I am using VB.net and Visio 2003. I am trying to take an excel file and make a visio file. I can actually use a .bat file to create the visio file using this command: c:\Program Files\Microsoft Office\Visio11\DLL\OrgWiz.exe" \wait /FILENAME=C:\Documents and Settings\cdaniels\My...
  3. kken

    onDemand Subreport

    Hi All: I have a report running of an ado recordset using the ttx file. I am tring to create an ondemand subreport that will prompt me for parameters and do some calculations. The problem is I can not get the subreport to prompt for parameter or even link properly, meaning no records in the...
  4. kken

    Shared Variable in Select Expert

    Hi All: I have a main report which takes in a date parameter. I need to get all the records in the subreport which have a date less then the parameter. I tried placing the parameter in a shared variable but the select expert will not allow me to use the shared var there. Any ideas will...
  5. kken

    Input data on report

    Hello all: I have been asked to create a report which takes in some values on the report itself. I started with a text object which does allow the input of text. However, I can't seem to refere to the text object to retrieve the value to use in my report. Any help with this problem...
  6. kken

    Query using list

    Hi All: I passed a comma delimited list of user ids into a parameter. The in the select record use ToText({USERS.user_id}, 0) in {?UserIDs} The problem is, if the list = 1211,1311,1411, then it will pick up Users with ids of 211 and 131 and 411. Is there a way in crystal to...
  7. kken

    Change DSN through url

    Hi Everyone: I have seen the question: How do you change the dsn through the url, but have not seen any answers. Does anyone know if this can be done through the web, mabey with the use of asp or cold fussion. Any comments would be appriciated. Thank you
  8. kken

    Blank Report

    If my report has no data then it returns a blank report. No report header or page header. Does anyone know how I could rectify this problem so if no records returned I will still get my headers? Thank you
  9. kken

    how to simulate subreport of a subreport

    I created a report (report1) that would get data based on 1 student. This report had subreports for the 1 to many relationships such as last login and max score. Then I tried to create a report (report2) to run through all students. I used the previous report (report1) as a subreport...
  10. kken

    Passing Multi-Valued Parameters

    Hi Everyone: Can you pass a multi-Valued parameter from the web to a crystal report? Thank you Ken
  11. kken

    Passing Multiple Value Parameters

    Can You pass via the web a multiple parameter that will be have the same characteristics of a multiple parameter enterd by hand? thank you
  12. kken

    How To Stop Empty Fields From appearing

    In my main report I bring in a string of ids. Parse one at a time and link to my subreport. Works great but because ids are numeric, it returns 0 after the string is parsed. Therefore I get pages and pages of empty fields. Is there anyway to prevent these empty fields from getting in the...
  13. kken

    Changing DSN

    If you have a report based on a dsn, but then want to use that report on a copy of a database in a different location. Can you change the dsn for the report or do you have to redo the entire report. Thank you
  14. kken

    Parsing Data for Queries

    I am triing to run a report based on a group. This group is decided by the user on-line. What I did was concat the particular ids and pass them into the report. This worked fine to get the values into the repot, but if I try parse the data in a formula field I can only get the first or the...
  15. kken

    Passing Parameters

    Does anyone know how to pass parameter to a subreport? I have 3 params to pass 2 in the main report and 1 in the subreport. Example that I'm usingis...
  16. kken

    Passing Parameters

    Does anyone know how to pass parameter to a subreport? I have 3 params to pass 2 in the main report and 1 in the subreport. Example that I'm usingis...
  17. kken

    Passing variables to a report

    I know how to pass 1 value to a report but I seem to be having prob passing 2 values. Here is the format to pass 1 value: Report.rpt?sf={TableName.FieldName}=ValueToBePassedIn&user0=UserID&password0=password Does anyone know the syntax to pass 2 values (both field names) Thanks
  18. kken

    Passing variables to a report

    I know how to pass 1 value to a report but I seem to be having prob passing 2 values. Here is the format to pass 1 value: Report.rpt?sf={TableName.FieldName}=ValueToBePassedIn&user0=UserID&password0=password Does anyone know the syntax to pass 2 values (both field names) Thanks
  19. kken

    Subreport Size

    I have created a report which contains subreports. The subreport is taking the max entry.(the highest) Only one record, but it is big enough for all the records of the query(duplicates are surpressed). Example! Database Field Database Field Subreport Field Database Field Database Field...
  20. kken

    Subreport boxes.

    I have created a report which contains subreports. The subreport is taking the max entry.(the highest) Only one record, but I get a box around it which is big enough for all the records of the query(duplicates are surpressed). Example! Database Field Database Field Subreport Field Database...

Part and Inventory Search

Back
Top