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!

Register Log in
  • 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!

Recent content by skiabox

  1. skiabox

    Problem after installing wss3 sp2

    I installed wss3 sp2 and now a devexpress control I am using in my site does not appear properly. Any ideas? Thank you very much.
  2. skiabox

    Subreport problem

    Ok.It apperas properly in the end of the main report.There is no need to print preview the sub report. Thnx for helping!
  3. skiabox

    Subreport problem

    Ok.I've tried it and it keeps asking for parameters when I do print preview to the subreport.
  4. skiabox

    Subreport problem

    I give you some more details here: The parent report takes its data (between others tables) from table1 which has a datetime column field1 which is used from the 2 parameter fields to give to the report reader a range of dates. The subreport uses only one table (that does not exist in the...
  5. skiabox

    Subreport problem

    I have a parent report that takes 2 parameter values as start date and end date. The subreport takes its data from another table that has a field with dates. I want to pass both start and end parameters to the subreport and have the report asking for them only once (not for 2nd time for the...
  6. skiabox

    How to fit my cross-tab in the 1st page

    I have a cross-tab that spreads to 2 pages.Is there anyway I can make it fit in one page only? Thnx.
  7. skiabox

    How to sort a text field like it were a number

    Thnx a lot!It worked!
  8. skiabox

    How to sort a text field like it were a number

    I have a row formula in a cross tab that contains this code : CStr({@hour1},0) + ':00' @hour1 is : hour({LABSTORE.REC_TIME}) What I get is a column like this 10 : 00 11 : 00 12 : 00 . . . 9 : 00 How can I sort this properly like it were a number? I mean like this 9 : 00 10 : 00 11 : 00 12 ...
  9. skiabox

    New formula does not appear in Available Fields in Cross-Tab

    I figured out how to solve it by pure lack. The formula must be in the detail section and if it is suppressed you must de-suppress it once!
  10. skiabox

    New formula does not appear in Available Fields in Cross-Tab

    As the title says I have created a new formula but it does not appear in the Available Fields of the cross-tab so that I can use it. I am using crystal reports 8.
  11. skiabox

    Enter the following transact-sql as sql expression field

    I've managed to do it.I used double quotes and full database names for the tables.
  12. skiabox

    Enter the following transact-sql as sql expression field

    it doesn't work.I have made it work once but I don't remember the exact way.sql expression fields in crystal are very syntax sensitive and they easily create an error.
  13. skiabox

    Enter the following transact-sql as sql expression field

    I want to enter this code as an expression field. Is this possible? SELECT SUM(QTY) FROM LABSTORE WHERE ITEM_CODE = 873
  14. skiabox

    Insert a non summarized field in a cross tab

    Can this be done? I do the sum in sql and then pass it in a sql view so I don't want any further calculations in the cross-tab. Thank you!
  15. skiabox

    Select different records in each cross-tab

    I have inserted three cross-tabs in my report at report footer. Is there any way I can have different record selection in every cross-tab? Thank you.
See more

Part and Inventory Search

Back
Top