Dynamic Images

Hi Gurus,

here's a tricky problem. I have a requirement for a report where in for certain specific customers, the logo on the page header ( which is inserted as an image on the crystal report ) should not appear. I am novice in Crystal reporting and finding it hard to come up with a solution. Currently we are on Crystal Version 9.0. Any help on this issue is dearly appreciated.

Thank you.I would say if you insert the images dynamically. you can easily add a parameter to the company table let's say addpicture. and then if this field is set to 1 then you display picture otherwise you don't

dynamic cross tab without aggregation? PLEASE help

Ok..we have a db that the company wants to store roles in (ie,
'auditor', 'accountant', etc..) that are active for a specific date
range ...its a wierd paradigm, dont ask... but we need a specific # of
roles filled for each date...
here's the script
Create table tblRoles(RoleID int primary key identity(1,1), RoleName
nvarchar(255))
create table tblDates(DateID int primary key identity(1,1),
ProjectDate DateTime)
create table tblRolesForDate(RoleForDateID int primary key identity
(1,1), RoleID int, DateID int, NumberNeeded)
what I need to see is a table from that...like this.
1/1 1/2 1/3 1/4 1/5
auditor 0 5 5 2 0
account 5 5 5 0 15
etc...
any ideas on how to make that work? the dates across the top are
from the dates table, the names in the left column are from roles, and
the #'s come from RolesForDate...
Grrr
Replied in .programming
Please do NOT multi-post.
David Portas

dynamic cross tab without aggregation? PLEASE help

Ok..we have a db that the company wants to store roles in (ie,
'auditor', 'accountant', etc..) that are active for a specific date
range ...its a wierd paradigm, dont ask... but we need a specific # of
roles filled for each date...
here's the script
Create table tblRoles(RoleID int primary key identity(1,1), RoleName
nvarchar(255))
create table tblDates(DateID int primary key identity(1,1),
ProjectDate DateTime)
create table tblRolesForDate(RoleForDateID int primary key identity
(1,1), RoleID int, DateID int, NumberNeeded)
what I need to see is a table from that...like this.
1/1 1/2 1/3 1/4 1/5
auditor 0 5 5 2 0
account 5 5 5 0 15
etc...
any ideas on how to make that work? the dates across the top are
from the dates table, the names in the left column are from roles, and
the #'s come from RolesForDate...
GrrrReplied in .programming
Please do NOT multi-post.
David Portas

dynamic cross tab without aggregation? PLEASE help

Ok..we have a db that the company wants to store roles in (ie,
'auditor', 'accountant', etc..) that are active for a specific date
range ...its a wierd paradigm, dont ask... but we need a specific # of
roles filled for each date...
here's the script
Create table tblRoles(RoleID int primary key identity(1,1), RoleName
nvarchar(255))
create table tblDates(DateID int primary key identity(1,1),
ProjectDate DateTime)
create table tblRolesForDate(RoleForDateID int primary key identity
(1,1), RoleID int, DateID int, NumberNeeded)
what I need to see is a table from that...like this.
1/1 1/2 1/3 1/4 1/5
auditor 0 5 5 2 0
account 5 5 5 0 15
etc...
any ideas on how to make that work? the dates across the top are
from the dates table, the names in the left column are from roles, and
the #'s come from RolesForDate...
GrrrReplied in .programming
Please do NOT multi-post.
--
David Portas

Dynamic Connections

I have read the posts on dynamic connections and still am not able to get it to work. Sorry, but I need specific instructions. I know it has something to do with the For Each Loop container, and something with the package variable, but I need more instruction.

What I am trying to do is transfer data from several (86) servers to a central server (all SQL Servers). The many servers will have the same code run against them to gather data and transfer it to the central server. I have written a package with those two objects for each server, but I know that there has to be a way to create just those two objects with the connection of the first object being dynamic and just looping through some type of list.

I hope my explaination is clear.

Thanks,

Peter Cwik

This is a fairly step-by-step guide: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx

If you're getting errors - let us know the error messages.

-Jamie

|||

I've tried that, but it uses a flat file source file. I have a SQL Server source. There is enough difference that I cannot transfer the knowledge from one to the other. The settings and what not are too different. I need specific instructions, just once.

Pete