Search results for query: *

Greetings, I am developing my first ASP.NET application that uses the new Entity Framework in .NET 3.5 SP1. I am hoping someone can provide me with a tip for how-to name the Associations for my modeled entities. I have assigned custom foreign key names in my Microsoft SQL Server 2008...

Very clean & elegant! I love it. I really appreciate your help. Thank you. David

Thanks for your response. I shold have included this in my original post. There is a column in the ProjectResource table called: ResourceLevel (int) ResourceLevel = 1 is primary ResourceLevel = 2 is secondary Thanks, again, for your response. David

Greetings Everyone, I have a "Project" table, a "UserAccount" table, and a "ProjectResource" table. The ProjectResource table links a Project to a UserAccount. This is a many-to-many table. I need to create a VIEW that displays the project information and ALSO displays the first two...

Thanks for your reply. I would like to have the stored procedure that creates the temporary table to not perform the join operation. Instead, I would like a second stored procedure to call the first stored procedure and then JOIN at that point. The rationale is there will be several different...

Greetings everyone, I have a stored procedure that processes data and creates a temporary table to store the results. I wish to make the results available to other stored procedures and/or views (if possible) for the purpose of joining my results with other tables/views. I do not want to...

Thank you for your prompt response. FAQ #faq183-3132 was extremely helpful! So elegant. David PS: My customers do not have split personalities... it was in fact a type-o. :)

Greetings everyone, I wish to seek some advice and perhaps gain some insight towards how other people are approaching a similar task. I frequently use stored procedures to provide "list data" for my applications. The stored procedures usually have parameters to allow the aplication with a way...

Thank you, once again, for the help you both provided. I like all of the suggestions. I implemented the additional group approach (splitting on date) and used some additional group supression formulas to get the display I needed. Everything is now working thanks to your help! David

Thank you for your quick responses! I am using the 3 step approach using parameters (as opposed to running totals): 1) initialization in the group header, 2) calculation in the details, and 3) display in the header. Each step has its own parameter and they all refer to the same variable name...

My report shows a series of amounts in the details section of a group. Some of the amounts are conditionally supressed (e.g. when date < #some date#). I need to show the total of the supressed amounts in the group's header. How should this be approached? I created a formula and inserted it...

Okay: all of that to answer my own post. ;) I found the answer. I was accidently trying to use another formula field when calculating the opening balance. As soon as I mapped it to the proper running total field everything worked as intended. Cleary it's time to call it a day. :)

To All Those Crystal Gurus Out There: I could use your help, if you'd be so kind. I am in the process of developing a report that needs to behave a lot like a bank account statement. The report needs to show the starting balance as of a specified date (StartDateParameter) and then show all of...