Recent content by krishnappan

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

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

i am working on crystal report 11

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

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

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 !!

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

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

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

Thanks a zillion PatriciaObreja and all others ....

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

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

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?

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

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