Dynamic Report Field Data - Microsoft Access / VBA

CSDunn

Hello,

I have a format issue on an Access 2000 ADP report that I am going to
attempt to explain from a 'ten thousand foot view' :

I have an Access 2000 ADP report that has a SQL Server 2000 Stored Procedure
as its record source. The Proc is called MM_rptTeacherGr oupingTest_sp. In
order to help communicate the issue I am having with the report, please take
a look at the following:
http://www.valverde.edu/home/policy/ReportLayout.htm .

The web page first shows the design view of the report. The idea is to show
the T(x)Percent of each StanNum per T(x)Name. The StanNums are grouped by
Strand. The Strands are grouped by Domain. All of this data is based on a
Grade and a Location2 parameter that are sent to the Proc.

The Design view shows only the first three T(x)Name fields and the first
three T(x)Percent fields. The Print Preview shot of the report shows three
T(x)Names and their T(x)Percent values. The results of the report here occur
when a field value called 'TeacherID' is hard coded in the Proc. I did this
just to show a demonstration of what the report might look like.

The query results table represents a sample of the data returned from the
Proc when the 'TeacherID' values are allowed to be dynamic in the Proc (so
the results do not match the Print Preview screen shot). Notice that some of
the T(x)Percent and T(x)Name column pairs in the query results table are
NULL for every record.

Every time the Proc executes, the range of T(x)Percent and T(x)Name fields
starts at T1Percent / T1Name and ends with T14Percent / T14Name (only seven
pairs are shown in the query results table shot). When T(x)Percent column is
null, the matching T(x)Name column will also always be null for every
record. Almost every execution of the Proc will result in null columns in at
least one T(x)Percent / T(x)Name pair.

The problem is, if I simply add all 14 T(x)Name fields in the Location2
header, and all matching 14 T(x)Percent fields in the StanID header, the
null field pairs could leave a lot of empty space in the report.

How can I set up my report so that only the T(x)Name / T(x)Percent columns
that are not completely null appear on the report each time the report is
generated?

If you need to see the code behind the report, please let me know.

Thank you for your help!

CSDunn

Nov 12 '05 #1

Subscribe Reply

2521

Similar topics

3699

Dynamic number of fields in an Access 2000 Report

by: CSDunn | last post by:

Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what a spreadsheet might show, the column names will actually be dynamic, based on data from a SQL Server 2000 database. The row data will also come from the same database. So in this case, I will have a main report and a subreport. I've already tried...

Microsoft Access / VBA

17654

Dynamic Crosstab Report

by: Nathan Bloomfield | last post by:

Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to Create a Dynamic Crosstab Report PRODUCT :Microsoft Access PROD/VER:1.00 1.10 OPER/SYS:WINDOWS

Microsoft Access / VBA

427

Dynamic Report Field Data

by: CSDunn | last post by:

Microsoft Access / VBA

3323

I need a non-example-specific description of how to do dynamic crosstab reports

by: Richard Hollenbeck | last post by:

Hello Newsgroup. You have all been very helpful in the past and I thank you. I try to ask relevant questions so that they don't just benefit me, but also benefit the group. I'm currently overwhelmed by useless examples across the web on how to make "dynamic crosstab reports" without myself having a basic understanding about how to retrieve and assign recordsources, etc., from fields in a query to fields in the report. I see all these...

Microsoft Access / VBA

3588

Dynamic Crosstab + Sub Report

by: deejayquai | last post by:

Hi I've created a crosstab query and displayed it as a sub-report in my main report. This is fine until the data changes and the column names become incorrect. I know I have to create a 'dynamic crosstab query' but I don't know how to!! I've read the "How to..." on the Microsoft site but it mainly gives an example rather than explain the basics, which I can't work out. My context is:

Microsoft Access / VBA

2928

Dynamic Crosstab...SOS

by: deejayquai | last post by:

Hi I'm trying to produce a report based on a dynamic crosstab. Ultimately i'd like the report to actually become a sub report within a student end of year record of achievement. The dynamic sub-report will capture what grades the student has achieved in a list of different subjects and the reason I need it to be dynamic is that students take different subjects. Basically I've been trying to doctor the KB article on dynamic

Microsoft Access / VBA

2452

Dynamic Crosstab + Reports

by: deejayquai | last post by:

I've worked through the MS KB example and it doesn't really help me as I missing the basics of what the code is doing. I've posted a couple of times here in thsi group but with no success. Could anyone recommend a book or a website that goes through the basics of how to build dynamic crosstab queries in order to create reports that allows column fields to dynamicaly change according to the source data? Regards David, UK

Microsoft Access / VBA

17127

Is a dynamic crosstab form possible?

by: salad | last post by:

Operating in A97. I didn't receive much of a response conserning Pivot tables in Access. Pivot tables are nice, but a CrossTab will work for me too. Using a Pivot table, one is actually launching Excel for data viewing. I'd prefer the user stay in Access. Creating dynamic crosstab queries is pretty simple. The problem is that the column count may shrink or grow depending on the filter.

Microsoft Access / VBA

16727

Dynamic RDLC generation question

by: ronicard | last post by:

I'm a newbie to the messageboard, but I'm wondering if any of you gurus have tried to do the following before? I'm developing a custom reporting solution as part of a web application for a corporate client. One of the required features is a user-defined reporting (UDR) solution, but we cannot use ReportBuilder because their corporate firewalls prohibit ActiveX controls. Therefore, I have a wizard-style ASP.NET and C# interface that...

Microsoft SQL Server

18699

Create Dynamic Report : with Parent Child Command

by: creative1 | last post by:

Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however, working with complex reports is tricky Assumption: Reader of this article have basic knowledge of creating data reports. Creating a Parent-Child Command and create a DataReport Suppose we have a database called company with two tables ...

Visual Basic 4 / 5 / 6

7934

What is ONU?

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

7870

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

7992

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8225

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5732

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5400

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

3891

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1465

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1199

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General