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. foru11

    How to make vertical lines end with details

    Hi, I am using CR10, Oracle 11g. I am facing a problem with the vertical lines going till the end of the page. There are more details at next page. I would like the vertical lines to end at the horizontal line but I have no luck in solving this problem. (You may refer to attachment for...
  2. foru11

    How to make the vertical lines end with the details

    Hi, I am using CR10, Oracle 11g. I am facing a problem with the vertical lines going till the end of the page. There are more details at next page. I would like the vertical lines to end at the horizontal line but I have no luck in solving this problem. (You may refer to attachment for clearer...
  3. foru11

    Is it possible to connect to a CSV file as datasource?

    Hi Pete, Thanks for your opinions. I guess I need to inform the other party to make it as comma separated. [smile]
  4. foru11

    Is it possible to connect to a CSV file as datasource?

    Hi Pete, Thanks for prompt reply. Another question to ask, is the CSV file must be in comma-delimited? Could it be in semicolon-delimited? How would CR treat the data in CSV? When I tested with my CSV file, the result shows in CR is 1 whole line of data as below. How could CR separate the data...
  5. foru11

    Is it possible to connect to a CSV file as datasource?

    Hi, I am using CR10. Would like to know is it possible to connect to a CSV file as datasource? If yes, may I know the steps to connect? So far, I am only able to find steps connect to Excel file but no help in CSV file. Thanks in advanced for the help.
  6. foru11

    Is it possible to connect to a CSV file as datasource?

    Hi, I am using CR10. Would like to know is it possible to connect to a CSV file as datasource? If yes, may I know the steps to connect? So far, I am only able to find steps connect to Excel file but no help in CSV file. Thanks in advanced for the help.
  7. foru11

    How to use for loop in a formula?

    Hi Ian, I have tested using your suggestion but still no remark come out. Wondering what would be the problem? Thanks.
  8. foru11

    How to use for loop in a formula?

    Hi Ian, Thanks for replying. Actually I need to get the total record number to do the loop. I thought the recordnumber will have the total record count. My mistake. May I know how can I get the total record count? I will have a test at your suggestion after I get the total record count...
  9. foru11

    How to use for loop in a formula?

    Hi All, I am using CR 10, Oracle 11g. I would like to get a data field from the table but it doesn't seem working. User is allow to select more than 1 record to print at the report. Here is my formula: numbervar i; numbervar cnt := recordnumber; stringvar str; for i := 1 to cnt do ( if...
  10. foru11

    Subroutine Formula

    Hi MrFuzzwah, would you mind telling more on your solution to this case? As I am having this problem as well. Thx..
  11. foru11

    Dynamic XML datasource

    Hi I am using CR10, setting XML as datasource. I would like to know is it possible for me to set the XML file name as dynamic? Meaning that the system that going to integrate with my report will generate data into XML file with a numbering. Eg: deliveryorder_001.xml, deliveryorder_002.xml...
  12. foru11

    How to display word 'Continue'

    Thanks LB. The result is exactly what I'm expecting. Appreciate much for your help.
  13. foru11

    How to do a dynamic seq count in Roman numerals?

    Oh, it won't go to very high. It works perfectly!! Thanks a lot LB.
  14. foru11

    How to display word 'Continue'

    I am trying to limit to 4 records per page for the details section. The report is group by invoice number. The report will show detailed description for the invoice number. The page number will reset when the invoice number is changed. Invoice number is a parameter pass by selection screen...
  15. foru11

    How to do a dynamic seq count in Roman numerals?

    Hi all, I am using CR 10, Oracle 10g database. I have use the Running Total to do a dynamic seqno count but it is in normal numeric form (1, 2, 3...). But user wants the seqno to be in Roman numerals form (I, II, III....). How can I do this? Thanks in advanced for help.
  16. foru11

    How to display word 'Continue'

    Thanks for replying LB. I have tried on the number of records limitation function. I put {#yourrunningtotal} > 4, it displays 4 records on 1st page, but the remaining it is not display on 2nd page. Is there anything I've done wrong?
  17. foru11

    How to display word 'Continue'

    Hi Bruce, thanks for replying so fast. InRepeatedGroupHeader will print at second page. But if I would like to print at the bottom of 1st page? Which method should I use? I have tried the alternative way suggested, but that giving me a problem that it will only print after the last line of...
  18. foru11

    How to display word 'Continue'

    Hi all, I am using CR 10 and data source is from XML file. I have requests from user as below, a) the report is currently group by invoice number. If the invoice number having details that will print to second or third page, user would like to have the word 'Continue' on page 1, page 2 etc...
  19. foru11

    Cross-Tab or Grouping

    I have tried your formula. It works perfect as I wanted! This is something I can't think of. Thanks again LB.
  20. foru11

    Cross-Tab or Grouping

    I will have a try on your suggestion and thanks LB. By the way, I found out a solution to make the sorting I wanted. Insert a group using {table.location}, choose the sorting "in a specified order". Then at the Specified Order tab, I arranged the location name (N1, N2, C1, C2, S1, S2) in the...

Part and Inventory Search

Back
Top