I would like to snake the contents of the field “FunctionName” across and down 3 columns of a sub-report.
I have set the text field at 4”. In the columns tab of Page Setup, I’ve set it at 3 columns; Same as Detail box checked, and Column layout is Across, then down.
In the Property Sheet, “Can Grow” and “Can Shrink” are set to No.
When I open the sub-report it does not snake across but list down one column. Appreciate any help.
Manuel
11  2529  NeoPa 32,556
Expert Mod 16PB
In the Page Setup window there is a tab named Columns. Near the bottom are Radio Buttons to select between Down, then across and Across, then down.
Yes, NeoPa, in the Columns tab of Page Setup, I've seleted the "Across, then down" and yet it doesn't work.
@Manuel:
This appears to be one of those problems that cannot be easily resolved without the DB in front of you. Is there any chance that you can Upload a subset of the Database stripped of any confidential information? If this is possible, kindly provide detailed info such as: Report Name, Sub-Report Name, etc. to accompany the Attachment.
ADezii,
I have a Word document that contains screen prints of the sub-report and related query, but I don't know how to submit it.
@Manuel:
I'm afraid that a Word Document would not do it. I would need to view or reproduce the problem first hand to see what actually is going on. This is my opinion, maybe someone else can hopefully assist you better than I can.
By a subset of the database, do you mean a database with all the related elements, such as table, query, and report? If I can provide such a database how do I send it to you as an attachment, as the Post Your Repoly box doesn't have an icon for me to send an attachment?
NeoPa 32,556
Expert Mod 16PB
So you have. Sorry for not remembering you'd said that already when I posted.
I can only suggest you post the sizes (Heights & Widths) of your Detail Section and your pages, although if you were expecting 3 columns and only got 1 then I can't imagine why that would present like that.
Yes, but how can I send the attachment now that I can only reply in the Post Your Reply box. There is no mechanism for me to reply with an attachment.
I've got it working! Thanks NeoPa and ADezii for your help. There were several problems. First, I had set the page setup with the sub-report within the main report. I should have made the page setup on the sub-report independent of the main report. Second, I had set the column width too wide. And Third, I forgot to set the Can Grow and Can Shrink property values to NO. Once I did all that it worked. Thanks guys for your help.
NeoPa 32,556
Expert Mod 16PB
It can be somewhat complicated I know. Sometimes it can only be made to work when you spend a lot of time and concentration ensuring all the various contributing factors make sense as a whole. I expect you had to go through that process, so congratulations for getting it all sorted :-)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Nikola Pecigos |
last post by:
Hi,
I have the following problem:
We have an Oracle 9.2 with one table "document" which contains a path
to the filesystem. If I want to index these files (HTML, PDF, World,
Excel, etc.), I...
|
by: vikram.cvk |
last post by:
Hello Experts,
Im trying to design a CSS vertical drop down menu which should have the
following functionality.
Home
About Us
|
-->Overview
|
by: L. D. James |
last post by:
Can some tell me of a syntax to search for a text string that might be
in any column in a table. Something simular to:
SELECT * FROM mycontact WHERE * LIKE 'string';
Thanks in advance for any...
|
by: NotGiven |
last post by:
I'd like to have several levels of field selection. For example, field one
has three choices. Once you choose on form field one, several selections
show in field based that ARE BASED ON your...
|
by: gregory.sharrow |
last post by:
I need to secure a datawarehouse table at the row level based on 1 to
many keys on that table. A user should only see the rows they have
access to. I need to be able to figure out which rows they...
|
by: doninsbca1 |
last post by:
I want to start at the macro level (or query level) and document the queries, sub-queries, and tables that macro or primary query uses. I don't want to have a documenter that goes down one level...
|
by: Andy |
last post by:
Hi there, can anyone suggest a simple way to display data on a page
across several columns, much like you can in Word when you set the
number of columns. Ie you get a newspaper effect:
ID ...
|
by: scott |
last post by:
Hello all,
I am ripping my hair out over this and maybe someone could help.
I have a site that has groups and subgroups of those groups that all
have int id's.
I am trying to have a...
|
by: vinitfichadia |
last post by:
Hello Pals,
In VB.Net, I am having textbox which has autocomplete source of 100 strings, i want feature in which, the list of 100 strings drops down once the specific textbox gets the focus.
...
|
by: vasavivenu |
last post by:
Hi,
Is it possible to datagrid binding single data field in different columns? Please give any related simple example.
Thank You,
vasavivenu
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
