<html><head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000">Hi Sergey,<br>
<br>
I recreated the report to make a sample for you and there it worked. No
Idea whats wrong with the old report.<br>
Same grouping, same sorting but no data. Maybe the regions got damaged
somehow<br>
<br>
Best regards<br>
<br>
Fabian<br>
<blockquote style="border: 0px none;"
cite="mid:CAOAvatxsHqRqH=jNrjP3TDFfzyJLPV1pVxZ-3h=ivzZPZtcvEA@mail.gmail.com"
type="cite">
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="sergey_pashkov@valentina-db.com" photoname="Sergey
Pashkov" src="cid:part1.08070804.00020704@faesch.de"
name="compose-unknown-contact.jpg" height="25px" width="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true"
href="mailto:sergey_pashkov@valentina-db.com" style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Sergey Pashkov</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">17. Dezember 2013
18:35</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr">Hi Fabian<div><br></div><div>I
can't reproduce such behavior in my report.</div><div>Can you send your
project, please?</div><div>I have a db.</div><div><br></div><div>Thank
you.</div><div><br></div><div>
<br></div><div>--</div><div>Best regards,</div><div>Sergey Pashkov</div></div><div
class="gmail_extra"><br><br><br></div>
<div>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated" href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a class="moz-txt-link-freetext" href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></div>
<div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div
style="display:table;width:100%;border-top:1px solid
#EDEEF0;padding-top:5px"> <div
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
photoaddress="info@faesch.de" photoname="Fabian Eschrich"
src="cid:part1.08070804.00020704@faesch.de"
name="compose-unknown-contact.jpg" height="25px" width="25px"></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
<a moz-do-not-send="true" href="mailto:info@faesch.de"
style="color:#737F92
!important;padding-right:6px;font-weight:bold;text-decoration:none
!important;">Fabian Eschrich</a></div> <div
style="display:table-cell;white-space:nowrap;vertical-align:middle;">
<font color="#9FA2A5"><span style="padding-left:6px">16. Dezember 2013
21:44</span></font></div></div></div>
<div style="color:#888888;margin-left:24px;margin-right:24px;"
__pbrmquotes="true" class="__pbConvBody"><div>Hi,<br><br>I have a query
with some conditions. This query returns 17 rows where<br>products.categoryid
IS NULL.<br><br>SELECT<br> transaction_items.id,<br>
transaction_items.article_id,<br> transaction_items.productid,<br>
transaction_items.product,<br> transaction_items.quantity,<br>
transaction_items.net,<br> products.categoryid,<br>
product_categories.name,<br> transactions.number,<br>
transactions.tdate,<br> IF(productid IS
NULL,transaction_items.id,productid) AS groupingid,<br>
IF(products.categoryid IS NULL,'Free<br>Product',product_categories.name)
AS categoryname<br> <br>FROM transaction_items<br>JOIN transactions
ON transaction_items.transactionid = transactions.id<br>LEFT OUTER JOIN
products ON transaction_items.productid = products.id<br>left outer join
product_categories on products.categoryid =<br>product_categories.id<br>where
transactions.tdate >= $P(startdate) AND transactions.tdate <=<br>$P(enddate)<br>AND
(transactions.`type` = 'invoice' OR transactions.`type` = 'creditmemo')<br><br><br>But
when I use this query for a report, these records are missing.<br>When I
add<br><br>"AND products.categoryid IS NULL" to the query to filter
only for these,<br>the report is empty.<br><br>Is the query handled in a
different way when running in report?<br>To test I made a quite simple
report and added all information to the<br>body. Nothing there.<br><br>Best
regards<br><br>Fabian<br>_______________________________________________<br>Valentina
mailing list<br><a class="moz-txt-link-abbreviated" href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a class="moz-txt-link-freetext" href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br><br></div></div>
</blockquote>
<br>
<div class="moz-signature">-- <br>Mit freundlichen Grüßen / best
regards,<br>
Fabian Eschrich<br>
FAESCH Software<br>
<a class="moz-txt-link-abbreviated" href="mailto:info@faesch.de">info@faesch.de</a><br>
<br>
Fon: +49 (0)371 334246-10<br>
Fax: +49 (0)371 334246-11<br>
Skype: feschrich<br>
</div>
</body></html>