how to make this report?

on a timesheet system, if I want a sum of a user on each project over a given period, how can I do this without creating a view? I mean creating a view will just do the sum for that given period, but not prompting the user for the period.

the table looks like this:

empid, projid, hours,closingDate

now I want the sum of the hours on two closing dates, can crystal report prompt the user for two closing dates then do the sum for each employee on each project?You want to sum the hours on 2 closing dates.
Create 2 parameters for each closing date (in 8.0: Insert | Field Object ... on the menu, then create a new parameter value for each date that the user can enter. Be sure to select Date for data type.)

You want the report to prompt the user, so use the parameters in the report and in the select statement or Select Expert. If you named your parameters Date1 and Date2: ({closingDate} = {?Date1}) or ({closingDate} = {?Date2}).

Insert a Group on the ID.
Insert a Group under that on the projid.
Sum the hours for all groups and you will get a total for each projid and a total for the id.

Format your report to make it look like you want it to.

I hope this helps!
Kymberlie|||thx kstefanski

How to make argument/parameter optional in UDF/Trigger?

Hello,
I took over a project, and I need to make updates, modifications, pick up
where the last person left off. There is one table that is used in several
processess from external apps. This table contains an InsteadOf trigger tha
t
I need to disable for just one new procedure that am adding to the project.
I am thinking of using a UDF where I pass a value to the UDF and that value
disables the trigger. But the other processes/procedures which are already
in place obviously do not have a call to this UDF, and I sure don't want to
spend the time hunting down every process/procedure that uses this table (al
l
the external apps). Or alternatively, is there a way to create an optional
parameter in the trigger - where if a value is passed in, the trigger gets
disabled, else trigger does its thing. The other processes/procedures woul
d
not pass in this optional parameter. Is there a way to do this?
Thanks,
RichI think I am getting discombobulated. I don't think you can pass things in
to Triggers. Can you?
I am thinking I could set a value in a support table that only my procedure
would know about and then remove that value from the table when the process
is complete.
"Rich" wrote:

> Hello,
> I took over a project, and I need to make updates, modifications, pick up
> where the last person left off. There is one table that is used in severa
l
> processess from external apps. This table contains an InsteadOf trigger t
hat
> I need to disable for just one new procedure that am adding to the projec
t.
> I am thinking of using a UDF where I pass a value to the UDF and that val
ue
> disables the trigger. But the other processes/procedures which are alread
y
> in place obviously do not have a call to this UDF, and I sure don't want t
o
> spend the time hunting down every process/procedure that uses this table (
all
> the external apps). Or alternatively, is there a way to create an option
al
> parameter in the trigger - where if a value is passed in, the trigger gets
> disabled, else trigger does its thing. The other processes/procedures wo
uld
> not pass in this optional parameter. Is there a way to do this?
> Thanks,
> Rich

How to make a search engine to search my database

hi there,

i am doing a school project and i need to have this search engine that will search the data that i have stored inside the database and display the results out

can anyone help?

thanks

When you say "help", do you mean provide assistance with errors that you are encountering on something you have already started, or do you mean "do it for you"? In other words, what have you done so far?

Also, what database are you using? Which language do you use?

|||

If you are using SQL Server or SQLEXPRESS both have FullText Search indexing built in. If there is no native FullText search in some other RDBMS that you are using then try DotLucene.

|||

i am using SQL Server 2005..

i used to study .asp and now i have to change to .aspx and i find tat everything is very different..

i am just starting to do the search engine thing..

and i need some guide... =/

|||

The principals are the same in terms of the SQL. Generally, you will use LIKE and wildcard characters %.

Beyond that, drag a textbox and button onto a form, then a GridView and a SqlDataSource. The GridView needs to be bound to the datasource, which should be set up to connect to your database, and run the SQL that will fetch the search results. Follow some of the Quick Start tutorials or videos to get the hang of working with the new controls.http://www.asp.net/learn/

|||

i manage to make everything and when i test query in the sql server it works..

but when i type in the keyword in the text box and i press submit it dint work.. i have done before the dropdown list where they have this autopostback thing.but for the text how do i code the submit button?

ProtectedSub Button1_Click(ByVal senderAsObject,ByVal eAs System.EventArgs)Handles Button1.Click

Dim searchAsString = TextBox1.Text

SqlDataSource1.Select("search")

GridView1.DataBind()

|||

try this, worked for me

<asp:AccessDataSourceID="AccessDataSource1"runat="server"DataFile="~/App_Data/brakes.mdb"

SelectCommand="SELECT * FROM [table] WHERE ([field] LIKE '%' + @.field1 + '%')

<SelectParameters>

<asp:ControlParameterControlID="TextBox2"DefaultValue="%"Name="field1"PropertyName="Text"/>

</SelectParameters>

</asp:AccessDataSource>

How to make a load test a database

Common question i thing. We finished a project and about to deploy but we need tto test it. Is there a way to load random value into our tables(we got 54 tables in it). Or we need to write an application to do this. Thanks for suggestionsVSDB has a data generator which can generate various based data, either on real data, pulled fromyour produtional system or random data, based on the possible range for the data types.

Jens K. Suessmeyer.

http://www.sqlserver2008.de
|||

When I had such a requirement used DTM data generator that has worked perfectly.

FYi

How to maintain transaction between two databases?

Hi All,

Pandon me for asking such question, I am still a beginner to ASP.NET.

I have a project that require me to do single operation that is suppose to update two databases, wonder how do I maintain transaction between these two databases? Please advise, thank you!

Are these two different databases ?? Or two different tables in a database ?

If there are two tables inside one database, then you can keep a transaction object of ADO.NET

regards

|||

They are two different database. One database in each server sitting in a WAN. =(

|||

Hi,

To use transactions across database or servers, I suggest you use the TransactionScope class.

Here is an article for your reference.

http://msdn2.microsoft.com/en-us/library/ms973865.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

sql

How to link ASP with SQL Express 2005?

Hi, I am trying to link my ASP project with my SQL server but ASp 2005 is pretty different from the earlier version. I don't even see any Data Adapter. I set all my rights for my SQL server so I believe that all I have left to do now is to link them together. I hope someone can help me.It's not that different at all from previous versions. You can check outthese tuts to guide you through it.

How to limit number of rows displayed in a report from a report designer

How to limit number of rows displayed in a report, i' am using report project in Visual studio 2005 to design my reports

How to use page navigation once i deploy the report on to report server..?

Hello Kkreddy:

I have searched it for you.

I am sorry I have not found a good answer for you.

Your problem seems to be a pure report server problem.

I will move your thread to the report server forum.

I believe you can get a more rapid and precise answer there.

Thank you very much.

How to limit number of rows displayed in a report from a report designer

How to limit number of rows displayed in a report, i' am using report project in Visual studio 2005 to design my reports

How to use page navigation once i deploy the report on to report server..?

Hello Kkreddy:

I have searched it for you.

I am sorry I have not found a good answer for you.

Your problem seems to be a pure report server problem.

I will move your thread to the report server forum.

I believe you can get a more rapid and precise answer there.

Thank you very much.