Search results for query: *

Hello all, I am having trouble trying to figure out how to get unduplicated client counts by program and by heiarchy. Clients should only be counted once -- and only in the first program in the heirarchy below to which the client belongs. Example Program Heirarchy: Medicaid, Other Medicaid...

Just an update... I ended up exporting the report into a CSV (comma delimited) format instead. This worked very fast and the file can then be opened up in EXCEL and viewed and formatted as needed. Thank you, ~N

Hello All, I am having problems exporting my report into EXCEL. The report was created using Reporting Services - an SQL query is run producing a report that is approximately 117 pages long with 148 columns. When I try to export it into EXCEL, it just runs and runs and never finishes. I've...

Yes, thank you very much! I did find a solution. Thread # thread183-967337 was especially helpful! Thanks Again! :) ~N

Is it possible to go from this: John Smith ProgramID_3 John Smith ProgramID_5 to this?! John Smith ProgramID_3 ProgramID_5 In other words, just have one name - concatenating the program IDs. I've tried coming up with a solution but have been unsuccessful. Thank you

Hello All, I am working in SQL Server 2000 and I am trying to convert a table from this: CaseName1 Child1 CaseName1 Child2 CaseName1 Child3 CaseName2 Child1 CaseName2 Child2 CaseName2 Child3 CaseName2 Child4 CaseName3 Child1 CaseName3 Child2 CaseName4 Child1 CaseName4...