Discussion:
CRM custom report with filter CRMAF returns no data
(too old to reply)
Eunice
2007-06-04 10:29:01 UTC
Permalink
Hi guys,

I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?

Thanks.

Regards,
Eunice
Mike Shaw
2007-06-04 16:11:04 UTC
Permalink
Hi Eunice - Could you please post the syntax of your query.

Love to help...

Mike.
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Eunice
2007-06-05 01:24:01 UTC
Permalink
hi Mike,

There is no error. It all loaded nicely, just without any data. when I
removed the CRMAF_ i could run the report with data. I don't quite know what
is wrong.

Please advise.
Post by Mike Shaw
Hi Eunice - Could you please post the syntax of your query.
Love to help...
Mike.
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Mike Shaw
2007-06-05 08:46:00 UTC
Permalink
Hi Eunice...

I am not after the error - just the syntax of the query.

Regards,

Mike.
Post by Eunice
hi Mike,
There is no error. It all loaded nicely, just without any data. when I
removed the CRMAF_ i could run the report with data. I don't quite know what
is wrong.
Please advise.
Post by Mike Shaw
Hi Eunice - Could you please post the syntax of your query.
Love to help...
Mike.
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Eunice
2007-06-05 10:16:00 UTC
Permalink
Hi Mike,

Here you are..

SELECT FilteredQuote.createdbyname, FilteredQuote.createdonutc,
CRMAF_FilteredQuote.quotenumber, CRMAF_FilteredQuote.contactidname,
CRMAF_FilteredQuote.statuscodename,
CRMAF_FilteredQuoteDetail.productdescription,
CRMAF_FilteredQuoteDetail.extendedamount,
CRMAF_FilteredOpportunity.closeprobability,
CRMAF_FilteredQuote.accountidname
FROM FilteredQuote AS CRMAF_FilteredQuote INNER JOIN
FilteredQuoteDetail AS CRMAF_FilteredQuoteDetail ON
CRMAF_FilteredQuote.quoteid = CRMAF_FilteredQuoteDetail.quoteid INNER JOIN
FilteredOpportunity AS CRMAF_FilteredOpportunity ON
CRMAF_FilteredQuote.opportunityid = CRMAF_FilteredOpportunity.opportunityid
ORDER BY CRMAF_FilteredQuote.createdonutc
Post by Mike Shaw
Hi Eunice...
I am not after the error - just the syntax of the query.
Regards,
Mike.
Post by Eunice
hi Mike,
There is no error. It all loaded nicely, just without any data. when I
removed the CRMAF_ i could run the report with data. I don't quite know what
is wrong.
Please advise.
Post by Mike Shaw
Hi Eunice - Could you please post the syntax of your query.
Love to help...
Mike.
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Mike Shaw
2007-06-08 12:35:01 UTC
Permalink
Eunice,

Please try runing this and let m:e know

SELECT CRMAF_FilteredQuote.createdbyname,
CRMAF_FilteredQuote.createdonutc,
CRMAF_FilteredQuote.quotenumber, CRMAF_FilteredQuote.contactidname,
CRMAF_FilteredQuote.statuscodename,
CRMAF_FilteredQuoteDetail.productdescription,
CRMAF_FilteredQuoteDetail.extendedamount,
CRMAF_FilteredOpportunity.closeprobability,
CRMAF_FilteredQuote.accountidname
FROM FilteredQuote AS CRMAF_FilteredQuote INNER JOIN
FilteredQuoteDetail AS CRMAF_FilteredQuoteDetail ON
CRMAF_FilteredQuote.quoteid = CRMAF_FilteredQuoteDetail.quoteid INNER JOIN
FilteredOpportunity AS CRMAF_FilteredOpportunity ON
CRMAF_FilteredQuote.opportunityid = CRMAF_FilteredOpportunity.opportunityid
ORDER BY CRMAF_FilteredQuote.createdonutc
mike
2007-06-18 19:00:02 UTC
Permalink
It has to do with the userid of the person who created the data and the
userid you are using in VS and used to connect to the DB. If they are
different, a query on Filtered data will return nothing. Is the userid you
have used in VS to build your connection string the same userid that was used
to create the quote form?
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Eunice
2007-07-06 03:32:03 UTC
Permalink
Hi Mike,

