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 derfloh 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: skiabox
  • Content: Threads
  • Order by date
  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

    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...
  3. 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.
  4. 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 ...
  5. 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.
  6. 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
  7. 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!
  8. 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.
  9. skiabox

    Insert a text object in cross-tab

    I am using crystal reports 8 and I cannot insert a text object right to Row#1 Name. Any idea how to achieve that? I have seen it in a report created with crystal reports 10.
  10. skiabox

    Move decimal separator using Format Field

    Can I use Format field to move the decimal separator? Fro example to divide a number by 100. Thank you!
  11. skiabox

    Cannot insert a second formula in cross-tab

    I am using crystal reports 8. I have created a cross-tab and a formula that I use in this cross-tab. I then created a second formula for the cross-tab but I can't use it still it is not appearing in available fields in the cross-tab. Any idea how to solve this? Thnx!
  12. skiabox

    Change the named displayed based on value

    I have a crosstab with one Group (Row #1 Name : @Month (Number)). This grouping produces 12 rows with the number 1-12 taken from the formula. It is something like that 1 2 . . 12 I am trying to get the Group name to print a month name like 'January' but no luck till now. I use the group options...
  13. skiabox

    How to have more that one cross-tab in the same report

    I think that the title speaks from itself. I have created 3 cross-tabs and I want to have them in the same report. Is this possible? Thank you.
  14. skiabox

    How to document my database

    I have a sql server database and I want to find a way to document it (I mean to find a utility that can map it and then I can add description to table fields so that I know what they contain).
  15. skiabox

    Report with 4 different parts

    I want to make a report with 4 columns that work independently one from another.I mean that every column must have a different grouping, different summaries etc. Any idea how to do that? Thank you!
  16. skiabox

    Sum a total per hour

    I have two columns. The one column has a total field from a table and the other has a time only(not date) field taken from another field of the same table. I made a sorting by the time field and it begins the sorting after midnight 00:00 and it arrives at 23:59 or something like that(it is a...
  17. skiabox

    How to verify that I am on the first record of a group

    Is there any way I can enter in a formula a condition that it will be true when I am in the first record of a group?(It is placed in Group Footer). I have a formula that display a calculation but it repeats itself across all group records. I want to have the calculation displayed only in the...
  18. skiabox

    Stored Procedure for crystal reports

    Can you help me with this problem? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97205 Thank you very much.
  19. skiabox

    Use a programming language instead of crystal

    Can I use a programming language to make some parts of a report that are difficult to be done with crystal language and how can it be done so that I generate a rpt file?Thank you!
  20. skiabox

    Suppress if a condition is true

    How can I do that thing? I mean to suppress a field if a condition is true? Thank you!

Part and Inventory Search

Back
Top