To add records to include in report .

(0) Share

Report

Posted on by Dineshkarlekar

1,457

I have created the report which is having only controller class and data provider class , now the report runs directly showing all the reocrds but data is also correct but i need to show the dialogue which show the reocrds to include and so i can filter the records with project id . can any one help me on this .

my code is below .

Categories:

Development / Customization / SDK

All responses (13)

Answers (0)

Dineshkarlekar 1,457 on at

Like (1)

Report

To add records to include in report .

hi ,

Layan Jwei

Thanks for reply ,

I am still working on it , some requirements are changed so i will update u soon about it .

thanks ,

Regards,

Dinesh,
Layan Jwei 4,845 Super User on at

Like (0)

Report

To add records to include in report .

Hi Dinesh,

Is your question answered or do you still need help?
Martin Dráb 225,985 Super User on at

Like (1)

Report

To add records to include in report .

Now you're saying that you want no query, but you started this query by saying then opposite: "i need to made to show records to include". The section "records to include" is about query filters. Trying to filter a query without having a query makes no sense.
Suggested answer

Layan Jwei 4,845 Super User on at

Like (1)

Report

To add records to include in report .

Hi Dinesh,

I explained to you in my previous reply how to do that.

Looking at your code in RDP class, you created a query by code for projTable.

So instead of doing it by code, look for a standard query that has projTable alone. If you didn't find one then create a new one, then add the attribute that i mentioned in the previous reply.

And now instead of creating the query by code, you can use it directly

So instead of q = new query();

Use q = this.parmQuery();

And instead of q.addDataSource use q.dataSource

And btw I think while(queryRun.next()) is enough, no need to loop again and say while select projTable

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future. You can do this by ticking the box "Does this answer your question"
Dineshkarlekar 1,457 on at

Like (0)

Report

To add records to include in report .

thanks for reply,

but i dont have any query for this report , how can i achive that .

thanks ,

Regards,

Dinesh.
Suggested answer

Waed Ayyad 3,904 on at

Like (2)

Report

To add records to include in report .

Hi @Dinesh karlekar,

Add this attribute to your DP class SRSReportQueryAttribute(queryStr(YourQueryName))] and make sure your DataSource has the Dynamics Filter is set to true.

Thank you,

Waed Ayyad
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Suggested answer

Layan Jwei 4,845 Super User on at

Like (2)

Report

To add records to include in report .

Hi Dinesh,

I can also see that your RDP class doesn't have this attribute [SRSReportQueryAttribute(queryStr(YourQueryName))]

If you don't have a query or there is no standard one you can use, then maybe you need to create a new one. I think you need one for ProjTable. Then build the project and deploy.

After that, maybe try again and right click on the dataSet and click restore, and maybe right click on the DTProjListInvoiceTable and click restore. You should see that the parameters nodes have sth new. Then deploy and build again

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future. You can do this by ticking the box "Does this answer your question"
Suggested answer

Martin Dráb 225,985 Super User on at

Like (2)

Report

To add records to include in report .

They key thing you're missing is having your RDP class decorated with SRSReportQueryAttribute.
Dineshkarlekar 1,457 on at

Like (0)

Report

To add records to include in report .

No dynamic filters was set to "True" before . i have not change any thing in report

Do i need to change anything in controller class.

thanks,

Regards,

Dinesh
Suggested answer

Layan Jwei 4,845 Super User on at

Like (1)

Report

To add records to include in report .

Hi Dinesh,

Did you make dynamic filters "true" just now? if yes, expand the parameters node and see what's inside

then right click on the dataSet and click Restore (i think parameters should be updated and will show the dynamic parameter), then deploy the report and check again

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future. You can do this by ticking the box "Does this answer your question"