customizing a report

[NuJoizey]

i used to be a whiz a programming msAccess reports - now I'm using MSSQL reporting services, and i'm a lost puppy.

One of the things I could do in access was if I had an ORDERS report and the underlying dataset included CustomerID, but not CustomerName, in the codebehind module, I could return CustomerName by doing something like SELECT CustomerName from tblCUSTOMER where CustomerID=1, and dumping the returned value from the recordset into a textbox on the report on one of the reports events.

I have the same situation now in reporting services. I want to grab CompanyName and stick it in the heading of my report such that every time the report pages, the CustomerName shows up....but I only have CompanyID available in my dataset.

Is the answer that I have to modify my underlying dataset using JOINS to get the values I want?

 

[xlbo]

You can create a new dataset that does a simple query based on ID and returns just Company Name - you can then feed that into the textbox

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question