Search results for query: *

Hi, I am trying to call an rpt that accepts parameters from a JSP/J2EE environment. The page needs to be rendered in Internet Explorer. Can anyone please provide tips/facts about how to achieve it? Thanks in advance. Addy

pgtek thanks for response but that page is not working any other way

This is in reference to the message posted in the forum section of Tek-Tips.com by you regarding "INTEGRATING OF CRYSTAL REPORTS WITH JSP". I have some queries related to that, please answer them. QUERY: How can one call a crystal Report from a JSP page with passing some parameters...

Hi Guys I am encountering this typical requirement where in i require the fields on the report to be selected by the user for e.g. i ve these four columns Column1 column2 column3 column4 123 456 789 987 982 234 332 356 i want user should be able to select the...

ya synapse the sql expression does the trick By the way i am using CR8.5 and DB2 as database Regards and Thanks to all Addy

hi there i ve been jugling with this particularly messy one hope you ppl can find something I ve got two fields called {Date) and {Time}which stores date and time values repectively but as strings so the example data is like So the different records are: {Date) {Time} 2003-8-19...

Hi About the Ticket numbers they are like 718458 718459 718460 718461 718462 718463 4453622 4453623 4453624 4453625 4662301 4662302 4662303 4662304 i hope now i ve cleared the picture a little bit more Addy

Jim The case with 1,2,3,6,9 as values the results should be dispayed as Minimum Maximum 1 3 6 6 9 9 and one more thing Jim 1,2,3,6,9 is not a string delimited by coma, they are different values for the field such as {Field value1} = 1 {Field value2}...

No Jim my string is not like 123413141516 The string field has many number values and 1, 2, 3, 4, 13, 14, 15, 16 are all different values. So as you described it is a series of numbers. And thanks for showing interest Addy

Hi Guys, Need your help on this typical one I ve got a string field {ticketNumber} but the values in this field are numbers i want to list the minimum and maximum of all the series made up of consecutive numbers within these values. For example the value for the {ticketNumber} are...

guys thanks for your responses taking some inputs from your responses and using some way arounds i ve finally found the fix. It required a view to be created in the database where i have made Count of Number IDs per code as one of the fields and then created a formula field where i pick this...

thank you Madawc , using total works upto counting now i want to display the maximumm of this count on the page header section. Is there some way to find this maximum count number Aditya Goyal Bombay,India

Guys see if you can find something to get me out of this jam i want to count number of records satisfying a particular condition. i ve got this Number ID field {NumberID) and {SomeCodeField} and i want to count number of {NumberID)s only when {SomeCodeField}= 'CD' An example about what i want to...

guys you gotta help me with this there are two groups which i ve got by using group by some field so it is like Group1 3450.00 3456.00 3487.00 Subtotal1 10393.00 Group2 3550.00 3456.00 3687.00 Subtotal2 10693.00 i want difference between...

hey guys again come across a typical one i have got this feild as primary key of the parent table for which i have as foreign key in the child table Say {ParentTable.Primarykey} maps to {ChildTable.ForeignKey} So i have multiple records for this foreign key in the child table. the child table...

hey jim sorry for starting a new thread i did that coz i saw other ppl doing that and good that thread has been deleted And thanks to you all guys i ve finally solved my problem

i ve got tables creditnote.table and invoice.table.which are linked with each other by a coomon field. They have date fields {INVOICE.INV_INVOICE_DT} And {CreditNote.INV_CreditNote_DT}. ive to select records according to whether these dates lie in a particular range ie between parameter dates...

i ve tried both Jim's and SV's solution but still iam not able to get the desired records i am gettin all the records by paasing Y to parameter ie uppercase({?parameter}) = "Y" but i am not able to get the records where {table.yesno}= 'N' by passing N to the parameter So guyz any...

hey guys a difficult problem to expain i hope i get some solution I have a string parameter to which only two values 'Y' or 'N' can be passed i.e. ?Paramter = 'Y' or 'N' If value 'Y' is passed i want to select all the records of a particular type this i ve accomplished by using " and if...

+"SomeString--"+totext({YourNumberField},0) this is working fine up to the point in removing decimal and zeros after decimal the result is now SomeString--3,45 ie I want to remove this comma also