同时为差异用户提供Crystal Report [英] Crystal Report for difference user at same time

问题描述

亲爱的所有人，

我的查询是我已经借助多个表制作了一个水晶报表.

我从差异"表中收集数据并传递查询以生成表TEMP，并使用该表进行报告.

完成工作后，将删除此TEMP TABLE.

现在出现问题了，我正在为多个用户制作项目，同时两个用户将在差异表上生成相同的报告，这会产生错误，因为如果第一个使用temp second的用户无法生成相同的报告.

我如何在所有系统上使用此表，同时查看差异报告.

问候，


Jatinder Gupta.

Dear All,

My query is that I have made a crystal report with the help of multiple tables.

I''m collection data from Difference table & pass a query to generate a table TEMP & use this table for making report.

This TEMP TABLE is delete after done the work.

Now problem is occurs I''m makeing project for multiple user & same time same report will generate by two user on difference table it create error because if first one using temp second is unable to generate the same.

How I can use this single table on all the system see difference report at same time.

Regards,


Jatinder Gupta.

推荐答案

你好，

代替临时表，使用表变量.试试吧.

谢谢
Sanjeev

Hello,

Instead of temptable use table variable. try it out.

Thanks
Sanjeev

您好，
您可以将常规表的类型设置为临时表格式，并且每当用户请求报告时，SQL处理都会将报告显示信息放入此表(临时表)中，并添加用户上下文值，主键)，然后可以显示它.

因此，如果同时另一个用户请求相同的报告，则可以执行相同的sql处理并使用不同的键将其添加到同一表中..
基本上，您可以依次向此临时表中添加任何并行进程...

查看或打印报告后，您可以清理该键的临时表行.

锁定和等待的其他选项只会阻碍您的用户体验.
谢谢

Hello,
You can make a regular table of type your temp table format, and when ever a user requests for a report do the sql processing put the report display info in to this table(ur temp table) and add an user context value, sort of (primary key) for the request and then you can display it.

so if meanwhile another user requests same report you can just do same sql processing and add to same table with different key..
basically you sequentially add any parallel process to this temp table...

Once report is viewed or printed you can clean the temp table row for that key.

Other options of locking and waiting would just hinder your user experience.
Thanks,

这篇关于同时为差异用户提供Crystal Report的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！