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 Rhinorhino 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: tttggg
  • Content: Threads
  • Order by date
  1. tttggg

    formula help for row suppress

    I have a summary report with 2 groups, City and customer. Canadian cities have only one row for each itemid and US Cities has 2 rows for each itemid. I need to suppress rows for the following conditions: 1.when the 2 discount values are zero (Canadian cities) 2.In US Cities both rows has to be...
  2. tttggg

    Problems with Number formatting

    I’m using the following formula hoping to get the last 4 digits of a number Right (totext({tablefield}),4) But it gives me only the last digit. Table field result 1.5,138 8.00 2.14,008 8.00 3.129 9.00 If my formula is wrong, can...
  3. tttggg

    formula with string

    I have 2 string fields SALESDT & SALESTM which represents the date and time. I need to display these two fields as a string as following yyyy/mm/dd hh:mm:ss I’m trying to do this but I’m not successful. Any help with this is much appreciated. Working with CR 8.5 & DB2
  4. tttggg

    Earlier version of Crystal Reports -Error

    We have a vb application to run reports and recently there are some issues where the reports are not running. I’m getting an error saying “-2147191159 Not a 4.x or earlier version of Crystal Reports” anybody have any idea what this error is. Any help with this is much appreciated CR 8.5 and...
  5. tttggg

    Help with DateTime Calculation

    I’m trying to get a time duration from two dates. But the results set is not correct. Can any one tell me what i/m missing here. My formula , If isnull ({T_ObjectStatusLogs.ClearDT}) then datediff ("h",{T_ObjectStatusLogs.SetDT},currentdatetime) Else numberVar dur :=...
  6. tttggg

    Help with date function

    I have a start date and an end date . I need to find out the date difference ( the duration ) I’m used the datediff function and got the difference in sec. Can anyone tell how can I convert total number of sec onto “mm/dd/yyyy” format. I used Date (sec) but it gives me wrong date. I’m using CR...
  7. tttggg

    How to check a database field whether its numeric?

    Can anyone tell ne how to check whether a field is numeric or not. Basically I need to check a field whether its numeric or not and if its numeric then I have to convert it into number. I’m little confused how to check a database field whether its numeric? I’m using CR 8.5 and DB2.
  8. tttggg

    report with 2 pages wide

    I'm using CR8.5 ,db2 database. I have to create a report which has many columns. Is it possible to make a report with 2 pages wide? If so can any one please tell me how. Thanks in advance
  9. tttggg

    Exporting to Word format

    Can any one tell me what is the export format code for the latest ms word. When i export a report to ms word and tried to open it, its not opening. I thing it's exporting in ms word 97.I'm facing this issue after the recent update from Microsoft. I believe that there is a code for each export...
  10. tttggg

    multiple value dynamic parameter

    Can anyone please tell me how to create an multiple value dynamic parameter.I'm using a Command as a data source. X1R2,Postgres Database Thanks in advance
  11. tttggg

    Parameter error

    I have report with 4 parameters, Start Date, End Date, Limit (number of rows to be displayed in the report), storeID. i created the first 3 parameters in the SQL Command and working fine. With the store ID parameter what happens is when i try to append all the database values to make the...
  12. tttggg

    Formula to Suppress a chart.

    I have a report which is grouped by last seen (Date) and each group will have a Bar chart in the group footer. There is a parameter, to select the number of row to be displayed in each group. for example if the user select 25 then each group will display 25 rows. TO do this i'm using the...
  13. tttggg

    Formula help

    Can Any one help me this Issue, I have a parameter which selects the number of rows to display in the report.the parameter type is string because of the key word ALL (To select all the rows) When the user select all Rows i have the following error "The String is non numeric" the formula I'm...
  14. tttggg

    Selecting the number of rows

    I have a report with few groups.There is a parameter that enables the users to select the number of rows to display on the report. The user should able to select a certain number of rows for each group. For example if the user select 50 rows, then each group should populate 50 rows. Can any one...
  15. tttggg

    Need Help with charts

    Is it possible to break the number of bars in chart and have 2or 3 charts.For example the chart 1 will have the 1st 20 rows and the chart 2 will have 2nd 20 rows and so on. If this is possible, can you please tell me how to do it. I really appreciate your help with this issue.
  16. tttggg

    graph that spans 3or 4 pages horizontally

    I have graph with very large data (more than 300 rows).Is it possible for me to have a graph that spans 3or 4 pages horizontally. If its possible, can some one please tell me how can i do that. Thanks in advance
  17. tttggg

    how can i sort the bars in a bar graph

    Can anyone please tell me how can i sort the bars in a bar graph descending based on the value. I have Product ID, Product Name as On change of and On Show Value I have the value. On the graph I have labeled each bar as Product Name, and in the legend i have the Product ID with different...
  18. tttggg

    problems with graphs.

    I have some problems with graphs. I have some groups and each one have a graph in the GF. Some groups have only few rows of data and some have so many rows of data. Because of this my graphs with large data has alignment problems.(eg bars are too thin, labels not lining up with bars).the...
  19. tttggg

    conditionally format the the bar size in the bar chart

    Can any one tell me weather it's possible for me to conditionally format the the bar size in the bar chart I need this to do this because i have a chart in every group, and some groups have more rows of data and some rows have only a few. so the chart with few rows has very wide bar and others...
  20. tttggg

    create a parameter

    Is it possible for me create a parameter, so that the user can have an option of viewing a certain number of rows or the entire rows in the report.I would like to have a radio button ,if selected all the rows can be displayed, if not only the number of rows can displayed depending on the...

Part and Inventory Search

Back
Top