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 Mike Lewis 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. sirpelon

    Background color for a textbox

    Thanks both for your interest... lbass The calendar is made according to a hint from the Chelsea Tech. site :), the difference is that i have to highlight two dates on each month, for example in january i have to highlight the first and the fifth day, i put the formula like N - @startday to...
  2. sirpelon

    Background color for a textbox

    Hi I need to create a report that shows a year calendar, and highlights a date on each month, i have a table with the dates that need to be highlighted, right now I'm able to show the calendar but my problem is that i don't know how to highlight the date. I put all on the report footer section...
  3. sirpelon

    Suppress blank column from crosstab

    Hi I really need help I have a crosstab with four summarized fields and in consecuence i have for columns for every column... something like this: Column 1 Column 2 Col1 Col2 Col3 Col4 Col1 Col2 Col3 Col4 Row 1 0 0 0 0 0...
  4. sirpelon

    How to format the "Sum of @Formula" in a cross-tab

    Hi, I have a cross-tab like this: Model1 Model2 Concept 1 20.00 5.00 Concept 2 3.00 2.00 Concept 3 10.57 10.23 Concept 4 1.00 9.00 I'll like to know if it is posible to remove the decimals of the concepts 1, 2, 4 and leave...
  5. sirpelon

    [b] Problem with report pages in CR viewer [/b]

    Well, i finally figured out The cause : I was customizing the statusbar and the text of the tab from the CR viewer, changing the labels of the panels and the text "MainReport", and this was causing the problem. Now everything is ok. I hope someone with the same problem find this helpfull
  6. sirpelon

    [b] Problem with report pages in CR viewer [/b]

    Hi, CR 9.0 VB.NET 2003 I have a report that's driving me crazy, the report has two parameters, both are string type but one of them allow multiple values. I use the parameter with multiple values on the record selection formula like this: {vacantes.cve_vacante} = {?Clave} This works like...
  7. sirpelon

    show the records related from a details table

    Hi Ann, thanks for the reply i figured out how to do this i create a group section (G1) by person, then i insert a section below (G1b) and put a linked subreport on it, so now, only the records related to the person are displayed and if i need to display other records from other child table i...
  8. sirpelon

    show the records related from a details table

    hi I need your help, i'm lost with this, i have four tables: curriculums sizes_curriculums values sizes Basically they have the data from the sizes of one for the curriculum or resume, i'm making a report that shows this data in this way: PERSONAL DATA Name Address Phone ... Etc. SIZES (4...
  9. sirpelon

    Access all records at once

    Hi The version number is 9, the DB is SQL and the connection is ODBC, the formulas first were placed on the details section, later on the report footer but was the same behavior. In fact i better did this: Create a sumarized field of each formula and place this instead of the formula field, so...
  10. sirpelon

    Access all records at once

    Hi everyone How can i do this? i have 10 records in a table and i need to read it all, i mean each record is a value for a formula field and i want to display the 10 formula fields on one page, but crystal is displaying 10 pages each one with the value of the formula field on the table...
  11. sirpelon

    extra column in crosstab

    Hi everyone i need your help, i have a report that uses a crosstab for show the information in this way modelo1 modelo2 .... modeloN total defecto1 0 2 0 2 defecto2 5 3 0 5 defectoN 10 0...
  12. sirpelon

    help with crosstab

    Hi everyone I´m making a report that display the info like this product1 product2 .... S2 S1 S3 S2 S1 S3 defect description 0 0 0 0 0 0 defect description 0 0 0 0 0...
  13. sirpelon

    Problem with two dropdownlist

    Thanks for your reply bassguy I figured out, previous to the code i posted, i populate the ddls with a loop incrementing the year, i used a listitem object for both ddl's, and in some way the get related, that's why the value of one ddl reply to the other. Something like this for the populate...
  14. sirpelon

    Problem with two dropdownlist

    Hi I have two dropdownlist in a page that represents the years of a period, in some part of my code i have this ddlAnoInicio.Selectedvalue=adoDatos.Item("ano_inicio").Tostring ddlAnoFin.Selectedvalue = adoDatos.Item("ano_fin").Tostring adodatos is a SqlDataReader The problem is that when the...
  15. sirpelon

    Parameter concatenation for IN condition

    Hi, i'd like to know if it is possible to concatenate a parameter to a IN condition, something like this SELECT * FROM table WHERE column1 IN (:parameter); *column1 is of type NUMBER *the value of parameter VARCHAR2 could be 4,5,6,8 once interpreted should be like : SELECT * FROM table...
  16. sirpelon

    Detect if an application is running on the LAN

    Thanks anyway johnwm
  17. sirpelon

    Detect if an application is running on the LAN

    Hi, I'm developing a distributed application for capture clients orders, i have implemented a module that monitors the sessions of the users, but only one instance of this module can be running at a time. How can I detect if there is a previous instance of this module running on my LAN, the...
  18. sirpelon

    List of SQL Servers available on a LAN?

    Hi, It's posible to get the list of SQL Servers available on a LAN from VB application? I need to display the servers list on a combo box Thanks in advance

Part and Inventory Search

Back
Top