[Paul Lynch]

sorry forgot the attachment!

Attachments:

1. 

   vlookup.jpg
   

[Paul Lynch]

Just wanted to say a big thanks Alex this code did the trick!

[Paul Lynch]

Hi Peter,

Did you ever get this working?

What is the Training/Conference example page where you wrote comments?

[Paul Lynch]

Sorry one more question.

DFFS installer, lets you install it for the
NewForm.aspx
EditForm.aspx
DispForm.aspx

I created a new/custom editform.aspx (form) in SharePoint Designer. The idea is to use DFFS to make all the editable fields READ only, so I can print it. Seems to fix most formatting options.

If I manually dump the loader and overlay on my new editform2.aspx page, into CEWPs it doesn’t seem to work. I’m basically copying everything that’s on the real Editform.aspx page and hoping it wil load.

Perhaps because it is not actually called “EditForm.aspx or the default edit page?

Is this even possible?

[Paul Lynch]

Thanks Alex, I’ve been away trying to figure this out. I just want to clarify two things;

For my Dispform.aspx – I have a single TAB with all the fields listed in sections that I want to print. I guess this is as close to a custom print tab as I will get?

If I click in browser to print page in this tab/page, it keeps all the formatting fine (in landscape as you say). But each page cuts certain lines of the text. It appears, this is one large table so you say there is no way to add page breaks in between the sections headers via HTML. I cannot have text cut in half when printing.

If the text breaks cannot be resolved, then I guess it rules out printing via the browser?

This only leaves the option to print via the “DFFS print tab option” – this shows everything, no page breaks/text cut in half.

It just doesn’t look great. It’s black and white (when you use browser to print page, you get all the formatting like coloured zones etc..)

Also if you have a very long question in column 1, then yes/no answer in column 2. The first column is quite small and wraps the text.

Just to confirm – you cannot format this way of printing.

If the above two things are confirmed, I think I have exhausted every avenue and will just have to use the DFFS print tab unformatted.

Thanks and Happy New Year!

[Paul Lynch]

I think rather than page breaks, I think using the DFFS print tab is the way forward here.

Main issue now then is that text is cut off when I go to print the form. (see image).

Is there a way I can use CSS to limit or resize the form/tab to ensure no text is cut off e.g. forcing a max-width of the form?

Ideally I’d also like to be able to put the headings in bold and increase the width of the left questions columns (but no CSS seems to work when I print).

Attachments:

1. 

   form_dffs_print.png
   

[Paul Lynch]

Sorry I need to update, actually in IE, the DFFS Print tab is picking up and showing the vLookup table (just Chrome that isn’t).

[Paul Lynch]

Sure I will post

1) original form in browser (chrome)
2) Browser standard “print page” button (print preview) – shows up vlookup (but cuts off text due to HTML table).
3) DFFS print tab button – showing up as generally unformatted text, also does not show up the vlookup table from the form. Does not cut off text though!

Attachments:

1. 

   Original_Report_page.png
   

2. 

   report2_chrome_print_page.png
   

3. 

   pdf1.png
   

[Paul Lynch]

It seems to drop all formatting though when I click on the DFFS print button. I’m not sure how to grab the CSS classes from the print preview in order to add them into the CSS tab.

Also I notice the vLookup table disappears/do not render.

So guess that option is out?

[Paul Lynch]

Ok thanks that is good knowledge.

So potentially I can add CSS to the “Print Active Tab” by placing it in the “Custom CSS Tab” and change the format to make it look pretty?

[Paul Lynch]

Btw if I add the “Print Tab” option in DFFS, it will print the whole form, but it drops all the formatting so where you have long questions in the form, the text wraps up so small it is really hard to understand the form.

[Paul Lynch]

It can expand quite massively tbh so not sure if this image is any good.

________________________________________________________________________

Thanks I was able to work out the CAML to manually add the filters with your code!

<Where>
        <Or>
            <Eq>
                <FieldRef Name='Deployed' ></FieldRef>
                <Value Type='Text'>Internal</Value>
            </Eq>
            <Or>
                <Eq>
                <FieldRef Name='Deployed' ></FieldRef>
                    <Value Type='Text'>Identified</Value>
                </Eq>
                <Eq>
                <FieldRef Name='Deployed' ></FieldRef>
                    <Value Type='Text'>In development</Value>
                </Eq>
            </Or>
        </Or>
</Where>

Attachments:

1. 

   charthelp8.png
   

[Paul Lynch]

This is an Office 365 E3 licensed SharePoint Online Team Site

I’ve attached the console image (although some object arrays are cut off not sure how important they are)..

Also I pressed F12 on the chart page, whilst in edit chart view. (Not sure if that is relevant).

_________________________________________________________________________________

In order to get this chart ready for me to demo

I’d like to filter the chart to only show the entries in the list where the
“lookup column name” – (internal fieldname) is as below..
“Portal Status” – (Deployed)

This looks up another list called “Chart List”, picks the Title field (internal fieldname is also Title).

3 Title values I wish to show;
Identified
In development
Internal

_________________________________________________________________

Separate question – is there any function in the chart software to rename returned values? E.g. if I were to rename the above “Internal” as something else like “Deprecated”. Or at least rename their values in a legend?

Thanks!

Attachments:

1. 

   charthelp6.png
   

2. 

   charthelp7.png
   

[Paul Lynch]

Just to let you know, the CAML Query drop down does not work for me. even without using any lookup columns!

[Paul Lynch]

I actually need to filter out some data in the look up column. So really need the CAML working if possible.

To make a specific filter, I thought I had to update the view of the chart, that the CAML pulls from, which I have done. Unfortunately if I try to then select CAML drop down, top update the code, it just populates a single word “undefined” in the query box.

So for me to get this to work I will have to manually write the exact CAML query for my filter, which I am not sure how!

Perhaps I can try this without a lookup column and modify the CAML from another chart test page.

It would be good to get this working again though.

[Author]

Posts