Embedded HTML report appearing in frame

This site is best viewed in a modern browser with JavaScript enabled.

shrimp

Hi Peter, I hope you are well?

I have searched around the forum and cannot find anything similar to the issue I am having. I have installed the new Reportico and am playing with the new functionality to see whether I can improve useability of my reports.

The new html report shows in a frame on my webpage, instead of just in the page (as it used to). However, the scrollbars to the right do not work, so I can only see the first page of the report (approx 20 rows). This is a problem, as there are 146 rows!

Is there a way to remove the frame and just have the report embedded into the page?

shrimp

Just FYI, I am trialling the new Reportico version 6 on a new website. My current website has the old Reportico version 4, which shows the embedded report like this (and I prefer this!) The frame is simple, without the page replication. Page replication would be fine, if the scrollbars worked....

admin

Hi there sorry for late reply.. I think Reportico 6 had the page replication enabled by default and i dont think it was a good idea... there is a Page Layout button on the report and you can change Pagination option to None that should disable paging.. let me know if this is what you mean and whether this fixes it.

Peter

peterdeed

Peter

shrimp

Hi Peter

Thank you so much! The pagination worked to show the scroll bars, which is great. I can now see the whole report!

But I really don't like the preview appearing in the frame (not sure how to explain it). It is like a print preview, showing the page? So there is a grey area all around the report (in my first screenshot at the top)

Is there anyway to have html just embed into the page as with my second screenshot, instead of appearing in that frame (which I was calling page replication, as it replicates the print preview in Word?)

peterdeed

Ok you shouldnt see any grey surrounding the pages when pagination isnt set it should be just like the old version full width.. is it just the same as your first creenshot but with vertical scroll bars..

Wll have a look tomorrow when i look at your other issue

Also can you tell me if you instaled this version via composer or by pressing the download link from the download page https://www.reportico.org/site2/download

shrimp

Hi Peter

Yes, it is just like the first screenshot, but now the vertical scroll bars work. I tried installing via Composer but had a bit of a nightmare, so I have installed the zip version from github releases. I can use Composer on my webserver, but I am testing on a local machine using xampp (which means I have to install using the zip file) , then moving everything to my webserver (so I have to update all the links and database passwords!)

It would be fab if you can let me know what I need to do to get rid of the grey background. I am wondering if it is something to do with the bootstrap template I am using (United)?

I have just installed the 6.0.16 (I am not brave enough to install version 7 yet - maybe when I get the existing stuff working!)

I am about to go and try the fix you have mentioned for my variables issue, so wish me luck (I have been working on this all weekend, as the staff ae back in tomorrow!)

peterdeed

Hi there, glad you managed to install it..

Ok, welling if you turned Auto Paginate is off Im interested in why you still get the grey border.
Can I ask you to set the default Auto pagination to be disabled? If you edit your project config by opening

projects/<projectname>/config.php

and change the pagination default so it is turned off.. find the line that looks like

ReporticoApp::setConfig('AutoPaginate','None');

And ensure it is set to None above and not HTML+PDF meaning pagination/grey borders will appear in the report output.
If you set it to None then when you run the report it should look like below with full width report page and the paginate button .. is that what you are seeing? or is it the one after with the grey left and right margins after?

Without Pagination

With Pagination

Also version 7 will be easy to move to, it just has a lot of bugs fixed and looks better (well to my point of view!)

shrimp

Hi Peter
Thank you for looking into this. I checked the places you mentioned, and my config file already had 'None' in the AutoPaginate part.

My page does look like your second screenshot, albeit with smaller margins on the sides.
I have the report embedded into a "ONEREPORT" / EXECUTE mode, so there is no criteria entry at the top, just my navbar from my site, which allows my staff to return to the tables.

I can live with it for now At some point, I will be able to understand all the intricacies and work out how to remove it! I liked the old V4 layout that had no pagination. But I understand that the new version has a lot more functionality, which I am looking forward to learning how to use!

One small thing - I cannot get my page headers to right-justify, no matter what options I choose! Once I have 2 headers (e.g. name and address justified left), any additional headers I create (such as Account or Payment Date) just appear along the top of the page at the left (like the box Account BKF01 in the screenshot). I wonder if this is a limitation, i.e. you can only have 2 headers?

This is my page header setup

Sorry if my explanation is not very clear - I am tired and it is late! Thank you for any help you can provide

peterdeed

Ok for the background we might need to make some style changes.. it could be interfering with your bootstrap theme...

so if you edit the themes css style sheet in themes/defult/css/reportico.css ( there are a couple of other themes folder but im assuming this is the one thats relevant to you ) ....

and look at 3 places ..

Firstly find

.reportico-report-form {
/ border: solid 1px #AAAAAA; /
background-color: #999;
overflow: scroll;
/ min-width: 100vw; /
}

This sets the background colour to the grey .. you can change background-color to #ffffff

Secondly ..

.reportico-output-button-block {
width: 100%;
height: 36px;
}

This should set the buttons above the output but it seems to push your report to the left when the page should appear underneath .. try changing to

.reportico-output-button-block {
width: 100% !important;
height: 36px !important;
}

Then finally there is

.reportico-paginated {
background: white;
display: block;
margin: 0 auto;
padding: 0px 0px;
box-shadow: 0 0 0.5cm rgba(0, 0, 0, 0.5);
overflow-y: hidden;
box-sizing: border-box;
font-size: 12pt;
position: relative;
/zoom: 0.68;/
/height: 100vh !important;/
}

Take out the box-shadow to get of a subtle shadow around the page...

Also... regarding your header.. i think the reason is that your margin property doesnt provide the measurements

margin:40mm 0 0 150;

try

margin:40mm 0px 0px 150mm;

and play with the 150mm to get it right

Hope that helps