You are not authorized to post a reply.
|
 Prev Next
|
| Author |
Messages |
|
mikerennick
Regular Poster
Posts:16
 |
| 05/20/2008 10:56 AM |
 Alert
|
Can you please explain what is going on in this snippet of stored procedure code below:
-- 2. document page-repeating fields
declare @docfields table ([Value] varchar(128), xpos real, ypos real, width real, height real)
insert into @docfields select '',
0.5, 0.2, 5., 0.3
insert into @docfields select '',
6.5, 0.2, 1., 0.3
select [Value], [xpos], [ypos], [width], [height] from @docfields
declare @fields table (col1 varchar(256))
insert into @fields select '' + 'Beldin Technologies - Custom Software Solutions' + char(13) + @Title
select * from @fields
delete @fields
insert into @fields select 'Created '+convert(varchar(50),getdate())
select * from @fields
-------------------------------------
I see that you are setting up fields that will appear on each page (at the position you specify -- presumably the header and footer), and then filling those fields with values. But, I am confused about the following:
1. Why is there an open fontsize tag and no close fontsize tag?
2. Why does the field definition have a fontsize tag and then the value for that field also has one of its own?
3. What are all the possible values that might be used here? How are we to know what the options are? What is the "data" tag, and why is it used here? I have never seen a "col_halign" property before -- other than you using it here, how would I know it exists? How do I find out all of the other options that just happen not to be in the examples you have so graciously provided?
Where did you learn about these values? can you send us to the same external sites?
|
|
|
|
|
charliesolomon
Nuke Expert
Posts:50
|
| 05/21/2008 9:39 PM |
Alert
|
Hi Mike,
Thanks for your questions. I sense a tone of frustration in your post... sorry if that's the case. Let me address these as best I can:
First, the "fontsize" tag does not have a closing tag because that's how I built it... when PdfReports sees "fontsize=X" in a field, it strips out the tag and sets that field's font size. I agree it would have been a better choice to have an openng AND closing tag... but I built this module 4 years ago and there are some folks out there using it with this syntax.
Second, the field definition gets overridden by the fontsize tag in the actual data... only the text after the tag will have a changed font.
Third, the "data" tag specifies that this field expects a single column recordset (read: select statement returning records) which will be used to fill the field with rows of data.
I apologize for the non-standard tag names... I don't claim to comply with any HTML standards for these tags. I do realize that a better faq is in order for all the options - I had something like that way back when and will look it up for you and post it.
Thanks. |
|
Charlie Solomon
Beldin Technologies |
|
|
mikerennick
Regular Poster
Posts:16
|
| 05/22/2008 2:58 AM |
Alert
|
Hi Charlie,
I did not mean to sound frustrated, but reading it back I guess I did. I am on a very tight deadline, and this module will do almost everything I need. However, I am struggling to make small adjustments as I do not have your coding scheme available to me.
I would greatly appreciate a link to an FAQ -- even a four-year-old FAQ.
I tried to look at the source code to understand what is going on, but all the action is in the compiled DLL.
Thanks for your help,
Mike |
|
|
|
|
charliesolomon
Nuke Expert
Posts:50
|
| 05/22/2008 11:25 PM |
Alert
|
Mike,
I just updated the "Getting Started" post in this Pdf Reports forum (the post is pinned at the top now).
It now includes an attached PDF with a reference to the different formatting tags available. Let me know if you have any questions.
-Charlie |
|
Charlie Solomon
Beldin Technologies |
|
|
mikerennick
Regular Poster
Posts:16
|
| 07/16/2008 3:25 PM |
Alert
|
I am selecting some text like this (sub []) in my SP:
SELECT '[fontstyle=BOLD]Some text[fontstyle=Normal]more text[fontstyle=Italic]italic text[fontstyle=Normal]more text' Letter FROM Table
The whole thing is bold -- I assumed that I could switch the style as I have above -- am I wrong? |
|
|
|
|
charliesolomon
Nuke Expert
Posts:50
|
| 07/18/2008 11:33 PM |
Alert
|
| Unfortunately yes, you're wrong. The fontstyle tag is only read per line... if you put a [br] tag in there the next fontstyle tag will work. The BizraftPDF library would have to be changed to handle them on the same line. |
|
Charlie Solomon
Beldin Technologies |
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.6
|
|
|
|
|