Thanks for posting. i tried the code you posted but it didn't work. Yes they
are the same userid, both Administrator. Any other ideas?
Post by mike
It has to do with the userid of the person who created the data and the
userid you are using in VS and used to connect to the DB. If they are
different, a query on Filtered data will return nothing. Is the userid you
have used in VS to build your connection string the same userid that was used
to create the quote form?
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Kotena
2011-06-27 06:47:35 UTC
Permalink
Hello Eunic,

did you solve your problem after all?

I seem to have the same problem right now.

Thank you
Post by Eunice
Hi guys,
I have uploaded 2 reports, 1 with CRMAF and 1 without. The one without CRMAF
returns data but the one with CRMAF returns no data. The query is exactly the
same. I am not sure what the problem is. Can someone please advise?
Thanks.
Regards,
Eunice
Post by Mike Shaw
Hi Eunice - Could you please post the syntax of your query.
Love to help...
Mike.
Post by Eunice
hi Mike,
There is no error. It all loaded nicely, just without any data. when I
removed the CRMAF_ i could run the report with data. I don't quite know what
is wrong.
Please advise.
Post by Mike Shaw
Hi Eunice...
I am not after the error - just the syntax of the query.
Regards,
Mike.
Post by Eunice
Hi Mike,
Here you are..
SELECT FilteredQuote.createdbyname, FilteredQuote.createdonutc,
CRMAF_FilteredQuote.quotenumber, CRMAF_FilteredQuote.contactidname,
CRMAF_FilteredQuote.statuscodename,
CRMAF_FilteredQuoteDetail.productdescription,
CRMAF_FilteredQuoteDetail.extendedamount,
CRMAF_FilteredOpportunity.closeprobability,
CRMAF_FilteredQuote.accountidname
FROM FilteredQuote AS CRMAF_FilteredQuote INNER JOIN
FilteredQuoteDetail AS CRMAF_FilteredQuoteDetail ON
CRMAF_FilteredQuote.quoteid = CRMAF_FilteredQuoteDetail.quoteid INNER JOIN
FilteredOpportunity AS CRMAF_FilteredOpportunity ON
CRMAF_FilteredQuote.opportunityid = CRMAF_FilteredOpportunity.opportunityid
ORDER BY CRMAF_FilteredQuote.createdonutc
Post by Mike Shaw
Eunice,
Please try runing this and let m:e know
SELECT CRMAF_FilteredQuote.createdbyname,
CRMAF_FilteredQuote.createdonutc,
CRMAF_FilteredQuote.quotenumber, CRMAF_FilteredQuote.contactidname,
CRMAF_FilteredQuote.statuscodename,
CRMAF_FilteredQuoteDetail.productdescription,
CRMAF_FilteredQuoteDetail.extendedamount,
CRMAF_FilteredOpportunity.closeprobability,
CRMAF_FilteredQuote.accountidname
FROM FilteredQuote AS CRMAF_FilteredQuote INNER JOIN
FilteredQuoteDetail AS CRMAF_FilteredQuoteDetail ON
CRMAF_FilteredQuote.quoteid = CRMAF_FilteredQuoteDetail.quoteid INNER JOIN
FilteredOpportunity AS CRMAF_FilteredOpportunity ON
CRMAF_FilteredQuote.opportunityid = CRMAF_FilteredOpportunity.opportunityid
ORDER BY CRMAF_FilteredQuote.createdonutc
Post by mike
It has to do with the userid of the person who created the data and the
userid you are using in VS and used to connect to the DB. If they are
different, a query on Filtered data will return nothing. Is the userid you
have used in VS to build your connection string the same userid that was used
to create the quote form?
Post by Eunice
Hi Mike,
Thanks for posting. i tried the code you posted but it did not work. Yes they
are the same userid, both Administrator. Any other ideas?
Loading...