I have a database that i use for hydrant inspections. There are about 15 different items per hydrant that need to be inspected. About 2000 total hydrants. I have every item that needs to be inspected as a separate field in my master table. My problem is, i need to compile a report for every hydrant. I would like some type of list view with like 20 hydrants per page but that is impossible with how many different fields there are. I really only need to show a field if there is a problem. Im kind of lost on how to handle this and was curious if anyone had any suggestions. One thought i had was if a field had a problem, it could send some custom text to a text box stating the problem. Then on my report i would only have to display that text box. But there are so many fields and more that one thing can be wrong with the same hydrant and i am not an advanced enough user to code that properly... sorry if this is confusing and if i need to clarify anything, just ask and i will.
13 1616 zmbd 5,501
Recognized Expert Moderator Expert
A long shot for me; however, have you tried a cross tab query/report? You might be able to fit the columns as the headers and the hydrants as the rows? Or are you looking for a different format?
It would make it alot easier for us to present help and for you to undersaid said help it we speak from the same context. Could you please show us your table layout (Field names and types) as well as a few example records?
example records is challenging because they vary.... for the asset_id its obviously just a number, the other fields are mostly ok, not ok, or yes or no... pretty basic.
zmbd 5,501
Recognized Expert Moderator Expert
Apparently, the firewalls here are blocking the image... I've tried to fix it so that is shows. Hopefully, TheSmileyCoder can see it :)
As for the records... just a simple CSV format would be good:
[field1],[field2],[field3],[field4]
1, some record info, Y, N
2, another record, N, N
3, YAR, Y, Y
Table format such as:
tbl_name
[field1] primary key, autonumber
[field2] text(50), required, no duplicates
[field3] boolean
[field4] boolean
-z
Weird I could see the image earlier, and now I can't. Odd.
One approach could be to have code that checks each field, and if "negative" adds text to a combined string, and the report then shows said combined string.
Start by placing all the fields you want visible into your report. Then add in all the fields you want to combine onto your report and set their visibility to False. You can make them as small as you want and delete their labels too if required.
Finally add a textbox where you want the "summary" status to be printed on your report. In this case I callde it tb_Combined. Make sure it has its "CanGrow" property set to true.
Then in the reports Detail Format event: - Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
-
Dim strC As String
-
-
If Me.Drainage & "" <> "OK" Then
-
strC = strC & "Drainage: " & Me.DrainageComments & vbNewLine
-
End If
-
-
If Me.Drip & "" <> "OK" Then
-
strC = strC & "Drip: " & Me.DripComments & vbNewLine
-
End If
-
-
'Add more field checks in here if needed
-
If strC <> "" Then
-
Me.tb_Combined = Mid(strC, 1, Len(strC) - 2) 'The -2 is to remove the last vbNewline.
-
Else
-
Me.tb_Combined = "OK" 'Nothing wrong at all.
-
-
End If
-
-
-
End Sub
-
-
ok going to try this tomorrow... thanks for the help and i'll let you know how it goes. i really appreciate the help guys.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Jonathan |
last post by:
We have a production database, but due to the crippling load of some
reporting tools, we are looking to have a separate reporting database.
Due to it's nature, the reporting database doesn't need to be as up
to date as the master, perhaps it could be refreshed every evening?
What I wish to know is the best way to go about this. Replicating a
whole database seems excessive as there are 7000+ tables and we don't
need it so closely...
|
by: Mohammad S Khan |
last post by:
I am currently doing some research on reporting features provided /
compatible with dotnet features. Our current application has excel
reprots that are emailed both with an without scheduling through a web
front end that uses coldfusion as well as asp. There are custom vb
compnents that generate the data as well as stored procs on a sql 2k
servers that produce the data. The requirement is for excel reports
and pdf reports, web viewing if...
|
by: jez123456 |
last post by:
Hi
My users, use ms access for querying and reporting on a backend database,
however they need to replace ms access with a new reporting tool.
I’m thinking of developing my own reporting engine in C# to replace the
existing ms access model.
Are there any c# reporting application samples that I could look at to get
started?
|
by: Paul Say |
last post by:
I have a asp.net application that will need to create a document/report from
data in a database. The user will fill out a form supplying various criteria
for parameters. I would like the document/report to then be displayed on
screen as well as the option to download in PDF format.
I am just wondering which is the best reporting development tool to use
between SQL Reporting Services and Crystal Reports.
The report will have three...
|
by: Woody Splawn |
last post by:
I am asking this question here because I asked this question in the
Reporting Services Newsgroup and did not get an answer. Does anyone know if
Reporting Services is intended to work in a client/Server or Local machine
environment? Based on what I have seen my guess is yes but that is a guess.
In some materal it talks about it running on a web server but my supposition
is that this does not necessarily mean that it would not make for a...
| |
by: John |
last post by:
Hi
How do .net reporting tools (including in vs2005) compare to reporting in ms
access? I am moving over from access and hoping that all my reporting needs
will be fulfilled.
Thanks
Regards
|
by: rmk |
last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services
both working on my development laptop ?????
I have ASP.NET 1.1 and 2.0 installed on my laptop.
I have Visual Studio 2003 and 2005 installed on my laptop.
I have my default website configured for ASP.NET 2.0.
I have the developer edition of SQL Server 2000 installed on my laptop as
|
by: YellowFin Announcements |
last post by:
Whitepaper: "Yellowfin Reporting" enables Embedded Business
Intelligence
--------------------------------------------------------------------------------
Embedded reports are a standard requirement of most applications. But
users are increasingly demanding more sophisticated reporting from
applications - seeking such features as custom report design, ad hoc
report creation and analytics. Developers that want to embed business...
|
by: JTP PR |
last post by:
Business Intelligence software company, Yellowfin today announced its
successful foray into the Asia Pacific telecommunications sector
through its expanding partner network. Two organisations, InterAcct
Solutions and Utilibill have selected the Yellowfin web-based Business
Intelligence (BI) reporting application as the front end presentation
layer for their customer business reporting solutions throughout Asia
Pacific.
The Yellowfin BI...
|
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...
|
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,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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,...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |