Comments by RodzGold - CodeProject

RodzGold 26-Jan-16 23:37pm View

In notepad i have this code something like @echo on
start http://localhost:56090/Login.aspx and save it as filename.bat file. I right click the file and create shortcut in desktop. So when I double click the shortcut,a a new window of browser is open with the site address http://localhost:56090/Login.aspx which is the address of my localhost. But it does not display anything. It says "connection refused". My goal is to have a shortcut icon for my localhost system without generating the code generator. Thanks.

RodzGold 11-Nov-15 0:28am View

Okey,there is no much code i used. In rdlc report i insert textbox1 and drag the date field from report data source there. Right click inside textbox1 and i choose 'Expression'. I change the text there from =Fields!(Date.value) into =Day(Fields!Date.Value). So it is like this: Given this textbox1 of November 2015. I have no problem with month and year. Only in dates of the day. Thanks.

RodzGold 11-Nov-15 0:10am View

In the date field i change the expression into =Day(Fields!Date.Value) but it has no suffix only the date of the day like 25, 23, 22 and 21 so the result is like this: Given this 25 day of November 2015 instead of 25th day of November 2015.

RodzGold 28-Aug-15 20:21pm View

I just use the code above and filter the Quantity <> 0 so the result is the rows with Quantity not equal to 0 so i got the result i wanted. I use code generator in filtering anyway. Thanks guys for your help.

RodzGold 28-Aug-15 2:21am View

I tried modifying your code like this:
SELECT dbo.tblBasicPermitFeeSchedule.RecId, dbo.tblBasicPermitFeeSchedule.CertType,
COUNT(dbo.tblRequests.RequestNo) AS Quantity
FROM dbo.tblCedula INNER JOIN
dbo.tblRequests ON dbo.tblCedula.RequestNo = dbo.tblRequests.RequestNo
RIGHT OUTER JOIN
dbo.tblBasicPermitFeeSchedule ON dbo.tblRequests.CertType = dbo.tblBasicPermitFeeSchedule.RecId
GROUP BY dbo.tblBasicPermitFeeSchedule.RecId, dbo.tblBasicPermitFeeSchedule.CertType
UNION
SELECT dbo.tblBasicPermitFeeSchedule.RecId, dbo.tblBasicPermitFeeSchedule.CertType,
COUNT(dbo.tblRequests.RequestNo) AS Quantity
FROM dbo.tblBarangayClearance INNER JOIN
dbo.tblRequests ON dbo.tblBarangayClearance.RequestNo = dbo.tblRequests.RequestNo
RIGHT OUTER JOIN
dbo.tblBasicPermitFeeSchedule ON dbo.tblRequests.CertType = dbo.tblBasicPermitFeeSchedule.RecId
GROUP BY dbo.tblBasicPermitFeeSchedule.RecId, dbo.tblBasicPermitFeeSchedule.CertType

but the result is like this;
RecID CertType Quantity
1 Clearance 2
1 Clearance 0
2 Cedula 4
2 Cedula 0

I want a result just like this:
RecID CertType Quantity
1 Clearance 2
2 Cedula 4

i think i'm getting closer. i hope someone can give me some light. Thanks.

RodzGold 28-Aug-15 1:58am View

thanks but i got errors in both solution you gave. in the first solution this is ther error:
Column 'dbo.tblBasicPermitFeeSchedule.RecId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
I tried removing the RecId column but still says the next column is invalid in the select list.

also in the second solution i got errors Incorrect syntax near the word 'AS' and as i tried removing the word,it keeps saying Incorrect syntax in the next word.

Comments by RodzGold (Top 6 by date)