Mazda MX-6 Forum banner

1 - 3 of 3 Posts

·
Premium Member
Joined
·
10,652 Posts
Discussion Starter · #1 ·
I'm wrestling with a reports problem.

We have a bunch of canned reports in mssql 07, as well as a few custom ones.

I'm not a dba guy - and though i can modify the existing reports to pull different data - i can't write one from scratch to do what i need.

What i'm looking to do:

create an asset details catalog page.

ie: currently, i can run a report that has the following details, laid out side by side... and the goal is to have this data presented in a single page printable format that can be put into a binder to create location details packets for our campus. Think "staples product page"

--------------------------------------------
Heading

Category: furniture

Item Type: Office Chair

Location: Office - John Smith

Color: Brown

Material: Leather

Notes
---------
---------
---------

[picture]
--------------------------------------------


Perhaps I'm having a brain fart here.. I can't think of a way to get from A to B. I basically want a preformatted page.. can be web based.. that will pull this data for each record (approximately 2500)

I can export the data, obviously.. and have been trying to do something like a mail merge.
 

·
Premium Member
Joined
·
18,203 Posts
Shouldn't this be handled by your Engineering or Executive Departments? Or do they, and you got this dumped on you?
 

·
Premium Member
Joined
·
10,652 Posts
Discussion Starter · #3 ·
lol its the tennis association. we have a dev team, but no one has seen them in 3 years.. lol.

nah this is on me, since its a rollout only at the NTC, not nationwide.
 
1 - 3 of 3 Posts
Top