Nevermind All,

I found the answer!

"I setup a conditional display of the drill-down icon on a table report

similar to your situation.  Here's what I did:

1)     Make sure...

Moe,

I don't know if this is what you are looking for but here is what I use.

In VS.Net on data tab....

 CONVERT(numeric(9, 2), dbo.Table.Field / 8) AS Days

Hope that helps,

Kerrie

Thanks for replying. I got it finally.

Thanks again, Kerrie

Thanks for replying!!!!!!

I finally figured it out last night. I had to group by one of the select statements (INVD Table) and do complex where statements on the INVD and...

Thanks for the reply.

After going and reading through everything, I think your right. I will try that next.

Thank you so much for your help!!!!!

Kerrie

Thanks for your reply!!!!

Here is from dataset1..

SELECT    

SUM(CSIOWNER_ACS.V204060_INVD.AVAIL_INVENTORY) AS AVAIL_INVENTORY, SUM(CSIOWNER_ACS.V204060_INVD.LINE_INVENTORY)

                      AS LINE_INVENTORY, SUM(CSIOWNER_ACS.V204060_INVD.SCRAP_INVENTORY) AS SCRAP_INVENTORY,

                      SUM(CSIOWNER_ACS.V204060_INVD.RECV_INVENTORY) AS RECV_INVENTORY, SUM(CSIOWNER_ACS.V204060_INVD.DROP_INVENTORY)

                      AS DROP_INVENTORY, CSIOWNER_ACS.V204060_OORD.PLAN_RECV_DATE AS PLAN_RECV_DATE,

                      CSIOWNER_ACS.V204060_OORD.LINE_NBR...

Thanks, that did it!!!!!!!!! Learned something new also!!!!

Thanks for your help, I learned something new today. I did change it like you said and got the same error. So I changed...

Thanks to both of you, I got it!!!!!

I love this forum

I have a from query prompt (its own dataset), lets say a state prompt. I want it to default to Ohio. I can hard code it in. But when I...

Hi,

I do not think you can. That table belongs to dataset, once you "assign" it. I have tried with a table and a matrix, i could not get it to...

Hi,

1.)Check the report to make sure it is with in the boundaries of the page size. (To get the Report properties click on the left corner at the top of...

HAPPY DAYS ARE HERE AGAIN!!!!!

YOU GUYS ARE THE GREATEST!!!!!!!!!

Thank you both so much!!!!!!!

It worked!!!!

The report is of our product cases. (I work for a software company)

Here is my select statement

SELECT ProductName, ProductVersion, CaseSeverity, ServiceCenter, CaseStatus, CaseEnteredDate,

...

Thank you, that is the closes that I have gotten as of yet.

Is there a way to make the OPENED column include the resolved, opened, waitcust, etc? The result that...