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

    Subscript OR Superscript in Crystal 11

    is there a table that covers all numbers and character values for super script? How about sub scripts?
  2. krishnappan

    Subscript OR Superscript in Crystal 11

    Hi All, I am fetching some dynamic data from the database, need one of the fields to be a superscript. Say field1 immediately followed by field2 as superscript. Like Field1-Field2valueinsuperscript. I tried using formula, HTML format but it does not work for subscript and superscript. When i...
  3. krishnappan

    Insert/Delete before running a report

    I wanted to execute some sql statements before running the report ... i found a knowledge base article which exactly says how it can be done ...but it does not work .... It actually asks you to add those statement sequentially in the command object ...when i did like that i am getting sql...
  4. krishnappan

    page header of subreport appear only in frist page

    I have a main report, in which i included a sub report, in the main report's, REPORT FOOTER section... the subreport's page header only appear on the first page. The sub report has 2 pages When i run the sub report as a stand alone report then the page header appears on both the pages. But...
  5. krishnappan

    While importing existing subreport, sub-sub report is not getting impo

    I am trying to import existing report inside a main report as subreport. The existing report has a sub report. While importing the existing report the sub report inside it is not getting imported ... pls help !!
  6. krishnappan

    Page footer to appear after detail secion

    then how does crystal differentiate between global and local variables .. if the declared variable name is the same it becomes global?
  7. krishnappan

    Page footer to appear after detail secion

    Thats perfect .. but in the second formula why you are declaring the variable again whileprintingrecords; booleanvar flag; --why declaring it again , are we not refering to the already created variable? flag = true;//note no colon --this is for comparison
  8. krishnappan

    Page footer to appear after detail secion

    I placed the following code in suppress report footer whileprintingrecords; booleanvar flag := true; And the following code in suppress page footer whileprintingrecords; booleanvar flag; flag = true;//note no colon The report footer no longer appear ...could u pls explain the logic ...what...
  9. krishnappan

    Page footer to appear after detail secion

    Thanks a zillion PatriciaObreja and all others ....
  10. krishnappan

    Page footer to appear after detail secion

    report footer was good ...but i want to suppress the page footer if its the last page ... i am a new bee ...please give me steps ...
  11. krishnappan

    Page footer to appear after detail secion

    I have vertical lines in the details section ... had a horizontal close line in the page footer
  12. krishnappan

    Page footer to appear after detail secion

    I have a table border that closes ...the report runs multiple pages ... in the last page if the report finishes in half of the page , i want to close the table there ... if i drop in report footer the initial pages will have a problem?
  13. krishnappan

    Page footer to appear after detail secion

    Once the data in the detail section is complete, i want the page footer to close right there instead of the end of the page ... could u let me know how to do that? ... i tried options like suppress blank data ...but did not seam to work ...help pls...
  14. krishnappan

    How to add more than one sql statement to command object

    Whant to execute a delete statement before i select in the command object .... i added the following in the same command object.... delete from temp_table; select * from my_table; it says invalid character ...then i tried removing the semicolon ...then it said SQL statement not ended properly...
  15. krishnappan

    Execute some SQL Statements Before Report

    In the add command i tried the following Delete from temp_footnote; select * my_table; it says invalid character ... i even tried without semicolon , then it says sql statement not eneded properly ... could you give an syntax of adding multiple statement in a single add command .....
  16. krishnappan

    Execute some SQL Statements Before Report

    Thanks for ur reply .... did you mean add command? if so is there any order in which the add command list is executed? could u pls explain what is UFL?
  17. krishnappan

    Execute some SQL Statements Before Report

    Before my report kicks off, i want to execute some SQL statements like insert delete. Could you let me know how i can do that?
  18. krishnappan

    Could not apply template to document

    I am trying to create a standard report, selected a table from the connection, table contains 5 fields, then i clicked on a template thats available Block(Blue), then i get a error saying "could not apply template to document". Any help would be gr8.
  19. krishnappan

    want to show the 2 reports one after another

    thanks for tyhe reply ... the first report is 1/2 page and the second is 2 pages ... i do not want the second report to start right after first report ... is there a way i can acheive page control ? say the report 1 occupies the entire first page and report 2 starts from 2nd page?

Part and Inventory Search

Back
Top